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

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

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)

2 answers:

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.

answered Dec 27 '11 at 04:47 AM

Usman Butt
13.8k ● 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-PCMANOJ.

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

Since the options to look into are quite a few, and due to the time constraints, please visit these links. It may help you

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/

Dec 27 '11 at 06:47 AM Usman Butt

(comments are locked)

Do you have default instances or named instances? If you know the instance name of your 2nd laptop then try to type in computernameinstancename directly without using the browse function of SSMS. If you get an error it would be helpful to post the error msg.

answered Dec 27 '11 at 04:49 AM