Humm that is interesting as I haven't had to do anything except create
the server. But I do have to do an OPENQuery to the other servers to
pull data.
Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886
-----Original Message-----
From: Davis Ralph
[mailto:mssqldba-ezmlmshield-x35812351.[Email address protected]
Sent: Wednesday, January 31, 2007 11:07 AM
To: LazyDBA Discussion
Subject: RE: URGENT: Linked Server
I assume this is 64 bit sql. It worked for me in 32 bit but not 64 bit.
You must apply the instcat.sql file to the 2000 server. It is located
in the install directory of the service pack for SQL 2000 you are
running. Then 2005 64bit can talk to the 2000 32 bit server.
Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************
-----Original Message-----
From: Stephen Davey
[mailto:mssqldba-ezmlmshield-x33709235.[Email address protected]
Sent: Wednesday, January 31, 2007 10:02 AM
To: LazyDBA Discussion
Subject: Re: URGENT: Linked Server
Tracy,
I tried to link a 2005 server to 2000 server from EM 2000 and it didn't
work. However, in Server Management Studio (SMS) 2005 I could link to
the 2000 server from 2005 server. I would think you should be able to
do the same with SQL 7. In other words, connect to 2005 server in SMS
then attempt to create link to your SQL 7 server.
S. Davey (1/31)
MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )
>>> "Tracy Posner "
<mssqldba-ezmlmshield-x62402309.[Email address protected] 01/31/07
10:13 AM >>>
Hello,
I am trying to create a linked server from SQL Server 7 to SQL Server
2005. I
am doing it through Enterprise Manager by right clicking to create a
new
linked server. Server type is SQL Server and I am using 'they will be
mapped
to' and the remote servers sa login info.
After I put in the information and login/password, I get the message '
An
error occurred while retrieving the OLE DB provider properties, are you
sure
you want to save the Linked Server Settings?'
I click Yes, to go by and then it says [SQL-DMO] Unable to connect to
the
specified server. Check the server name, login name and password. Would
you
like to continue to create the linked server? I know that I am using
all the
correct login and connection info.
If I click Yes to go by this, it creates it, but if you click on tables
under
the Server named in Linked Servers a box pops up and says Error 4:
Connection
Broken.
Can you create linked servers between SQL Server 7 and 2005? Is there
something else I need to set up?
Tracy G. Posner
Systems & Database Administrator
Maryland Institute College of Art
[Email address protected]
410-225-2563
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
****************************************************************
Confidentiality Note: The information contained in this
message, and any attachments, may contain confidential
and/or privileged material. It is intended solely for the
person(s) or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in
reliance upon this information by persons or entities other
than the intended recipient(s) is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer.
****************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
************************************
This e-mail and any files transmitted with it are proprietary and intended solely
for the use of the individual or entity to whom they are addressed. If you have
received this e-mail in error please notify the sender. Please note that any views
or opinions presented in this e-mail are solely those of the author and do not
necessarily represent those of ITT, Inc. The recipient should check
this e-mail and any attachments for the presence of viruses. ITT accepts
no liability for any damage caused by any virus transmitted by this e-mail.
************************************
MS Sql Server LazyDBA home page