Hi,

I have 2 instances of SQL Server running on one machine (One 2K -default- and one 2K5), I have no problem connecting from a PC on LAN to the 2K5 instance, but when I try to connect to the 2K instance, it fails (it gives me an error: "Named Pipes Provider, error 40 - could not open a connection to the SQL Server"). I allow the remote connections on the properties page of the 2K.

So I ran out of choices, plz help me.

Thanks

just to get an idea can you show your connection strings to both instances?

just to get an idea can you show your connection strings to both instances?

Well finally I have to reinstall both instances, I don't know what happened but that solve my problem...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.