Dead End...

Hi,

I want to register a new server,

I go to Server Management Studio -> Right Click Database Engine -> New -> Server registration

Make up a server name and test

Apears the "..sql server does not allow remote connections..."

I go to surface area configuration for services and connections, but it doenst have any components, because i have to make a server registration first!

I dont understand...

If you please help me...

Thanx

Best Regards

Can't you connect to the local server by using the Surface Area Configuration tool on the remote server?|||

Can you check whether the SQL Server services have been started onthat machine?

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=12&faqid=143 fyi.

|||

Hi again,

Thank you for the asnwer,

first i install the express edition, it makes a registration of a server automatically (my computer name)\sqlexpress, i made my database etc...

Now i want to make a new server registration, i've been in (F1) help but it doenst seem clear, i cant find the change computer, nor the feature configuration, and dont know how i can see if the system is runing...

I've went to this page

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=12&faqid=143

but it only explains the SAC system that i have done...

|||

You need to either log in to the console of the server machine or use remote desktop to log in. Then you can run the local SAC tool on the server machine to start SQL Server if it isn't running and to configure SQL Server to accept connections from TCP/IP. You'll also need to make sure the firewall on the server machine is configured to allow access to the port SQL Server is using.

Here's a blog post that will run you through the process step-by-step: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx. The information in this KB article might help too: http://support.microsoft.com/default.aspx?scid=kb%3bEN-US%3b914277

Hope this helps,
Steve

Deactivated?

Merge replication.
Push New Subscription.
Immediately after I click "finish" in the wizard (push new subscription),
the subscription status shows deactivated. The merge agent runs and
completes then shows status has failed. error = "the subscription to the
publication pub_name is invalid. The remote-server is not defined as a
subscription server. 14010"
Your problem is that the remote server is not enabled as a subscriber. I'm
not trying to be flippant, but this might take a little back and forth to
fix.
First off - all publications/subscriptions are marked as deactivated until
the snapshot agent runs. So this status is not problematic in your case.
To enable your subscription server as a subscriber, go to tools,
Replication, Configure Distributor, Publishers, and Subscribers, click on
the subscriber tab, locate your subscriber or register it.
You might also want to review this pdf -
http://www.nwsu.com/lowres_replication_ch02.pdf
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:%23cKdOIoAFHA.904@.TK2MSFTNGP12.phx.gbl...
> Merge replication.
> Push New Subscription.
> Immediately after I click "finish" in the wizard (push new subscription),
> the subscription status shows deactivated. The merge agent runs and
> completes then shows status has failed. error = "the subscription to the
> publication pub_name is invalid. The remote-server is not defined as a
> subscription server. 14010"
>