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