Loading
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.

  • 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.
    Expand Post

Loading
SQLServer instance name