After restoring data from "ABC" database to "XYZ" database we need to update the admin user in to the current database . Best way to get SSID is to take value from "UserInfo" table. or run below command in command Prompt .
Open command window and write Whoami /user, press enter, and SID will be shown
write below command in SQL .
update userinfo set SID='<SID>', Networkdomain = '<Network_domain_name>', networkalias = '<Network_alias>' where id = 'admin'
Open command window and write Whoami /user, press enter, and SID will be shown
write below command in SQL .
update userinfo set SID='<SID>', Networkdomain = '<Network_domain_name>', networkalias = '<Network_alias>' where id = 'admin'
No comments:
Post a Comment