Sunday, February 19, 2012

A problem with connecting to a Oct. CTP server

Hi, folks
I think I need a little help here. I uninstall the beta2 version and installed Oct. CTP. The server was using named-instance so I took it as it was. Installatoin went fine and attached privious databases in SQL Management Studio. That means, I am able to sign on the SQL server in the same box using SQL Management Studio. However, from developers (I believe it's beta2 version) could not register this server (my-dev02\sql2005) on their SQL Management Studio.

The error is
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

I tried from another server (signed on as Domain Admin) using Windows Auth. I got same error msg. IPAddress is enabled, TCP/IP also enabled... Could not think of any more setting. Appreciate in advance.

SunnyFound a trick that is turn SQL Browser service on. Some how it disabled.|||As you found out, as a result of the security considerations, it's off by default for certain SKUs.

No comments:

Post a Comment