Cannot connect to the new instance which created

[former_member183044]

Hi all,

Good day...

I was configuring SQL server 2005 on Windows server 2008. After configuring all, i clicked on MS SQL studio and gave the instance name which i created. After clicking on "connect" , the following error message is coming

Can any body help in this matter as our management is counting on me....

Please help

Regards

Praveen

[cherry_tian · Accepted solution]

Hi, Praveen

From the screenshot of SQl Server configuration manager, there are 3 SQl Server instances installed:

ISWPPRD4

ISWPPRD5

SQLR2

If you open the SQL Server Management Studio first time, there will be no SQL Server instance name displayed by default. Please click the black triangle mark and choose <Browser more instance> to select the SQl Server instance ISWPPRD5. The instance ISWPPRD5 will be opened then.

I noticed in the original screenshot you attached, the error shows, you tries to connect an instance named "Test1". And the provider is named pipe provider.

As there is no server called Test1, so you cannot open Test1 instance. This is the first point.

Furthermore, according to the screenshot of network protocols, you disabled named pipes provider.

Please enable the named pipes protocol and shared memory protocol. Different protocls will help with the different scenario to connect SQl Server.

Best regards.

Cherry.