"SQL Server does not exist or access denied." upon VB.Net Deployment
Posted
by JasonMHirst
on Stack Overflow
See other posts from Stack Overflow
or by JasonMHirst
Published on 2010-04-28T08:08:52Z
Indexed on
2010/04/28
8:13 UTC
Read the original article
Hit count: 248
Have built a small VB.Net app in VS2010.
The connection string to the SQL Server is as follows:
<connectionStrings>
<add name="IWSR_DataDownloadWizard.My.MySettings.sqlConnection"
connectionString="Provider=SQLOLEDB.1;Data Source=SQLServer;Integrated Security=SSPI;Initial Catalog=IWSROL"
providerName="System.Data.OleDb" />
</connectionStrings>
Within the VS2010 environment AND on my machine, the connection works perfectly, however when I deploy to clients I get an error message of:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I've tried to search the net for solutions, have seen a few instances of people saying to NOT use the Server Name but the IP Address instead (this doesn't work) and some saying to remove the "Provider=SQLOLEDB.1", again this doesn't work.
Can anyone suggest a solution please?
Further information:
Development System is Windows7 using VS2010 Deployment systems are a combination of Windows XP, Windows 2000 and Windows 7 SQL Server is SQL2000 (soon to be SQL2005).
TIA
© Stack Overflow or respective owner