Re: New Server Cannot 'See Out'

Wei Lu and James,

I followed your directions and created the Alias (and ensured the protocols are present). I then logged into Server 2 and did exactly these steps:

Start > All Programs > Mircosoft SQL Server 2005 > SQL Server Management Studio.

Once it opened, I logged into the local instance of SQL Server. Then, I did these steps:

In Object Explorer (along left side of screen, with only my local instance showing), I clicked Connect > Database Engine. I then entered the following information:

Server Name = 64.203.xxx.xxx
Authentication = SQL Server Authentication
username = xxx
password = xxx

On the Connection Properties tab, I tried it with default, and also TCP/IP. Each time, I get the message below:



TITLE: Connect to Server
------------------------------

Cannot connect to 64.203.xxx.xxx

------------------------------
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)

Am I doing something wrong or missing something?

Thanks,

Michael

ps. Sorry for my delayed response, was out with a severe cold.


James Vickers wrote:
Also, make sure you look at the network configuration tab (Right-click in enterprise manager on the server in question, choose properties) of the MSDE/SQL Server itself. Sometimes the named pipes and TCP/IP protocols do not get added, and therefore nothing other than enterprise manager can connect!

James


"Wei Lu [MSFT]" wrote:

Hi Michael,

Thank you for your posting!

Would you please try to add an alias of the Server1 in the server 2?

Please follow these steps:

1. Open Start Menu, All Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.

2. In the left panel, click SQL Native Client Configuration, then right-click Aliases, click New Alias.

3. In the Alias-New dialogbox, please type the Alias Name you want , and type the Server1 name in the server section. Type 1433 in the Port No. After that, please click OK.

4. Please try to connect to the Server 1 and let me know the result. Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to Direct connect with ActiveSync
    ... That won't work because you have a connection string that can't be correct. ... You're saying that the database is, but it's not; ... Server 2000, Visual Studio 2008. ... Again sorry if this should be in another form but you say that SQL Server ...
    (microsoft.public.sqlserver.ce)
  • .Net Scalability problem
    ... I finished a Great project using .Net and SQL Server and .Net Mobile ... Million concurrent users ... So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.sqlserver.connect)
  • Re: Communication Link Failure Error
    ... On disconnection from the network, in my code I changed the connection ... string to use SQLOLEDB and sent a SQL query to SQL server which failed as ... unplug the network cable from the client machine and put the cable ...
    (microsoft.public.data.ado)
Loading