Wednesday, March 7, 2012

run a new server registration

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 becaused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL NetworkInterfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)

what could be wrong?

How can I run the server?

Thanks!

Make sure Named Pipes and TCP/IP network are enabled.

You can set from Sql Server Configuration Manager.

|||Is the new registered SQL a remote instance? Make sure the server name is correct, and SQL Browser service is running on the SQL box.|||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?|||

yes

Named Pipes and TCP/IP network are enabled

|||You can start SQL Browser from services.msc or "SQL Server Configuration Manager". Is?the?new?server?you?want?to?register?a?remote?server??If?so?you?can?take?a?look?at?this?post:
http://forums.asp.net/thread/1289341.aspx

No comments:

Post a Comment