January 30, 2012 at 7:18 am
hi
i just installed sql server management studio express for windows 7 ,i am not able to connect,when i put server name local host ,it gives me error like 'cannot connect to 'localhots'.what should i put there.plz help me,i m new to sql server.
January 30, 2012 at 7:44 am
Find the installation logs and verify that SQL Express installed correctly. Also, check your services to make sure that SQL Server service and SQL Agent Service are both running. You won't be able to login if the services aren't running.
Oh, and type "local" instead of "localhost" and see if that allows you to login.
January 30, 2012 at 7:51 am
i found that in my sql server services are empty ,what does that mean.
plz help me
January 30, 2012 at 7:54 am
I'm not sure what you mean by empty. Could you clarify?
January 30, 2012 at 7:56 am
in configuration tools->sql server configuration manager->sql server services
Nothing is there,it just blank
January 30, 2012 at 7:57 am
i am getting this error:
Cannot connect to localhost.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Serve
r is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server) (Microsoft SQL Server, Error: 2)
January 30, 2012 at 7:58 am
the express version installs a named instance by default, so you should connect to servername\sqlexpress
If you are ever not sure of the names of the instances installed on a box check the services applet
---------------------------------------------------------------------
January 30, 2012 at 8:04 am
Just checking :-D, but has SQL Server Express been installed at all? You only mention installing Management Studio Express.
January 30, 2012 at 8:16 am
i tried to connect localhost\sqlserver,it gives me same error
January 30, 2012 at 8:35 am
Gazareth (1/30/2012)
Just checking :-D, but has SQL Server Express been installed at all? You only mention installing Management Studio Express.
good point, what has been installed?
---------------------------------------------------------------------
January 30, 2012 at 8:36 am
shah.simmy (1/30/2012)
i tried to connect localhost\sqlserver,it gives me same error
not sqlserver, sqlexpress
and use local or the actual server name
---------------------------------------------------------------------
January 30, 2012 at 8:42 am
Or .\SQLEXPRESS 😉
January 30, 2012 at 9:02 am
it has been installed successfully,but i m not able to connect
January 30, 2012 at 9:37 am
i tried .\sqlexpress also ,getting same error
January 30, 2012 at 10:04 am
SQL Server management studio express does not install the SQL Server instance. That is why there are no SQL Server services.
Download the appropriate version of express edition that you want and install that. Once you complete that you can use the management studio to connect to the named instance.
http://www.microsoft.com/download/en/details.aspx?id=184
Blog
http://saveadba.blogspot.com/
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply