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