cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Intrepid explorer

SQLServerSelectLogin2 Problem

I am using the same parameters for SQLServerSelectLogin2 in 3 InstallScriptMSI projects. All 3 were working and now the 'Browse' list of database servers is empty for one of the projects. I compared the InstallScript code between projects and it is identical. What could have happened?
Thanks
Labels (1)
0 Kudos
3 Replies
Highlighted
Pilgrim

Re: SQLServerSelectLogin2 Problem

Would it be possible for you to post a project that replicates the behavior so that I can look into the issue?

Thank you.
0 Kudos
Highlighted
Intrepid explorer

Re: SQLServerSelectLogin2 Problem

Great! Thanks.
I will send project via PM later today.
0 Kudos
Highlighted
Intrepid explorer

Solved

Thanks Hidenori for pointing out simple mistake in my InstallScript code.
As you pointed out, the first parameter for SQLServerSelectLogin2 must specify a connection name present in the ISSQLConnection table.
I see now that the reason it worked at one time and quit is because I removed some unused SQL scripts from the SQL view and that (properly) removed an entry from the ISSQLConnection table.
All is well now 🙂 Thanks Again!
0 Kudos