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.

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
Answered 07/05/2016 by: VBScab
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity