| :: SQL 2005 Connection Problems :: (2) | Post a New Message | Post a Reply |
 SQL 2005 Connection Problems | Post a Reply |
since: Sep 20, 2006
from: USA
strConnectionString = "Provider=SQLNCLI;" & _
"Server=ServerIP;Database=DatabaseName;" & _
"UID=UserID;PWD=Password;"
Errors Occured!
Error #:-2147467259 Named Pipes Provider: Could not open a connection to SQL Server [53].
What could be the issue.
 Re: SQL 2005 Connection Problems | Post a Reply |
from: Washington, DC
First suggestion is to make sure that you specifiy the instance name as well as the server name (christ knows why, but when MS refer to "Server Name" they really mean "Server Instance Name") eg if your server was named 'bigturnip' then you need to specify 'bigturnip\sqlexpress' (where sqlexpress is the instance name - this one just happens to be the default used by SQL Server 2005 SQLExpress).
If that doesn't help, then go into the SQL Server Configuration Manager and make sure you've enabled Named Pipes & TCP (if you're using it) and also go into the Surface Area Configuration tool and make sure you've set it for local &/or remote connection for the connection types you want to use. Then restart the SQL Server (instance) service.
...
-------------------------
Ghost