SQL2005 Express not showing in drop down

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

Express Edition and Compact Edition (2005)

SQL2005 Express not showing in drop down

Author

Topic

davidwhyte
Starting Member

13 Posts

Posted - 2007-04-23 : 10:12:03

Hi,

Ive got a SQl2005 Express server which doesnt appear on the network as an sql box. Im able to ping the server without any issues but when I try to attach to the server by using Connect option on the SMSE installed on my machine, I see my other sql 2005 express boxes and my sql2000 box but I cannot see my new SQL2005 Express box.

Any ideas?

Thanks
DW

DW

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-23 : 10:25:19

Try type instance name in then connect, may have service broadcasting issue on the network.

davidwhyte
Starting Member

13 Posts

Posted - 2007-04-23 : 11:36:14

Ive tried typing the instance and also using the ip address, still no luck.

DW

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2007-04-23 : 12:06:58

Is SQL Browser Enabled on the server?
Have you enabled TCP/IP on the server?
Have you created exceptions for SQl Server and SQl Browser in your firewall?

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

davidwhyte
Starting Member

13 Posts

Posted - 2007-04-24 : 06:17:23

Ok, Ive enabled the browser and I can now see the server in my drop down list. Slightly odd mind since I didnt enable the browser service on my other boxes??

Thanks Mike

Dw

DW

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-24 : 09:55:31

You can connect to it locally if browser service is not running.

davidwhyte
Starting Member

13 Posts

Posted - 2007-04-30 : 07:10:19

Ok, the plot thickens! Im now able to see the server in the drop down menus but Im not able to connect due to error: [DBNETLIB]Connection Open (Connect()).]Sql Server does not exisit or access denied.
I get this error message when I try to connect to the box using Crytal Reports V8. If I carry out the same process on the SQL box itself using crystal reports, Im able to connect to the database without any issues.

Any ideas guys?

Thanks

DW

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-04-30 : 07:39:42

How do your connection string look like?

Peter Larsson
Helsingborg, Sweden

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-30 : 13:06:53

Is tcp/ip or named pipes potocol enabled in express?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources