Solved

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

Posted on 2008-10-29
5
4,463 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 43

Expert Comment

by:zephyr_hex (Megan)
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 43

Expert Comment

by:zephyr_hex (Megan)
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 43

Accepted Solution

by:
zephyr_hex (Megan) 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Unable to save view in SSMS 21 83
SQL Server Insert where not exists 24 57
What is this datetime? 1 33
denied execute as 13 57
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

751 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