I have installed SQL Server Management Studio 2005. I can't find my server name when I click browse for more but i know that my server name will be the same as the user name as in the picture below.
Connect to the SQL Server using SSMS Next, from the Connect menu under the Object Explorer, choose the Database Engine… Then, enter the information for the Server name (localhost), Authentication (SQL Server Authentication), and password for the sa user and click the Connect button to connect to the SQL Server.
SQL Express does not install the SQL Management Studio so you have to get this installed yourself. You may need to manage users like the built in 'sa' user and its password. For example when installing the AlarmDB Logger Manager.
Use .
or (local)
or localhost
for server name if you installed the server as default instance.
Use .\sqlexpress
or localhost\sqlexpress
if you have SQL Express.
The server name syntax is
Servername\InstanceName
If the instance is default you use just Servername.
For SQL Express, instance name is sqlexpress by default.
Please see:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With