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

MacRae (p.macrae (AT) gmail (DOT) com) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Mar 28, 7:10 am, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Network Configuration.. The righthand pane displays:

" There are no items to show in this view"

Is this a bad SQL Server Installation?

MacRae (p.macrae (AT) gmail (DOT) com) writes:
First check: you are doing this on the remote computer where you believe the
server instance to be installer, aren't you? It's no point running this on
the client machine.

If you are really seeing this on the server, you are indeed in some of
trouble. If you connect with a query tool and say "SELECT @@version",
what does it say?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx