Discussion Locked

SQL SVR CONNECTION-remote access denied

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Unable to establish connection to sql server database "remote" using connection script via VB6

Respose is always access denied, however when connecting 'local' using the same PC it's successful.

1 reply

by mattohare

I'm not sure if this will help, but when this happened to me, it was a case of authentication. You may somehow be getting in as the standard admin user "sa" with local, but be logging in with Windows[NT] authentication on the "remote" way. Check to see that you have added Windows[NT] yourself as a user of that SQL Server database and the server itself.

This discussion is closed to new replies.