Solved

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

Posted on 2008-10-29
5
4,435 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 (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 42

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 42

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Not selecting duplicate data 6 55
Move SQL 2005 Express to Server 2012R2 19 129
Event ID: 7016 / Source: Microsoft-Windows-GroupPolicy 7 119
SQL Backup skipping a few tables 7 45
Sometimes people don't understand why download speed shows differently for Windows than Linux.Specially, this article covers and shows the solution for throughput difference for Windows than a Linux machine. For this, I arranged a test scenario.I…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
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…

832 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