run a new server registration

[tuzojazz]

Hi:

My pc is windows 2003 server and I have installed SQL SERVER 2005 EXPRESS.

From Management Studio I made a New Server Registration with Windows Authentication.

I can't run the new server, its icon appears with a white dot (instead of green when a server is running or red when the server is stopped)

I go to server properties and click the "Test" button and I get the next message error:

Testing the registered server failed. Verify the server name, credentials, an database, an then click Test again.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)

what could be wrong?

How can I run the server?

Thanks!

 

[ptheriault]

you need to enable remote connections.
Run the surface area configuration tool.
Click on the link for Surface Area Configuration for Services and Connections.
For the database Engine select Remote Connections
Select Local and Remote Connections

- Paul
- Database performance looks fine, it must be the Network!

 

[SQLBill]

Is the name correct? Can you ping it from a command line? Maybe the DNS isn't set to do name resolution. Try registering it via the IP address instead of the name.

Is your login on SQL Server a Windows Authetication login or SQL Server Authentication? Did you even create a login for yourself?

Have you tried logging on with the SA login?

-SQLBill

Posting advice: FAQ481-4875

 

[tuzojazz]

I am new in sql server

How do I know if the name is correct?

do you mean the name of the new server registration?

Why does the icon appear with a white dot (instead of green or red)?

The login is a Windows Authetication

 

[ptheriault]

have you confirmed that the services are running. Open up windows services and confirm that all the sql services are started. then check your configuration with the surface area configuration tool. If remote connections is not checked you are not going to be able to connect with SSMS.

- Paul
- Database performance looks fine, it must be the Network!

 

[tuzojazz]

I have enabled remote connections at the surface area configuration tool but when I register the new server at Management Studio I get the same message box when I test this new server.

The type of server I want to register is Database Engine

The icon appears with a white dot again.


At the surface area configuration tool I can't start SQL Server Browser. Start, Stop, Pause and Resume buttons are disabled.

The default database engine server is running, its name is server1\sqlexpress.

Why I can't register another server?