Okay, here is an interesting question that I haven't seen posted here before.
We have an application that is getting close to completion, and I have been tasked with making sure the install program is up to snuff. So in the process of defining what is needed to install the server portion of the package, I would like to automate as much as possible.
Now, I think I have a decent check for checking to see if a given instance of SqlServer is installed on a local machine, that being to check "HKLM\Software\Microsoft\Microsoft Sql Server\<dbname>\MSSQLServer\CurrentVersion\CurrentVersion" for a non-empty value. At least this seems to have panned out for 3 MSDE and 1 Sql2K installs that I have examined.
The problem is that if I don't find a named instance of the database, I would like to be able to grab where the SqlServer setup.exe is and use that to invoke the command line to create our named instance.
Has anyone tried this before? Is there a better way to create a named instance of a database?
thanks,
Jack
Jack De Winter
Software Developer
MedTel Software
We have an application that is getting close to completion, and I have been tasked with making sure the install program is up to snuff. So in the process of defining what is needed to install the server portion of the package, I would like to automate as much as possible.
Now, I think I have a decent check for checking to see if a given instance of SqlServer is installed on a local machine, that being to check "HKLM\Software\Microsoft\Microsoft Sql Server\<dbname>\MSSQLServer\CurrentVersion\CurrentVersion" for a non-empty value. At least this seems to have panned out for 3 MSDE and 1 Sql2K installs that I have examined.
The problem is that if I don't find a named instance of the database, I would like to be able to grab where the SqlServer setup.exe is and use that to invoke the command line to create our named instance.
Has anyone tried this before? Is there a better way to create a named instance of a database?
thanks,
Jack
Jack De Winter
Software Developer
MedTel Software