when I want to use SQL server managment studio , I dont know what have to write in in server name . pleas help me when I write "." it shows this error
Asked
Active
Viewed 1,234 times
0
-
1Did you actually install SQL Server? SQL Server Management Studio is just the interface, the database engine is a separate install. – Jeroen Mostert Jan 29 '21 at 12:14
-
by default it is dot (.) or your coumputer name – Umair Rasheed Jan 29 '21 at 12:29
-
you could try '(local)' – SteveC Jan 29 '21 at 12:33
1 Answers
0
This might help you.
SQL Server Management Studio (SSMS) shows Server name from installed SQLServer. Uninstall SQLServer if you already installed or install SQLServer from here
Once you reinstall SQLServer. Open SSMS on connect panel
- Click on Server name dropdown
- Select [Browse for servers]
- Selected [Database Engine]
Choose your machine and that's it
Sangeeth Nandakumar
- 1,362
- 1
- 12
- 23
-
`Browse for servers` [doesn't work](https://dba.stackexchange.com/questions/127849/browse-for-servers-does-not-display-local-instance) in a lot of cases e.g. server is remote, best to just type the DNS name or IP address – Charlieface Jan 29 '21 at 12:40
-
@Charlieface Yes, many times it does fails to detect DB engines in networks. Specifying IP is a better approch – Sangeeth Nandakumar Jan 29 '21 at 12:50