>>>
>>>In 2008 you can go to properties on the server in SSMS Object Explorer, go to the connections node, and select Allow remote connections to this server. By default, SQL2005 and 2008 do not allow remote connections.
>>>
>>>>
>>>>
>>
>>That checkbox is already checked. Protocols are already on. I am authenticated to the server from my workstation. I can't imagine (except firewall) what else could be causing this.
>>Tim
>
>Is the firewall on the server box set to allow TCP port 1433 in and out? That is the port SQL Server uses.
I am not sure about "In" and "Out" but I added both ports 1433 for tcp and port 1434 udp as exceptions in the firewall on the server box. I think 1434 udp is the SQL Browser.
Under Windows Firewall, Change Settings, Exceptions tab, then add port.
Tim
Timothy Bryan