October 3, 2002 at 1:00 pm
Setting: Sql7 computer named mySQLServer
While logged in as Admin on mySQLServer, I created a local NT account, myAccount. Under EM I gave myAccount rights to read from selected tables.
Under Query Analyzer:
a) If I log in using "Sql Server authentication" as myAccount, everything is
fine. I can run "select * ..." on the needed tables.
b) BUT if I login using "Windows NT Authentication" mode (and I have logged into
the local box as myAccount), I get:
Unable to connect to server <\\mySQLServer>
[Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user
'mySQLServer\myAccount'
Right clicking mySQLServer under Enterprise Manager and selecting Properties > Security tab shows the Authentication mode is set to "SQL Server and Windows."
Any help on this problem much appreciated.
Thanks,
Bill
October 3, 2002 at 6:56 pm
Unfortuantely this has to do with the token passed during a windows session logon. This is why we use a domain for our server and us. Try logging into the box thru a share or cmd line with your Windows machine then try and you should get in as long as the security token is valid that it passes.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply