07/05/2016 5225 views

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:


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:-


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


All Answers

Answered 07/05/2016 by: VBScab
Red Belt