Connection to SQL 2000 on Win 2003 Server

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
.

Relevant Pages

  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Database Connection Problems
    ... What I didn't understand before, is that you can create a database that is not attached to the SQL server. ... The common connection strings I've encountered only work when the database is provided by the SQL server. ... connection string not working. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
Loading