Service trying to access SQL Server 2012 using Local System Account
We are upgrading the database of our solution from SQL server 2008 to SQL server 2012. Using the same installer we found that we have a permissions problem accessing the database (using the Local System Account).
I found two potential solutions:
1. Give owner permissions to the guest user in the database (EXEC sp_addrolemember 'db_owner', [guest])
2. Change the Log on account in the service to the account that created the DB fix the problem also solve the problem.
The first solution is not very secure so we are thinking in requesting a user account during the installation to link it to the service.
Is there a way to solve this problem using the Local System account?
If we go with solution 2. How can we link in InstallShield 2012 a user account to our service?
Is there a different or easier way to solve this problem?
Permissions are changed by SQL Server the moment you attach a database. This is by design according to Microsoft for security reasons. I have run into a similar issue and this is what my investigation turned up. So setting permissions on a particular MDF/LDF is moot.
