Jul 24, 2014
04:02 AM
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? Thank you.
... View more
Labels
- Labels:
-
InstallShield 2012
Latest posts by dsacristan
Subject | Views | Posted |
---|---|---|
4170 | Jul 24, 2014 04:02 AM |
Activity Feed
- Posted Service trying to access SQL Server 2012 using Local System Account on InstallShield Forum. Jul 24, 2014 04:02 AM
- Tagged Service trying to access SQL Server 2012 using Local System Account on InstallShield Forum. Jul 24, 2014 04:02 AM
- Tagged Service trying to access SQL Server 2012 using Local System Account on InstallShield Forum. Jul 24, 2014 04:02 AM
- Tagged Service trying to access SQL Server 2012 using Local System Account on InstallShield Forum. Jul 24, 2014 04:02 AM