question

kalpana avatar image
kalpana asked

sql instances not showing in the wireless network

I am new to the SQL Server . I am trying to learn about it. I have two sql server instances installed in two different laptop and both laptops are connected in the same wireless network home group. I tired to access one instance from the the other using Management studio but the other instance is not showing up .Is there anyway I can troubleshoot it ? when I run osql - L it will showup all my instances. I want to access one instances from others just to make one of the instances subscriber for my replication. one of instance is sql 2008 and other in sql 2005. Thanks
sql-server-2008sql-server-2005server-instances
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

what error do you get if you try to connect to the desired instance?
0 Likes 0 ·
Usman Butt avatar image
Usman Butt answered
If you wanted to see the servers through SSMS, In "Connect to Server" dialog box -> select "Browse for more" option in the "Server name" drop down -> Go to "Network Servers" tab. This will provide you all your network instances. Hope this is what you require.
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks I could now connet to the default instance of 2005 instance by using network server but still my named instance (2005) is not showing up in 2008 SSMS. I have enabled the remote acess in both server and TCP/IP and named pipe are both enabled in both instances. and when I tried to create subscriber for sql server 2005 even for defult instance from 2008 publisher it is showing following messages. TITLE: Connect to Server ------------------------------ Cannot connect to KALPANA-PC\MANOJ. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------
0 Likes 0 ·
SQL Server Browser is running? Windows Firewall up and running but without configuration regarding the instance?
0 Likes 0 ·
yes Server Browser is running in both laptops.I even tried to include port 1433 by using wf.msc but im sure I did it correctly or not .
0 Likes 0 ·
DirkHondong avatar image
DirkHondong answered
Do you have default instances or named instances? If you know the instance name of your 2nd laptop then try to type in computername\instancename directly without using the browse function of SSMS. If you get an error it would be helpful to post the error msg.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.