MS-Sql Server 2005 Express Edition disables some of the features of SQL Server to minimize memory consumption.One of them is stopping the server to listern on TCP Port.
To enable the feature,follow the steps below:
1.Open Programs>SQL Server 2005>Configuration Tools>Sql Server Surface Area Configuration
2.Click on Surface area configuration for services and connections
3.Double click on SQLExpress>Database Engine>Remote Connections
4.Click on radio button allow remote connections using TCP.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment