GRCD
Posts: 18
Joined: Thu Sep 04, 2014 12:05 pm

Browse SQL Server Problem

Hello !!

I'm trying to install an application with SQL Server 2008 R2 Express installed like prerequisite (or not if is already installed). When i try to browse the SQL Servers Advanced Installer shows the "wait.." message while searching for servers and no returns any server. I'm have tried with both options, Network Enum and ODBC. When use ODBC found all servers of the net (I'm testing in a virtual machine) except the server of the local machine. If try with Network Enum not finds any server.
In my local machine runs fine in both modes. The VM machine have a newly installed Win7 x64.

By the way, I've verified that the Server is running. I've updated to 2008 R2 Express SP2 with equal results.

What can i do or try?

Thanks & Regards from Canary Islands.
Guillermo.
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Browse SQL Server Problem

Hello Guillermo,

Indeed our "Browse for SQL Server" support may not discover all the SQL instances installed on your network. Currently we are working on several improvements which will be added to our "Browse for SQL Server" support so we can enhance its functionality.

Also, please keep in mind that an SQL Server instance will not be detected if its "SQL Server Browser" service it's not running. For a detailed list of reasons why the SQL Server instances are not discovered you can take a look on our "Browse for SQL Servers" article.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
GRCD
Posts: 18
Joined: Thu Sep 04, 2014 12:05 pm

Re: Browse SQL Server Problem

Hello Daniel,

Effectively the SQL Browser service was not running, but when started i can see the local instance only with the ODBC option, and is showed in this format:

"Server\Instance;Clustered:no;Version:10.50.4000.0"

Can I remove the Clustered and Version information?

Thanks & Regards from Canary Islands.
Guillermo
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Browse SQL Server Problem

Hello Guillermo,

I'm afraid currently this is not possible. We'll try to add this improvement in a future version of Advanced Installer. Thank you for your suggestion. We'll let you know as soon as this improvement will be out.

Also, please keep in mind that the item value selected in your SqlServerBrowseComboBox/SqlServerBrowseListBox combo box/list box will be set only to the ServerName.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
GRCD
Posts: 18
Joined: Thu Sep 04, 2014 12:05 pm

Re: Browse SQL Server Problem

Hello Daniel,

I have the servername already, How can transfer the selected value in the browser list to a variable? This value must passed to the windows register for the aplication inicialization.

Thanks !!
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Browse SQL Server Problem

Hello Guillermo,

The selected value within a list/combo box control will be stored right in the list/combo box associated property. So, you will have to use the list/combo box associated property to get the selected value.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Dan
Posts: 4530
Joined: Wed Apr 24, 2013 3:51 pm

Re: Browse SQL Server Problem

Hello,

This improvement has been added in version 11.7 of Advanced Installer released on December 16th, 2014.

Best regards,
Dan
Dan Ghiorghita - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”