on 01-05-2009 8:18 AM
Hi All,
Could you pls let me know the way to unlock the database user SAP<SID>DB from database level as we are facing prob in starting the J2EE Engine, I know the way in Oracle but I don't have neidea regarding sqlserver.
Regards,
Prashant
What is the error message you are getting. It would give us an idea.
You can enable the login in enterprise manager under security. Right click the user and select properties option. Then select the Status from the list on the list which would give you the option of enabling the user.
Thanks,
RT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Prashant,
The T-SQL to do this is:
ALTER LOGIN [SAP<SID>DB] ENABLE; (to enable the account)
ALTER LOGIN [SAP<SID>DB] DISABLE; (to disable the account)
You can also do the same thing as RT said, and go through the GUI. From here, you can always simulate the change in the GUI, and then use the script feature to see what SQL Server will do behind the scenes. Capture that code, and then use it however you want to.
Hope this helps!
Jason
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.