x

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
more ▼

asked Dec 26 '11 at 11:42 PM in Default

kalpana gravatar image

kalpana
1 1 1 1

what error do you get if you try to connect to the desired instance?
Dec 27 '11 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 '11 at 04:47 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

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 ------------------------------
Dec 27 '11 at 05:40 AM manojbaba100
SQL Server Browser is running? Windows Firewall up and running but without configuration regarding the instance?
Dec 27 '11 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 '11 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 '11 at 04:49 AM

DirkHondong gravatar image

DirkHondong
1.3k 14 17 19

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1933
x1816
x18

asked: Dec 26 '11 at 11:42 PM

Seen: 1409 times

Last Updated: Dec 29 '11 at 12:36 AM