Solved

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

Posted on 2008-10-29
5
4,405 Views
Last Modified: 2012-06-21
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
Comment
Question by:dageyra
  • 3
  • 2
5 Comments
 
LVL 42

Expert Comment

by:zephyr_hex
ID: 22835812
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
 
LVL 1

Author Comment

by:dageyra
ID: 22835843
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
 
LVL 42

Expert Comment

by:zephyr_hex
ID: 22836757
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
 
LVL 1

Author Comment

by:dageyra
ID: 22836813
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
 
LVL 42

Accepted Solution

by:
zephyr_hex earned 500 total points
ID: 22853652
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now