Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Sql Server 2005 connect problem

Author  Topic 

justmine84
Starting Member

1 Post

Posted - 2010-08-11 : 03:11:33
Hi people,
I m new to sql. I have installed sql server 2005 management studio. When i open it, it gives windows which ask SERVER NAME.
By clicking on server name drop down menu, does not show any server name. Nothing shows in browse for server.
Upto my understanding server name is the same name as computer name before backslash then sqlexpress.
E.g abc\sqlexpress

When i give this server name. Error show 'network related instance occured'

Plz help me, i m unable to connect to sql server

Liam
Starting Member

6 Posts

Posted - 2010-08-12 : 14:39:22
whoever set up your sql server could have named it anything, you should ask your dba.
if its on your network you can search for it but you say this doesn't work so i assume not (or not turned on!)
at a guess I would try the server name i.e. network name or possibly the ip address
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-08-12 : 15:34:09
It depends on how it was set up - for example , if the instance was set such as MYINSTANCE1 and this is installed on the server MYSERVER1 - reference as MYSERVER1\MYINSTANCE1.

Is it a local sqlserver express installation?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -