Installation is fine but at the end it prompts an error like this.
" ' ' is not a valid login or you do not have permission. "
I use "NT Authentication\System" and I add the current user to the SQL server administrators section.
Then I read some forums and found my "user name" and "pchost name" are same. It appears like "myname\myname". It may be the issue. I created a new admin user with a different name and try to re-install the server again.
There were no errors. Finally I realize, if I try the default Administrator account to install SQL server it will not create an unnecessary account.
My opinion is :-
- Remove the SQL server.
- Log out from the user.
- Then press two times Alt+Ctrl+Del.
- Then type "administrator" as the username and press enter (If you have setup the password to the administrator account you need to give it.)
- Start the installation.
- Use NT Authentication\System.
- Give a password to the SA (default) account.
- Add current user.
- And continue.