sql server does not exist

  • Thread starter Thread starter Hermit Dave
  • Start date Start date
H

Hermit Dave

Hi,
I am getting this SQLException: Sql Server does not exist or access denied

Here is the situation:
Build machine: VS 2003, Framework 1.1, Windows XP and SQL Server
I have two sets of connection strings, one for local sql server and one for
internet sql server.
Both connect to the database perfect when i connect through the ASP.NET
pages on my local IIS

The moment i copy relevant code to the hosting site, using internet Sql
Server gives me the above error

The connection string for internet server (which works fine when connecting
from local IIS)
<add key="ashandrodesConnect" value="Data Source=208.170.aaa.xxx;Network
Library=DBMSSOCN;Initial Catalog=mydatabase;User
ID=mysqluser;Password=mysqlpass;" />

i also tried the variation with Data Source=XXX.XXX.XXX.XXX,1433 for
explicit TCP/IP communication but still the same

Any help will be greatly appreciated
Attaching stack info - might be helpful
Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
WebShop._default.AddEarlyBird(String Name, String Email, String ShoeSize)
+373
WebShop._default.lnkInformMe_Click(Object sender, EventArgs e) +161
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
sePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
System.Web.UI.Page.ProcessRequestMain() +1277
 
My first thought is a firewall is preventing the connection to your SQL
Server box. Can you connect to the SQL Server from the production box
through anything else running on that box? It might be worthwhile setting
up an ODBC connection just to verify that the connection is working.

Jeff
 
Hi Jeff,
I did try odbc connection and odbc returns successful connection.
Earlier thought that might be some ip visibility issue but dont think that
is.
Again there's no issue from sql server side cause my dev box can connect to
online sql db
Its just a no go from production env.

Jeff said:
My first thought is a firewall is preventing the connection to your SQL
Server box. Can you connect to the SQL Server from the production box
through anything else running on that box? It might be worthwhile setting
up an ODBC connection just to verify that the connection is working.

Jeff

Hermit Dave said:
Hi,
I am getting this SQLException: Sql Server does not exist or access denied

Here is the situation:
Build machine: VS 2003, Framework 1.1, Windows XP and SQL Server
I have two sets of connection strings, one for local sql server and one for
internet sql server.
Both connect to the database perfect when i connect through the ASP.NET
pages on my local IIS

The moment i copy relevant code to the hosting site, using internet Sql
Server gives me the above error

The connection string for internet server (which works fine when connecting
from local IIS)
<add key="ashandrodesConnect" value="Data Source=208.170.aaa.xxx;Network
Library=DBMSSOCN;Initial Catalog=mydatabase;User
ID=mysqluser;Password=mysqlpass;" />

i also tried the variation with Data Source=XXX.XXX.XXX.XXX,1433 for
explicit TCP/IP communication but still the same

Any help will be greatly appreciated
Attaching stack info - might be helpful
Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
Click to expand...
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
WebShop._default.AddEarlyBird(String Name, String Email, String ShoeSize)
+373
WebShop._default.lnkInformMe_Click(Object sender, EventArgs e) +161
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108
Click to expand...
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
sePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
System.Web.UI.Page.ProcessRequestMain() +1277
Click to expand...
Click to expand...
 
Hello Jeff
Thanks.. I did raise a log and they gave me an internal ip. Firewalled.
You probably did guess it right.

Jeff said:
My first thought is a firewall is preventing the connection to your SQL
Server box. Can you connect to the SQL Server from the production box
through anything else running on that box? It might be worthwhile setting
up an ODBC connection just to verify that the connection is working.

Jeff

Hermit Dave said:
Hi,
I am getting this SQLException: Sql Server does not exist or access denied

Here is the situation:
Build machine: VS 2003, Framework 1.1, Windows XP and SQL Server
I have two sets of connection strings, one for local sql server and one for
internet sql server.
Both connect to the database perfect when i connect through the ASP.NET
pages on my local IIS

The moment i copy relevant code to the hosting site, using internet Sql
Server gives me the above error

The connection string for internet server (which works fine when connecting
from local IIS)
<add key="ashandrodesConnect" value="Data Source=208.170.aaa.xxx;Network
Library=DBMSSOCN;Initial Catalog=mydatabase;User
ID=mysqluser;Password=mysqlpass;" />

i also tried the variation with Data Source=XXX.XXX.XXX.XXX,1433 for
explicit TCP/IP communication but still the same

Any help will be greatly appreciated
Attaching stack info - might be helpful
Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
Click to expand...
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
WebShop._default.AddEarlyBird(String Name, String Email, String ShoeSize)
+373
WebShop._default.lnkInformMe_Click(Object sender, EventArgs e) +161
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +108
Click to expand...
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
sePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
System.Web.UI.Page.ProcessRequestMain() +1277
Click to expand...
Click to expand...
 
Back
Top