Connecting to SQL 2008

Last Post 09 Sep 2009 03:13 AM by kevincheang. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kevincheang
New Member
New Member

--
02 Sep 2009 01:57 AM
Dear all,

I have installed SQL2008 Developer Edition on Windows Server 2008.

I can remote access the above server and running SQL 2008 Management Studio.

However, I can't access it by other pc.

I installed SQL 2008 Management Studio in my pc (XP SP3) and connect it but failed.

SQL 2005 management studio also failed.

By the way, I have checked the SQL 2008 Server can accept remote access. (Right click server properties --> Connections --> allowed remote connections to this server.)

Also the firwall of the server is disable.

TCP/IP also enabled.

It show the below error when connecting:

An error has occurred while establishing a connection to the server. When connection 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)

How can I do?

Can SQL 2005 Management Studio / Query Analyzer connect to SQL 2008?

kevincheang
New Member
New Member

--
09 Sep 2009 03:13 AM
I try use IP with port no. is still fail. (i.e. 192.168.1.12:1433)

BTY, I login the server and using SQL 2008 Management Studio to management other SQL2005 server and work!

Hence, the network is ok. It seems that the problem of my SQL2008 Server.

My version is SQL Developer Edition.

any hint about it..

Kevin

You are not authorized to post a reply.

Acceptable Use Policy