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: 
bobmcm461
Level 6
‎Dec 04, 2012 02:06 PM

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)
Labels
0 Kudos
(1) Reply
bobmcm461
Level 6
‎Jan 04, 2013 04:28 PM

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