Wednesday, March 21, 2012

Database engine not displayed by management console

I have sql server 2005 express installed on an XP machine. When I browse for a database engine, SQL server 2005 management console displays machinename\sqlexpress in the local tab, BUT in the network tab only the machinename is displayed. Thus, I cannot connect to express from a networked machine.

Any help would be appreciated.

TIA,

Joe

SQL Express, by default, is closed to network connections.

These articles will walk you through the process of configuring SQL Express for network activity.

Configuration -How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||

Thanks for the pointers.

SQL server 2005 browser service was not running. Configured it for auto & started.

Problem is fixed.

No comments:

Post a Comment