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