I am trying to create a Installer from a Windows Service. During that installation, I need to collect values from the database values from the Installer to form a connection string used in the Windows Service. I was creating my own custom dialog when my Support Specialist informed me about the built-in SQL Server dialog under SQL Scripts. There are default properties like IS_SQLSERVER_USERNAME used. When I informed my specialist that I needed access to those values from my Windows Service, he said that these were only during Install time, and to run SQL Scripts.
Is there any way to get these values?
If not, is there another way to go here where I can collect this information and access it from the Windows Service? Custom dialog and properties - write to registry and read from service? How?
Sam, Your support specialist should be able to help you. How is your Windows Service using the SQL Connection? Is it using registry or app.config values? You should be able to read either of those (registry and XML-style config files) via InstallScript and your support specialist should be able to tell you when and how to do that.
