Solved

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

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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

623 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