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