How to find SQL Server name?
-
hello guys...im new to this. I have installed Visual Studio 2008 and SQL Server it, now I wanna use sql server management studio with it but on startup, it asks for server name. How can I get that server name. Moreover, should I use sql server authentication or windows authentivation? thnx
-
hello guys...im new to this. I have installed Visual Studio 2008 and SQL Server it, now I wanna use sql server management studio with it but on startup, it asks for server name. How can I get that server name. Moreover, should I use sql server authentication or windows authentivation? thnx
If you have installed a default instance, any of this should work - . (a dot indicating the local instance) or your-machine-name or your-machine-name\MSSQLSERVER If you have installed a named instance, you need to enter that named instance. Simply, you could find a list of all local servers installed by doing this: * Click on the "Server name:" drop down * Select "<Browse for more...>" * Select "Local Servers" tab * Expand "Database Engine" * Here the instances are listed, choose 1 of them Regarding the type of login, it depends on how you installed your ms sql server, if you installed with windows authentication choose that. If you installed with mixed mode, you should be remembering the sa password you supplied at the time of installation. So choose "SQL server authentication" in "Authentication:" and enter the user name as "sa" and the password you chose Hope this helps...
Cheers, Karthik
-
If you have installed a default instance, any of this should work - . (a dot indicating the local instance) or your-machine-name or your-machine-name\MSSQLSERVER If you have installed a named instance, you need to enter that named instance. Simply, you could find a list of all local servers installed by doing this: * Click on the "Server name:" drop down * Select "<Browse for more...>" * Select "Local Servers" tab * Expand "Database Engine" * Here the instances are listed, choose 1 of them Regarding the type of login, it depends on how you installed your ms sql server, if you installed with windows authentication choose that. If you installed with mixed mode, you should be remembering the sa password you supplied at the time of installation. So choose "SQL server authentication" in "Authentication:" and enter the user name as "sa" and the password you chose Hope this helps...
Cheers, Karthik
Karthik. A wrote:
Simply, you could find a list of all local servers installed by doing this: * Click on the "Server name:" drop down * Select "" * Select "Local Servers" tab * Expand "Database Engine" * Here the instances are listed, choose 1 of them
thnx....this method worked. :)
-
Karthik. A wrote:
Simply, you could find a list of all local servers installed by doing this: * Click on the "Server name:" drop down * Select "" * Select "Local Servers" tab * Expand "Database Engine" * Here the instances are listed, choose 1 of them
thnx....this method worked. :)
-
Karthik. A wrote:
Simply, you could find a list of all local servers installed by doing this: * Click on the "Server name:" drop down * Select "" * Select "Local Servers" tab * Expand "Database Engine" * Here the instances are listed, choose 1 of them
thnx....this method worked. :)
So up vote the answer in appreciation!
Never underestimate the power of human stupidity RAH