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
- :
- Gives error at the time upgrading SQL Script
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
‎Mar 21, 2009
05:00 AM
Gives error at the time upgrading SQL Script
Hi,
I am using InstallScript MSI project.
I am creating SQL Server database through SQL Script at the time of installation.
Now user have changed password of SQL Server database after installation.
So at the time of upgrade in OnResumeUIBefore, I am again calling OnSQLLogin dialog. So user can enter modified password. But at the time upgrading script it is not using new password and gives exception.
Could not connect to Microsoft SQL Server Login failed for user 'sa'. (18456).
I have also checked, IS_SQLSERVER_PASSWORD property shows correct password in OnResumeUIBefore method after calling SQL Login.
Please help me, It is urgent.
Thank you,
Gayatri
I am using InstallScript MSI project.
I am creating SQL Server database through SQL Script at the time of installation.
Now user have changed password of SQL Server database after installation.
So at the time of upgrade in OnResumeUIBefore, I am again calling OnSQLLogin dialog. So user can enter modified password. But at the time upgrading script it is not using new password and gives exception.
Could not connect to Microsoft SQL Server Login failed for user 'sa'. (18456).
I have also checked, IS_SQLSERVER_PASSWORD property shows correct password in OnResumeUIBefore method after calling SQL Login.
Please help me, It is urgent.
Thank you,
Gayatri
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 21, 2009
02:39 PM
Please check out this thread.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 30, 2009
02:19 AM
Hi Hidenori,
Thank you very much.
This post really helped me a lot and my problem got solved.
Thanks,
Gayatri
Thank you very much.
This post really helped me a lot and my problem got solved.
Thanks,
Gayatri