AskJeeves2112
asked on
SQL account (non AD) needs to be changed
I have a server running Server 2008 R2/64 and SQL 2008 R2/32 installed. After restoring the main database, I can log in with sa and Windows authentication OK, but a SQL account needed for a third party application can not authenticate. I need to reset the password on this SQL account. Logging in with Windows authentication and right-clicking the account does not work. Any ideas?
Thanks
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Running the grant query gives this message:
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The sa is not a sysadmin? This is the same database from an old server where sa had full access. Just restored it to a new SQL install. Logging in with Windows authentication (using AD administrator) did also. Neither works here now.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Switching from SQL 2008 R2 32-bit to the 64-bit version worked.
ASKER
Getting this error when the other query is run:
exec sp_password @new='THE_NEW_PASSWORD', @loginame='THE_USER_NAME_T
of course you need to change the login name and new password listed in the example.
Msg 15007, Level 16, State 1, Procedure sp_password, Line 29
'DTAdmin' is not a valid login or you do not have permission.
Am logging in with SQL authentication using sa; have also tried Windows authentication.
Also tried it this way:
Use DeliveryTracking;
Go
EXEC sp_change_users_login 'update_one', ‘dtadmin’,’dtadmin’;
Go
Same type of error. Thoughts?