Login failed for 'sa' user in SQLserver 7.0 enterprise mngr

greenspun.com : LUSENET : SQL Server Database Administration : One Thread


I am running into a problem loggin into SQLsrver 7.0 using 'sa' account but works fine admin account(NT acct)

I have installed sqlsrvr 7.0 on win2k - server standard edition. Installed SQLserver using NT domain account. I have created a username 'sa' with admin previleges. When I try to login with sa, login fails in the enterprise manager. ?

I tried to re-install the server7.0 using local account, again unable to login with 'sa' account in the enterprise manager

Appreciate if you could shed some lights on this issue

-- Anonymous, January 28, 2004



As stated on the "Post a New Message" form, questions on version 6.5 and 7.0 are no longer answered on this forum.


-- Anonymous, January 28, 2004

Moderation questions? read the FAQ