Connection to SQL 2000 on Win 2003 Server

R

Ryan Smylski

I am developing a web application on my win 2000 machine
but can not establish a connection with the SQL Server DB
on our win 2003 server machine. If I run the site on the
win 2003 itself, I can connect and work with the DB fine,
but trying to use the same connection string, and other
variations always leads to the same outcome. "SQL Server
does not exist or access denied."
I've used a connection string providing a SQL Server's user
credentials to log in, as well as using integrated security
just with windows users. Seeing as it isn't on the same
computer, connecting with a SQL Server user's credentials
would be preffered, yet nothing works. I think there could
be something related to the win 2003 user account that is
being used to try to connect to the DB, but don't know
where to begin to look into that theory further, or even if
that actually is a valid route to explore. Any ideas or a
point in the right direction would be appreciated.

Ryan
 
B

Brendan Green

And make sure you are allowing connections over TCP as well. I know that,
by default, MSDE 2000 disallows network connections unless explicity told to
do otherwise during installation.
 

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

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top