Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Installing on SBS Server
Message
From
31/12/2009 10:48:46
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Installation
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01441215
Message ID:
01441384
Views:
21
>>>
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform