Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4528
  • Last Modified:

How to enable Named Pipes & TCP/IP connections without Configuration Manager

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
  CLSID:{CA9F8727-31DF-41D2-975C-887D84903967}"

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.
0
dageyra
Asked:
dageyra
  • 3
  • 2
1 Solution
 
zephyr_hex (Megan)DeveloperCommented:
when you get the error, is there an option to Continue (ignore the error)?

also, have you run all sql patches / service packs?  i'm not up to speed on whether or not patches or service packs exist for sql express... however, they do exist for the full version... so it might be worthwhile to verify that the express version has no patches/service packs
0
 
dageyraAuthor Commented:
Yes, I installed all service packs for the developer version, and I can continue but it opens the generic MMC program with an error saying the snap-in could not be loaded.  I installed in the same program on another machine without error and without the service packs.  I was able to do what I needed using the Surface Area Configuration Tool, but I have no idea what the difference is.
0
 
zephyr_hex (Megan)DeveloperCommented:
have you tried Surface Area Configuration?  under Database Engine, there is a Remote Connections option...

http://msdn.microsoft.com/en-us/library/ms178763(SQL.90).aspx
0
 
dageyraAuthor Commented:
Hello:

As I  mentioned in the earlier post, I was able to get it to work with the SA Config Tool, though I had tried this previously and it did not work.  I do not know what the difference is between the SA config tool and the regular configuration manager.
0
 
zephyr_hex (Megan)DeveloperCommented:
there are two separate sql tools:
SQL Surface Area Configuration
SQL Server Configuration Manager

you can enable tcp/ip using either...
however, there are some tasks that can only be done in one or the other tool (not both).

http://msdn.microsoft.com/en-us/library/ms173748(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms174212.aspx

if you were able to enable tcp/ip using the surface area tool, you don't need to worry about trying to do the same thing with the other tool.
however, at some point you might consider a re-install.. at least of the sql tools... because you may reach a point where you need to use the tool that isn't working...
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now