Windows Forum

Ask something
Discussion Locked

Login errors with SQL Server 7 on NT 4.0

0 helpful
6 replies

by susyl

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

I have ongoing issues making connections with SS7 via a one-way trust between a local LAN server and a VPN server. SS7 uses NT authentication, not SS. As the DBA, I have no domain rights, so I can't easily check permissions, group rights, etc., and the NT admin blows off my questions. My jobs fail intermittently, when I've made no changes to them, and the NT Admins claim that that they've made no rights changes. When I create & schedule DTS packages from my workstation via MMC, they will run only if all the work is local to the LAN servers. If I create a package that requires data to move between a LAN server and a VPN server, many times it doesn't work. This seems to depend upon which DBA login is used, but I can't prove it.

1000points to anyone with a reasonable explanation for this, and corrective action.

6 replies

by srisner

Seems you may have a trust problem with the VPN server. I would suggest deleting the trust then re-establishing it. (this will require your NT admin's assistance) The SQLExecutive account may not be authenticating properly. DBA logins are also susceptible to the trust relationship as they also must be authenticated. When your job fails, any error messages?
Good luck

by srisner

What was the ANSWER to your situation? I'd be interested in knowing it for future knowledge. Thanks
SRisner

by drdon

I see two separate issues here. First, the VPN issue of the jobs failing based on DBA user account used. Do all DBAs have access to the VPN under their logins? This must be enabled by user. Can your standard DBA account access your other server via the VPN? Can you log in to the VPN server?

Second, SQL running as a service on the NT server, is there a second SQL DB on the VPN server that is being accessed or is the VPN just a "front end" into the SQL server on the local LAN side? I would look again at the Event Log for the servers.

I would invest my time first at looking at the VPN connections -

Hope this helps!

This discussion is closed to new replies.