Connecting on one remote computer but not the other on sql server 2005

I am unable to connect to a remote server on Computer A from Computer B, but when I reverse it I am able to connect to a remote server on computer B from computer A. I have SQL Server 2005 Developer Edition on both computers. I am using the using the SQL Management Studio to connect. Both Computers have these settings

Using Surface Area Configuration both have local and remote connections checked. Both computers using tcp/ip only checked.

Using Configuration Manager both the sql server and the sql browser are running. Both computers have tcp/ip protocols enabled.

Under the server properties on both computers, under the Security Tab, I have SQL Server and Windows Authentication Mode checked. Under the Connections tab I have Allow remote connections on this server checked.

I believe I have the Security for both the server and databases done properly giving them both proper Logins and User Roles with the proper permission.

Also went to my window firewall settings and under the Exceptions tab, I added both the sql server.exe and sql browser.exe programs on both computers on my remote network.

But when I connect on Computer B, I get an error message stating:

TITLE: Connect to Server

Cannot connect to 'ServerName'

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

BUTTONS:

OK
-

I tried pinging server a and then server b and they both pinged.

Could someone please tell me what could be wrong on my remote computers.

What is your connection string? Did you test using OSQL or SQLCMD? One cornor case might be an outdated alias defined. Please check my blog for details with alias.|||

have u excempted UDP Port 1434...

Refer following links

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1221936&SiteID=1

http://madhuottapalam.blogspot.com/2007/01/sql-browser-service-in-sql-2005.html

Madhu

|||

Thank you for the reply. Using sqlcmd , the connection string on my local computer is:

sqlcmd -s "servername". This works because I get 1>.

when i type on my local computer for the remote server on my laptop my connection string is:

sqlcmd -s "ServerName" This also works because I ge 1>.

But using the Sql Server Management studio and try to Connect To Server:

Server type: Database Engine

ServerName: I go to browse more... and then the Network Service Tab

and my laptop server name is list and I click on that which is SQUEAKRZ.

Under authentication I click on SQL Authentication because that is the login Role I established.

Then I type in the username and password. Then I get my error message.

Is there anything I am doing wrong. Your reply again would be very helpful Thanks Scott

|||Thanks for the reply. Under the windows firewall settings I have added the exemptions for port 1434 on both servers on my remote computers. I one computer I have McAffee Firewall also installed and on my laptop I have Trend PC-cillian. On my laptop I am able to connect to the computers server running McAffee. But from the computer running McAffee I am not able to connect to the server on my laptop running Trend pc-cillian. I not real sure how to check these firewalls to enable udp port 1434 or whether they already are. Your reply would be very helpful along with any other suggestions. This has been baffling me now for at least 2 months. Thank you, Scott