Friday, February 24, 2012

Cannot connect to SQL Server 2005 June CTP

We just install SQL Server 2005 June CTP on a Windows
2003 with SP1 and probably all the additional patches.
We just simply cannot connect to the SQL Server at all.
The SQL Server service is running. When we try to
register and click on Test button, we will just get
Timeout expired. We're using SQL Server Authentication.

We have used the June CTP to do an upgrade from SQL
Server 2000 on a Windows 2003 SP1 but without any additional patch
and we don't have any problem.

By the way, beside this forum, are there any other place in MS website to post questions related SQL Server 2005? So far, I only find this
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us

Thanks for any help,

Peter

Are you trying to connect from a tool (SQL Server Management Studio, for example) that is local to the same server SQL Server 2005 is running on? Or from a different server/client?

By default, SQL Server 2005 now installs with remote connections turned off (secure by default initiative). So, after installing, you have to enable remote connections before you will be able to connect from a different server/client. To do this, use the SQL Server Surface Area Configuration tool.

Dave Fackler

|||

Hi Dave,

I'm trying to connect from SQL Server Management Studio on the same server SQL Server 2005 June CTP is running on.

I just also tried to use osql and I get the following error:

[SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.
[SQL Native Client]Client unable to establish connection.
[SQL Native Client]Login timeout expired.

Thanks,

Peter
Peter

No comments:

Post a Comment