2

I have installed SQL Server 2005 on my system. After installation, when I try to use it, it is asking for server name. I have tried 

.     .\     .\SQLEXPRESS     local    (local)    localhost     .\localhost 
(localhost)    computername    .computername

in Windows authentication. But I was unable to connect to SQL Server. Please help me to connect.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user2667453
  • 21
  • 1
  • 1
  • 2
  • You want to find it via `asp.net` ? – Raptor Aug 09 '13 at 10:20
  • 1
    Have you looked at the SQL Server Configuration Manager? – Oded Aug 09 '13 at 10:22
  • 1
    try with `.` to connect – Amit Aug 09 '13 at 10:24
  • 1
    It will be MachineName\InstanceName. Default instance name is SQLExpress. Quick way if you haven't installed the tools, would be to have a look at windows services. – Tony Hopkinson Aug 09 '13 at 10:28
  • 1
    possible duplicate of [How can I determine installed SQL Server instances and their versions?](http://stackoverflow.com/questions/141154/how-can-i-determine-installed-sql-server-instances-and-their-versions) – CodeCaster Aug 09 '13 at 10:31
  • Which **edition** did you install? If you used SQL Server **Express**, the default instance name is `SQLEXPRESS`, so you should be able to connect with `.\SQLEXPRESS` or `(local)\SQLEXPRESS` or `machinename\SQLEXPRESS`. If you installed any other edition, it's just `.` or `(local)` or `machinename` – marc_s Aug 09 '13 at 10:46
  • CodeCaster is right it is the duplication. – Dhaval Aug 09 '13 at 10:48

3 Answers3

3

Check this path to find SQL Server Configuration Manager:

C:\Windows\system32\SQLServerManager.msc

Also check this path:

C:\Program Files\Microsoft SQL Server\MSSQL<server_version>.<instance_name>\

Server Instance Name:

proof

Another way to find find local server name:

enter image description here

Devart
  • 119,203
  • 23
  • 166
  • 186
1

install managment studio and find name of the server or go to the sql server configuration manager.

Sebastian Wąsik
  • 63
  • 4
  • Thank you Sebastian Wasik. But in my system I can not find sql server configuration manager. Is this mean that it is not correctly installed? – user2667453 Aug 09 '13 at 10:33
  • 1
    C:\Windows\SysWOW64\mmc.exe /32 C:\WINDOWS\SysWOW64\SQLServerManager11.msc my path to the configuration if you don't have something is wrong. – Sebastian Wąsik Aug 09 '13 at 10:44
0

CodeCaster is right it is the duplication. one more way to see your instance name is go to "Service" and look for "SQL Server" it will have SQL Server instance name .. if it is MSSQLServer then you can tye "." only else you should type ".\Instancename".

Dhaval
  • 2,801
  • 20
  • 39