sql server does not exist

[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.Get PooledConnection(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(Event Args e) +108

System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.Rai
sePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +138
System.Web.UI.Page.ProcessRequestMain() +1277

[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

"Hermit Dave" <he***********@CAPShotmail.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

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.Get PooledConnection(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(Event Args e) +108

System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.Rai sePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +138 System.Web.UI.Page.ProcessRequestMain() +1277

[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" <js****@nospam.dls.net> wrote in message
news:u$**************@TK2MSFTNGP11.phx.gbl...

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" <he***********@CAPShotmail.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

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.Get PooledConnection(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(Event Args e) +108

System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.Rai

sePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)

+138

System.Web.UI.Page.ProcessRequestMain() +1277

[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" <js****@nospam.dls.net> wrote in message
news:u$**************@TK2MSFTNGP11.phx.gbl...

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" <he***********@CAPShotmail.com> wrote in message
news:%2******************@TK2MSFTNGP11.phx.gbl...

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.Get PooledConnection(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(Event Args e) +108

System.Web.UI.WebControls.LinkButton.System.Web.UI .IPostBackEventHandler.Rai

sePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)

+138

System.Web.UI.Page.ProcessRequestMain() +1277