I have tried:
first delete Win***\administrator - i can't login to recreate it
repair it - still can't login
remove database engine and reinstrall with SQLVM\administrator - solve it... and i have to reattached database.
it was an idiot solution, eh?
I have asked my instructor - Ms. Donabel Santos for a solution, and she said I needed to drop the server and add it again to solve this problem.
sp_dropserver <'old_name\instancename'>However, her solution was for just dropping the old server and adding it again - couldn't solve this problem.
GO
sp_addserver <'new_name\instancename'>, local
GO
Then I found the simplest way: "just rename the login name by correcting computer name."
That is it!
No comments:
Post a Comment