Many of us have an issue after installation
of SQL server 2008 management studio as how to start and connect the local
database to check it is working fine. After successful installation of SQL
server 2008, we start the SQL server 2008 from start menu of windows and stuck
on login screen and attempt to login by windows authentication. But it does not
login simply (like it does in SQL server 2005 /SQL express 2005).
Trying with password we used in installation,
changing setting in options and many others attempts but still not able login in.
Also after trying different server name as “local”,”yourpc-yourname”, we
fail to login. Here I will tell you how to login into default database (windows
authentication /mixed mode) for SQL server 2008.
It all starts with the installation
of SQL server 2008. While installing the software please keep a note of the
instance you choose while installation and the password you kept for database
The installation asks for the
instance to be used for SQL server 2008 on “Instance
configuration” page of Installation as shown below.
If you choose “Default instance”,
then it will take the “instance id” and “instance root directory” automatically
and install the database in default location. But if you choose “Named Instance” then you can assign a
name to our database and the path where we can set our Database and also can change
the settings below.
The next important thing while installation
to note is “Database Engine Configuration”
Page as sown below.
It has tab as “Account Provisioning” and in that there
is option for “Authentication mode”. Authentication mode determines how the
database will be accessed/ connected with user/ applications.
If you choose a ‘Windows
authentication mode’ here, then you can login to SQL server 2008 always
by Windows authentication (admin/owner of the system or server).There is No ID
and Password to log in to database via web application as well as SQL server management
studio.
This is the easiest way to
install and use SQL server 2008 but limitation that your web application
needs to be on local system and you cannot access this database in network. This
method is useful only when you have a dedicated server where you have full
access to your remote server, your SQL database and your web applications.
But in case of shared environments,
we have to use “mixed mode” so that we can assign a username and a password to
login to our database. By this mode we can access our Database of SQL Server
2008 using ID: sa and Password: “you give here”
NOTE:
The password
entered here must be noted.
ID: sa
Password: “you_set_here”
The web
application as well as SQL server management studio can use this ID and
Password with server name (as PC name) and connect to data base. In network you
can use this database too by id password and server name as “IP Address” of the installation system.
(Note: Some configuration is also needed to be done in SQL server 2008, to make
it access via network. I will post that later ….. )
Any
issues or suggestion please do comment...
Above is answer to following questions
How to open local database in SQL server
2008?
How do I open
a local SQL server database?
How to connect to local instance of SQL server
2008?
Connecting to the Database Engine SQLServer2008?
After installations how to start with SQL server
2008?
How to login to local SQL server database?
No comments:
Post a Comment