Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Problem connecting to Linked server
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 27th July 10:09
sandy
External User
 
Posts: 1
Default Problem connecting to Linked server


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
  Reply With Quote


  sponsored links


2 27th July 10:09
sue hoegemeier
External User
 
Posts: 1
Default Problem connecting to Linked server


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>
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666