Knowledgebase
(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account
SEARCH
Knowledgebase
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection Error when binding MSSQL database with plesk 10
Posted by on 22 August 2012 08:22 AM

Connection to a named instance of SQL server 2005/2008 should be made using the format ‘VirtualServer\Instancename’. if the IP address of a machine running a named SQL server instance (ONE)is 192.141.128.140, you can connect to the named instance using  192.141.128.140\ONE for the servername.

To avoid a client app from using the above convention for a servername, a client  alias can be created using the client network utility. Client network utility  can be initiated by

Start->Programs ->Microsoft SQL Server->Client Network Utility

and you can create a Named Pipes or TCP/IP alias for your server and try connecting again.

(2 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).