I trying to connect to a SQL DB SP 3 using cisco client
VPN v.4.01. The VPN is connecting to a cisco PIX515 with
MS IAS as its AAA. On a remote PC running Win XP SP1
logging in with the local builtin administrator account,
I can connect to the SQL after I VPN in. With everything
remaining the same, I logon with a user account I created
belonging to the Administrators group, I get an error
trying to connect to SQL. The only account that is able
to connect to the SQL is the local Administrator
account. All other accounts are getting error of no "not
associated with a trusted SQL Server connection." All
the other account are in the Administrators group. The
security is set to "With Windows NT authenication using
network login ID."If the builtin\administrators group has been removed from SQL Server, then
the other accounts would have to be explicitly added as allowed accounts in
SQL Server. The "with Windows authentication using network..." sounds like
a linked server setting, where are you checking that?
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment