up vote 3 down vote favorite
1
share [g+] share [fb]

I reinstall a server Windows Server 2008 R2, I installed SQL Server 2008 R2 no problem during installation. When I try to connect with "Microsoft SQL Management Studio" via sa account or Windows Administration account, I have this error (picture1), the second picture (picture2) show the services staarted.

I read some posts about this but no success :(

Picture1: alt text

Picture2: alt text

link|improve this question
feedback

6 Answers

up vote 4 down vote

Isn't that the default instance, for which you DO NOT GIVE A NAME IN THE CONNECTION STRING?

link|improve this answer
To clarify, just put localhost in the Server name: field – nick Oct 6 '11 at 5:07
feedback
up vote 0 down vote

Have you added rules for the firewall?

There is a picture here > http://sqlsolace.blogspot.com/2009/08/windows-2008-firewall-rules-for-sql.html

link|improve this answer
feedback
up vote 0 down vote

Use an alternative representation of the name of the local host address instead of "localhost". Possible alternative representations include the following:

  • 127.0.0.1
  • (local)
  • "."
  • The actual local host name

For example in your server try to change Server name field like so :

(local)\MSSQLSERVER or .\MSSQLSERVER

For predefined instance type you need to use only : localhost or 127.0.0.1

have you enabled REmote Connection to SQL Server ?

you could also try with this step-by-step guide : http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

link|improve this answer
tried, same result – Kris-I Sep 5 '10 at 7:39
Is the SQL Server configured with named instances or predefined instance ?How do you have installed it? Have you enabled TCP-IP connection ? – aleroot Sep 5 '10 at 10:21
feedback
up vote 0 down vote

Have you run SQL Server Configuration Manager yet? That should be your first stop after the install (and patching).

Start Menu -> All Programs -> Microsoft SQL Server 2008 -> configuration tools -> SQL Server Configuration Manager.

By default, there's not much connectivity enabled -- this is where you'll fix that.

alt text

link|improve this answer
feedback
up vote 0 down vote

Start->Programs->SQL Server->SQL Server Configuration Manager->SQL Server Browser->Properties->Start Mode = Automatic

link|improve this answer
feedback
up vote 0 down vote

In Instance Name when you're connecting from local computer on which SQL Server is installed you don't need to enter anything else expect localhost. Eg., Localhost\mssqlserver is not acceptable. Enter only localhost and try to connect. When you're connecting to SQL Server from remote computer at that time in server name you need to enter ComputerName\SQLServerName.

For Remote Connections Settings Please refer below link.

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.