(local) not connecting

[MLiss@Cetrus.com]

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 (103.33 KiB) Viewed 2834 times

When I specifically call out the machine and instance it works.

Local_SpecificallyCalledOut.PNG (73.27 KiB) Viewed 2834 times

It does pick up other SQL Server boxes on the network... so I assume the search is working...
Mike

OtherServers.png (37.59 KiB) Viewed 2834 times

I am on Windows 7 and SQLServer 2014 Express

Thanks

[FleX]

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]

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 (44.32 KiB) Viewed 2829 times

it worked.

Local_Working.png (42.09 KiB) Viewed 2829 times

Consider this closed.

[Eusebiu]

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