kefr@itcsyd.dk

Since nobody appears able to help, I've been looking for workarounds. One such is the following. Drawback of this particular one is, that it is dependant on os language. Install the sql server with this switch : /SQLSYSADMINACCOUNTS=".\Users"

Hi. I'm trying to change some security settings on an sql express 2008 installation in order for it to work properly in a piece of software. However, when I run the command to change the permissions, I get an error. If I run the command again hours later it'll work however. And I don't know why. I made a test before leaving work yesterday. The SQL was installed 14:58 without complaints. Then I ran the command in a loop every 20 seconds or so, and it started working 16:47 and kept working until I stopped it this morning. Any input as to why this happends? Command: "%programfiles(x86)%\microsoft sql server\100\tools\binn\osql.exe" -S .\ECSQLEXPRESS -E -Q "use [master] exec sp_addsrvrolemember @loginame = 'ITCSYD\domain users', @rolename = 'sysadmin'" Error message: Msg 15007, Level 16, State 1, Server KEFRTESTPC03\ECSQLEXPRESS, Procedure sp_addsrvrolemember, Line 68 'ITCSYD\domain users' is not a valid login or you do not have permission. ps. the whole thing's run under builtin\system's user context as we're deplying the sql with sccm 2012 and I was running the test script with psexec -s