September 18, 2003 at 9:10 am
OK heres the problem.
I have an SQL 2000 database in 1 office that sits behaind a firewall, I have port forwarded 1433 to the internal ip address of the host.
Then I try and connect to the SQL db over the internet from Access 2002 by calling the public IP address. The problem is that is a far as I can get! the errors basically range from server doesn't exist to user doesn't exist, user not associates with a trusted sql connection and a few others.
I have trawled other similar posts here but with no effect, have tried changing the auth in EM from windows to SQL but then get a further 'not associated with a trusted SQL server connection' error. Is it simply a case of associating a user with a connection or would that be too easy.
As a side note Connecting on the same LAN poses no problem at all.
Any pointers would be greatly appreciated as I fast losing patience with this one as nowt seems to work.
September 18, 2003 at 10:20 am
If you change auth from NT to SQL, you need to change this on the server as well.
This should work easily enough if you do that. NT auth shouldn't work.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 18, 2003 at 10:38 am
When you are using a trusted connection (Windows Authentication), your LOGIN and PASSWORD MUST be the same on both the SQL Server and the client machine/application.
-SQLBill
September 18, 2003 at 11:07 am
Thanks guys as soon as I managed to change to the Auth to SQL voila!! working a treat thanks again
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply