This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Change SQL Logon
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 08, 2010
10:12 AM
Change SQL Logon
Hi,
we have a customer which installed our product on a local SQL Server 20005. After installation our customer moved the created database to a central SQL Server 2005 instance. Now he got the problem to perform a patch, beacause the sql credentials are false.
How can I decrypt the sql credentials in registry to change the credentials.
We tried to perform the patch by console with following parameters:
runas /user:Domain\UserName /savecred "Patch_2.0.21.0.exe /v\"IS_SQLSERVER_DO_NOT_USE_REG=1 IS_SQLSERVER_SERVER=DBServerInstance IS_SQLSERVER_DATABASE=engDAX20 IS_SQLSERVER_AUTHENTICATION=0\""
But the following message occured:
Login failed for user 'NT AUTHORITY\ANONYMOUS '. Although the customer tried with a domain user.
we have a customer which installed our product on a local SQL Server 20005. After installation our customer moved the created database to a central SQL Server 2005 instance. Now he got the problem to perform a patch, beacause the sql credentials are false.
How can I decrypt the sql credentials in registry to change the credentials.
We tried to perform the patch by console with following parameters:
runas /user:Domain\UserName /savecred "Patch_2.0.21.0.exe /v\"IS_SQLSERVER_DO_NOT_USE_REG=1 IS_SQLSERVER_SERVER=DBServerInstance IS_SQLSERVER_DATABASE=engDAX20 IS_SQLSERVER_AUTHENTICATION=0\""
But the following message occured:
Login failed for user 'NT AUTHORITY\ANONYMOUS '. Although the customer tried with a domain user.
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 08, 2010
01:40 PM
Can you check if the ISSQLServerInstall and ISSQLServerUninstall actions are configured to run in user context? If not, change them to do so, and then see if it solves your issue.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 09, 2010
12:56 AM
where can i change to user context? Do you mean the In-Script Execution of the actions? There is no option for run in user context. Which options should i select.
At the moment it is configured to run "Deferred execution in system contex".
At the moment it is configured to run "Deferred execution in system contex".
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 09, 2010
09:45 AM
Yes, please change the In-Script Execution setting from "Deferred execution in system contex" to "Deferred execution", and see if the problem is solved.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 11, 2010
01:26 AM
thanks that solved the problem 🙂