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
 General SQL Server Forums
 New to SQL Server Programming
 probelm with servername??

Author  Topic 

chandu123
Starting Member

11 Posts

Posted - 2009-02-06 : 23:40:28
I have installed sqlserver 2005 im facing problem with servername when im giving my servername as chandu it is connecting to database but when im giving 'chandu\sqlexpress' its showing error i dnt know why?? is it mandatory to give server name like ***\sqlexpress?? help me regarding this.THANKS.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-07 : 00:34:48
Did you install it with an instance name of sqlexpress? It sounds like you installed the default instance and therefore ***\sqlexpress would error.

You can verify what you installed by looking at the service names that begin with SQL. What do you see?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2009-02-07 : 12:59:18
If it's a default installation , reference the sql server with the machine name

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

- Advertisement -