my sql server asking for server name after i installed it, now i dont know what is the server name therefore unable to use it.....

Question

Unable to use my MS SQL server as it is asking for server name on the startup.. i am a new user of MS SQL so kindly guide me..... i am using windows 7 professional version....

Answer 1

 Normally It should be your Server name or local you can check in SQL server configuration Manager.

---

Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

Answer 2

Is it asking when you try to connect to via SSMS? Once you typed it will be showing up... If it is default instance  you could type LOCAL or localhost or computer name , else  you need to provide instance name like Computer\SQLEXPRESS for example

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

Check in sql server configuration manager.

If your SQL Server Service is named MSSQLSERVER, you can connect to the instance by using either of "Servername", "(local)", "."

If your service is called MSSQL$SQLEXPRESS (for example), it means that your instance is named SQLEXPRESS, then you connect to either of: "servername\sqlexpress",".\sqlexpress".

If youre making a remote connection make sure to check that you enabled tcp and maybe the browser service - if youre not using a default port.

Answer 4

another option:

1. Click "Cancel" on Connect to server dialog,

2. Go to View Menu -> Registered Servers,

3. Expand Database Engine node,

4. Right click on Local Server Groups and select Tasks -> Register Local Server

This will show all local servers started/stopped.

---

- Vishal

SqlAndMe.com

Answer 5

A short basic tutorial Tutorial: Getting Started with the Database Engine

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 6

another option:

1. Click "Cancel" on Connect to server dialog,

2. Go to View Menu -> Registered Servers,

3. Expand Database Engine node,

4. Right click on Local Server Groups and select Tasks -> Register Local Server

This will show all local servers started/stopped.

---

- Vishal

SqlAndMe.com

Still can't access the server as i do this procedure.. when i click on data base engine there is nothing to expand nothing apears i've tried my pc name as server name but still unable to access..........

Answer 7

Hi,

seems like there was an issue with the installation, can you please confirm below?

0) Go to Drive\Program Files\Microsoft SQL Server\version\Setup Bootstrap\ at this location you will see the summary.txt, do you see any failure message here? if yes, post error message here

1) go to services.msc -> Do you find anything like below?

2) If answer is yes, refer the sql server instance name (if MSSQLServer, it's default, else it is named instance)

3) if service is not started -> start it

4) if service is failing to start refer sql server error log

hth

---

Hemantgiri S. Goswami | SQL Server Citation| Surat SQL Server User Group

Answer 8

Hi,

seems like there was an issue with the installation, can you please confirm below?

0) Go to Drive\Program Files\Microsoft SQL Server\version\Setup Bootstrap\ at this location you will see the summary.txt, do you see any failure message here? if yes, post error message here

1) go to services.msc -> Do you find anything like below?

2) If answer is yes, refer the sql server instance name (if MSSQLServer, it's default, else it is named instance)

3) if service is not started -> start it

4) if service is failing to start refer sql server error log

hth

---

Hemantgiri S. Goswami | SQL Server Citation| Surat SQL Server User Group

Sorry...... i neither found summary.txt nor the services are running......... i am just sick of it i've installed it twice on the pc but ended up with the same problem

Answer 9

Seems like you have some left over from previous installation, please refer the article http://support.microsoft.com/kb/909967 and do manual uninstallation.  Which version & edition of SQL sever you are installing?

---

Hemantgiri S. Goswami | SQL Server Citation| Surat SQL Server User Group

Answer 10

I am installing MS SQL 2005