Wednesday, March 7, 2012

Can't register SQL Server 2000 database with 2005 Management Studio

I was told (by a Microsoft architect) that this works, but can't find any documentation or any clues within Management Studio.

The only way I can see to register a database is to make it a "Database Engine" (whatever that is). I give it a server name and SQL Server login. Error is:

TITLE: Connect to Server

Cannot connect to <servername>.


ADDITIONAL INFORMATION:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476


BUTTONS:

OK

Mark,

I'm going to move this thread to the Tools General forum where I think you'll get a faster response.

-Jeffrey

|||Make sure that the server is reachable from the machine and that it is using the default port, otherwise you have to specify the different port with the syntax Servername\InstanceName,Port or for default instances Servername,Port.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Also, you should have no problems registering the server, but you might have problems connecting to it [either OE or a new QE window]. If so, like the author above noticed, you might be having problems with the port, enabled protocols etc...|||Success! Thanks Jens. I never would've guessed that syntax.

No comments:

Post a Comment