How do I get all users on a PC access to a SQL 2014 Instance / Database
Posted on 2014-07-17
I've developed an app in VB (Visual Studio 2008). It uses SQL for the database.
I've written code to create an instance in SQL Server and create the database.
Currently I'm trying to have my app check to see if SQL is installed locally, if not then run a silent install of SQL 2014 Express. Which is working fine, however, it seems only the user that was logged on when SQL was installed has access to the Database.
Joe installs my app and it finds that there is no SQL installed. My app installs SQL, Prompts him to create a database and then the app opens up and all is good.
Now Jane logs into the same PC (Users are local **NO DOMAIN**) and tries to use my app. And gets the error that her username cannot logon to the SQL.
Here's my unattend code for installing the SQL 2014 Express with tools:
Process.Start("C:\SQL2014WT\setup.exe", "/q /Action=Install /IACCEPTSQLSERVERLICENSETERMS /Hideconsole /Features=SQLEngine,Tools /InstanceName=DT_DBS /SQLSYSADMINACCOUNTS=""NT AUTHORITY\SYSTEM"" /SQLSVCACCOUNT=""NT AUTHORITY\SYSTEM"" /BROWSERSVCSTARTUPTYPE=""Automatic""")
When I open SQL Management Studio as Joe, I can add Jane giving her access, How can I allow ALL users access without having to do this manually. And YES builtin/users is there but doesn't help.