How to enable Named Pipes & TCP/IP connections without Configuration Manager
Posted on 2008-10-29
I am running a local version of websites for marketing purposes. I need to be able to connect to the database locally, which I have installed SQL Server 2005 Express and copied backups of the remote databases.
The issue is that SQL Express does not come with named pipes or TCP/IP connections enabled by default. When I try to open SQL Server Configuration Manager, I get the following error:
"Snap-in failed to initialize.
Name: SQL Server Configuration Manager
I have tried the KB article where it is suggested to install the SQL Server 2000 Backwards Compatibility fix, but that did not resolve the problem of making the snap-in work. To date, nothing I have tried (including uninstalling and reinstalling all of .NET and SQL Server 2005 Express as well as our copy of SQL Server 2005 Developer) has worked and I do not want to reinstall Windows.
Right now, I am in a time crunch and just need to get TCP/IP enabled. Is there any way outside of the Configuration Manager to get TCP/IP enabled? I tried to using Windows Authentication, but the code will not work as it expects a DSN.
This is all running on Windows XP with IIS 5.1.