sql server does not exist

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
 
J

Jeff

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
 
H

Hermit Dave

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...
 
H

Hermit Dave

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SOS: SQL Server not found or Access Denied 3
SQL Server does not exist or access denied. 3
connection problem 10
SQL Server Does not exist or access denied 9
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. 4
Windows 2003 - SQL Server does not exist or access denied 1
Newbie Question about database access. 1
Server Error in '/mates' Application. 5

Top