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.


more ▼

asked Dec 26, 2011 at 11:42 PM in Default

avatar image

1 1 1 1

what error do you get if you try to connect to the desired instance?

Dec 27, 2011 at 03:51 AM Usman Butt
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Dec 27, 2011 at 04:47 AM

avatar image

Usman Butt
14k 6 13 21

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


Dec 27, 2011 at 05:40 AM manojbaba100

SQL Server Browser is running? Windows Firewall up and running but without configuration regarding the instance?

Dec 27, 2011 at 05:45 AM DirkHondong

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 .

Dec 27, 2011 at 05:57 AM manojbaba100
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Dec 27, 2011 at 04:49 AM

avatar image

1.3k 15 19 24

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 26, 2011 at 11:42 PM

Seen: 2370 times

Last Updated: Dec 29, 2011 at 12:36 AM

Copyright 2018 Redgate Software. Privacy Policy