I have created an ini file that installs/creates a SQL Server instance. I am able to connect and modify the databases attached to this instance fine. However, if anyone else logs onto the machine, they can start the service fine but then get errors when trying to open connections. What I need is for all users that log into the machine to have all permissions on the SQL Server instance. I have seleced "Windows authentication mode" when building the install. What setting am I forgetting that will give everyone the correct permissions?
+1
A:
Create a login to cover all users:
create login [BUILTIN\Users] from windows;
Grant this login the priviledges needed by everyone.
Remus Rusanu
2009-08-13 17:43:59
Setting SQLSYSADMINACCOUNTS="BUILTIN\Users" in my SQL install ini file got it working for all admin users. But, we're doing final testing now and it's not allowing non-admin windows users to attach to the databases. Any ideas?
bsh152s
2009-10-29 15:50:54