question

MuhammadAmmadShah-7711 avatar image
0 Votes"
MuhammadAmmadShah-7711 asked Cathyji-msft commented

SQL server network browsing

HI,

I am installing an application that is bundled with SQL Express edition. There is an option to change the Database server, I have installed a standard 2012 edition of SQL Server on the same host.
When I try to change the database instance from desktop edition to standard edition I am unable to view the instance while browsing SQL.

I can see other instances over the network as well as on localhost desktop edition.

The named pipe is enabled on the standard edition. connections are allowed, the dfirewall is disabled (even though it's a local database).

Idea??

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MuhammadAmmadShah-7711,

We have not received a response from you. Did the replies could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog edited

So what happens, if you simply type .\InstanceName? Or just ., if this is a default instance? Can you connect?

Else the reason could be that Hide instance is set to Yes for the instance. You find this setting in the SQL Server Configuration Manager. Open the node SQL Server Network Configuration, and select the Protocols for this instance, and right-click properties. See the screen-shot below.

86595-image-2021-04-11-181152.png



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @MuhammadAmmadShah-7711,

When I try to change the database instance from desktop edition to standard edition I am unable to view the instance while browsing SQL.

Is this a named instance or default instance? Did you try to using SSMS to connect to the SQL server 2012 standard edition? Using SSMS 18.8, you can get it from here. In the Server name box, type the name of the instance of the Database Engine. For the default instance of SQL Server, the server name is the computer name. For a named instance of SQL Server, the server name is the <computer_name>\<instance_name>.  

Please check the ‘Hide Instance ‘option as Erland mentioned, set the Value of this to NO.


If the response is helpful, please click "Accept Answer" and upvote it, thank you.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.