My web app runs on my machine fine when querying the local database.
However when I want the app to query a sql server instance on another machine on the network
it does not allow me access. I know my connection string is correct - I can access
the database through Enterprise manager, and definately am using the right username
and password. The error message is something to this effect "Cannot connect to server, invalid
username or instance doesn't exist" - poor description but am not at work to get the exact message.
It fails when doing the whole objConnection.Open() thing.
However it works fine when I am accessing the web app when connection through the Internet.
ie through a machine not connected to the network.
Any ideas ?