cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
bobmcm461
Pilgrim

SQLServer instance name

I'm working on an InstallScript MSI package, and trying to setup some default records in a config file. I'm retrieving the SQL Server name via the IS_SQLSERVER_SERVER property. I have run into an issue where the property does not maintain the instance name of the SQL Server. Is there a way to have the property contain the fully qualified SQL server name?

Thanks,
Robert M.
Labels (1)
0 Kudos
1 Reply
bobmcm461
Pilgrim

Solution

To resolve this issue, I have added a line of code to the OnSQLLogin function to create a new property.

MsiSetProperty(ISMSI_HANDLE, "IS_SQLSERVER_SERVER_FULL", szServer);

and then used this property to change the config file.

Thanks,
Robert M.
0 Kudos