RE: Exporting data to another server
From: Walt (walter@lynxpm.com)
Date: 12/07/02
- Next message: Dejan Sarka: "Re: Lock logins !"
- Previous message: Kent W. England [MVP]: "Critical now means "Critical and Important" [was Re: Microsoft Security Bulletin Severity Rating System Changes"
- In reply to: Alvin Zhao[MSFT]: "RE: Exporting data to another server"
- Next in thread: Alvin Zhao[MSFT]: "RE: Exporting data to another server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Walt" <walter@lynxpm.com> Date: Fri, 6 Dec 2002 16:02:30 -0800
Thanks anyway, Alvin, however none of your suggestions
work. I can't log on to the remote server as sa because
the only valid login is LynxServer. I finally got
everything up to the remote server by copying the SQLs
generated by DTS for triggers, stored procedures, foreign
keys, etc., modifying them for the correct owner, and
running the SQLs on the remote server with EM. Anyway,
the problem is solved for now.
Thanks again for your help.
>-----Original Message-----
>Hi Walt,
>
>You can use SQL Server authentication and use sa as the
login in both
>source and destination SQL Server to export data. In
this way, you can
>resovle the problem. If you want use the domain account,
please make sure
>that you logon to Windows with that account and the
domain account is a
>valid login for the SQL Server to which you use the
domain account to log
>on.
>
>
>Sincerely,
>
>Alvin Zhao
>Microsoft Support
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>
>.
>
- Next message: Dejan Sarka: "Re: Lock logins !"
- Previous message: Kent W. England [MVP]: "Critical now means "Critical and Important" [was Re: Microsoft Security Bulletin Severity Rating System Changes"
- In reply to: Alvin Zhao[MSFT]: "RE: Exporting data to another server"
- Next in thread: Alvin Zhao[MSFT]: "RE: Exporting data to another server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
