Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Installing on SBS Server
Message
From
31/12/2009 10:52:43
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:
01441385
Views:
24
>>>
>>>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.

OK, it is definately a firewall issue. I just turned the firewall off on the SBS server and was able to connect right away. Now in order to turn it back on, I have to figure out what needs to be changed to make it work.
Tim
Timothy Bryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform