CODEWITHSUNDEEP
asp.netsql-serversql-server-2005
user2667453
user2667453

Reputation: 21

How to find server name for SQL Server 2005

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.

Upvotes: 2

Views: 20473

Answers (3)

Devart
Devart

Reputation: 121902

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

Upvotes: 3

Dhaval
Dhaval

Reputation: 2861

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".

Upvotes: 0

Sebastian Wąsik
Sebastian Wąsik

Reputation: 65

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

Upvotes: 1

Related Questions