I am trying to install SQL server 2008 Standard and developer edition on windows 7 64 bit machine using configurationfile.ini where I have assigned the following value to SQLSYSADMINACCOUNTS:
SQLSYSADMINACCOUNTS="Builtin\Administrators"I can not access the database and get "access denied" error. I narrowed down the issue and it seems that by default it adds the local administrator (i.e. adminstrator) to sysadmins. How can I add the current logged in user as sysadmin? I have also tried using following values:-
SQLSYSADMINACCOUNTS="%USERDOMAIN%\Users"
SQLSYSADMINACCOUNTS="%USERDOMAIN%\%USERNAME%"But, none of the above worked. Note:- I don't want to hard-code this value as <hostname>\<UserName>, I need this installation to run by any logged-in admin credentials.
