RE: Cannot start Replication - "Remote Desktop Connection" or TCP/IP
- From: voidptr78 <voidptr78@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2007 00:28:00 -0700
One more thing to add I guess - the Surface Area Config. is set to remote
connection over TCP/IP and Named Pipes. And the error in question says:
TITLE: Connect to Server
------------------------------
Cannot connect to DHATMDB1.
------------------------------
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
------------------------------
.
- Prev by Date: Re: MS SQL Read-Only?
- Next by Date: Query Oracle database without linked server
- Previous by thread: MS SQL Read-Only?
- Next by thread: Query Oracle database without linked server
- Index(es):
Loading