sandy

Hi,
I have installed SQL Server 2005 on 2 machines say machine1 and
machine2. I want to add machine2's named instance (viz., Instance1)
as a liked server to machine1. This I achieve by executing the
following procedure:
sp_addlinkedServer @server='Machine2_Instance1',
@srvproduct='',
@provider='SQLNCLI',
@datasrc='machine2\Instance1'

I saw an example in BooksOnline and followed the same for my SQL 2005
Server. But I am not able to access machine2\Instance1's database
using my SQL Server Management studio. I am getting an error:
An error has occurred while establishing a connection to the server.
When connecting to the SQL server this failure may be caused by the
fact that unser the default settings SQL Server does not allow remote
connections.

Any suggestions?
Thanks,
Sandhya

sue hoegemeier

Have you tried using the Surface Area Configuration to
enable remote connections for the Database
Engine on Machine2? You will also want to make sure you have
the SQL Server Browser service running. You can do this in
the SAC as well.

-Sue

On 15 May 2006 21:19:21 -0700, "sandy" <sanchin82@gmail.com>