Posted by Erland Sommarskog on 03/27/07 21:10

MacRae (p.macrae@gmail.com) writes:
> What I did with SQL Server express was to install the SQLEXPRESS
> Management software and enabled it through "Surface area
> configuration" but when I load this same software onto the R2 server
> it comes up with an error. I'll post the error when i'm at work and
> have access to the specific text it says if this thread generates any
> instance.
>
> cliffs: How do i enable remote connections to an sql server running on
> SBS R2 ? I'd be happy to do it within the SQL command prompt

If the Surface Area Configuration tool is out to lunch, try the SQL Server
Configuration Manager. Find the node for SQL Server 2005 Network
Configuration, and then protocolls fro SBSMONITORING. Double-click
TCP/IP, and go the IP Addresses node. There you can enable/disable
TCP/IP for each IP address the machine has.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]