We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

MLiss@Cetrus.com
Posts: 366
Joined: Wed Dec 30, 2015 5:40 pm

(local) not connecting

Hi,

I have a setup project where I am using the SQLServerConnectionDlg and the server is initially set to the predefined (local)
However, when I run it, it does not connect.
( I show SSMS running in the background to provide a reference to the instance name of the Database )
Local_NotWorking.PNG
Local_NotWorking.PNG (103.33 KiB) Viewed 3790 times
When I specifically call out the machine and instance it works.
Local_SpecificallyCalledOut.PNG
Local_SpecificallyCalledOut.PNG (73.27 KiB) Viewed 3790 times
It does pick up other SQL Server boxes on the network... so I assume the search is working...
Mike
OtherServers.png
OtherServers.png (37.59 KiB) Viewed 3790 times

I am on Windows 7 and SQLServer 2014 Express

Thanks
FleX
Posts: 4
Joined: Mon Sep 26, 2016 3:42 pm

Re: (local) not connecting

I don't work for Advanced installer or anything, but I do a lot with SQL Servers. Try putting the SQL_Express after your local like this : (local)\SQL_Express.

Local essentially takes the place of your computer name. You still need to reference the SQL instance.
MLiss@Cetrus.com
Posts: 366
Joined: Wed Dec 30, 2015 5:40 pm

Re: (local) not connecting

I did some research on SQL server and it turns out I did not have SQL Server Browser service enabled or running ...
as soon as I enabled and turned on the service...
SQL_Browser.PNG
SQL_Browser.PNG (44.32 KiB) Viewed 3785 times
it worked.
Local_Working.png
Local_Working.png (42.09 KiB) Viewed 3785 times
Consider this closed.
Eusebiu
Posts: 4971
Joined: Wed Nov 14, 2012 2:04 pm

Re: (local) not connecting

Hi,

I'm glad you got this working. Thank you for sharing the solution, I'm sure it will help other users in the future.

Best regards,
Eusebiu
Eusebiu Aria - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”