Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Installing on SBS Server
Message
De
31/12/2009 10:48:46
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Installation
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01441215
Message ID:
01441384
Vues:
22
>>>
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform