Posted by MacRae on 03/27/07 06:28

Please bare with me here:

I have been running an SQL Express backend for a small project i've
been working on. We've recently added a "small business server R2" and
I would like to migrate my existing SQL Server database/tables etc.
onto this server.

Now there is an sql server instance running called "SBSMONITORING"
that I can view remotely, but not access. How do i enable remote
connections so that I can access the SBS SQL Server?

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

[Back to original message]