This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gayatriakhani
Level 3
‎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
Labels (1)
Labels
0 Kudos
(2) Replies
hidenori
Level 17
‎Mar 21, 2009 02:39 PM

Please check out this thread.
0 Kudos
gayatriakhani
Level 3
‎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
0 Kudos