On Mar 28, 7:10 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> MacRae (p.mac...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

> 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

> When i go into SQL Server configuration manager --> SQL Server 2005
> Network Configuration.. The righthand pane displays:
>
> " There are no items to show in this view"
>
> Is this a bad SQL Server Installation?