This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- How to get the default SQL Server Name
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 19, 2010
11:38 PM
How to get the default SQL Server Name
Hello,
I am using SQL Server 2008 Express Edition. How can I get the default SQL Server name from Install shield? I am not allowed to use the SQLServerSelect dialog of installshield. I tried getting the SQL Server name with the following code
szKey = "HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL";
szName = "MSSQLSERVER";
RegDBGetKeyValueEx(szKey, szName, nvType, svValue, nvSize)
The variable "svValue" is always blank.
Please suggest me how do I get the default SQL Server Name.
Cheers
Madhu
I am using SQL Server 2008 Express Edition. How can I get the default SQL Server name from Install shield? I am not allowed to use the SQLServerSelect dialog of installshield. I tried getting the SQL Server name with the following code
szKey = "HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL";
szName = "MSSQLSERVER";
RegDBGetKeyValueEx(szKey, szName, nvType, svValue, nvSize)
The variable "svValue" is always blank.
Please suggest me how do I get the default SQL Server Name.
Cheers
Madhu
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Dec 27, 2010
09:38 PM
Have a look at this link--
http://www.installationdeveloper.com/618/sql-server-version-detection-in-installshield/
Regards
Dheeraj
dheerajriets@gmail.com
http://www.installationdeveloper.com/618/sql-server-version-detection-in-installshield/
Regards
Dheeraj
dheerajriets@gmail.com
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 11, 2011
02:04 PM
If the default SQL Server is a 64-bit version, make sure that you set the REGDB_OPTIONS system variable appropriately (something like REGDB_OPTIONS = REGDB_OPTIONS | REGDB_OPTION_WOW64_64KEY) before your registry read.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jan 25, 2011
01:09 PM
I used ServiceExistsService("MSSQLSERVER") and it works without a problem. That way I didn't have to deal with the 64-bit and 32 bit registry.
Robert
Robert
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)