By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,478 Members | 1,833 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,478 IT Pros & Developers. It's quick & easy.

VERY strange database connection problem

P: n/a
I have a web app that I have setup on numerous web servers. I've set one up for a new client at their hosting facility
and cannot get it to connect to their database. I get a "SQL Server does not exist or access denied." error. Well, the
strangeness is that I have a SQL Query tool installed on this server and can connect to the database fine using the
exact same connection parameters that I have specified in my web app. Even more strange is that I have a copy of the
web app on a another web server at another location and I took the connection string from the web server that is not
working and put it on my copy and the copy connects and works fine. Well, it doesn't stop there, on the server that has
the problem I went to create an ODBC datasource just to see if it had any problem. Well, it connected fine but it
wouldn't see the database that I'm trying to connect to (I remind you though that I have connected to this database from
this and other machines with no problems and can query the database). I want to call the hosting facility support desk
to see if there is something funny going on with the database but I'm afraid that they'll just connect with query
analyzer and say there's nothing wrong with the DB and that I need to check my app configuration. I'm not sure where to
go from here, I need some suggestions.

One more thing, when I try to connect through the web app it takes about 30 seconds to return the "does not exist error"
(which is typical when the web server cannot find the DB server on the network). Also, I'm accessing the database
server using it's IP address. I've never see anything this strange before. I'll appreciate any suggestions.
--Buddy
Nov 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Buddy,

When you use SQL Query Analyzer, you are connecting to the database as
yourself. You didn't mention whether you're using a Trusted Connection, that
is, using your Windows login rather than a SQL Server account user name and
password. What does your Connection String look like, and what kind of
authentication is being used by the SQL Server (Windows or Mixed)?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.

"Buddy Ackerman" <bu**********@buddyackerman.com> wrote in message
news:ew**************@TK2MSFTNGP14.phx.gbl...
I have a web app that I have setup on numerous web servers. I've set one
up for a new client at their hosting facility and cannot get it to connect
to their database. I get a "SQL Server does not exist or access denied."
error. Well, the strangeness is that I have a SQL Query tool installed on
this server and can connect to the database fine using the exact same
connection parameters that I have specified in my web app. Even more
strange is that I have a copy of the web app on a another web server at
another location and I took the connection string from the web server that
is not working and put it on my copy and the copy connects and works fine.
Well, it doesn't stop there, on the server that has the problem I went to
create an ODBC datasource just to see if it had any problem. Well, it
connected fine but it wouldn't see the database that I'm trying to connect
to (I remind you though that I have connected to this database from this
and other machines with no problems and can query the database). I want to
call the hosting facility support desk to see if there is something funny
going on with the database but I'm afraid that they'll just connect with
query analyzer and say there's nothing wrong with the DB and that I need to
check my app configuration. I'm not sure where to go from here, I need
some suggestions.

One more thing, when I try to connect through the web app it takes about
30 seconds to return the "does not exist error" (which is typical when the
web server cannot find the DB server on the network). Also, I'm accessing
the database server using it's IP address. I've never see anything this
strange before. I'll appreciate any suggestions.
--Buddy

Nov 19 '05 #2

P: n/a
Well, I found the problem. My application is in a subdirectory, actually it was in the root to begin with and moved but
there was still a copy of the old web.config (before i modified it with the new connect string). So, I don't understand
why my application didn't use the web.config setting in the subdirectory. It continued to use the settings in the
web.config in the root of the website.
--Buddy

Kevin Spencer wrote:
Hi Buddy,

When you use SQL Query Analyzer, you are connecting to the database as
yourself. You didn't mention whether you're using a Trusted Connection, that
is, using your Windows login rather than a SQL Server account user name and
password. What does your Connection String look like, and what kind of
authentication is being used by the SQL Server (Windows or Mixed)?

Nov 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.