[THIN] MS SQL datastor move
- From: Jamie Marshall <jamie.marshall@xxxxxxxxxxxxxxxxxxxx>
- To: "'THIN@xxxxxxxxxxxxx'" <THIN@xxxxxxxxxxxxx>
- Date: Mon, 18 Nov 2002 18:31:50 -0000
Wonder if anyone can help!!
I have installed an XP FR2 farm using a temporary SQL 2000 SP2 datastore
server (standard build and sort order). I now have to move this to an SQL
2000 SP2 cluster. I have exported the datastore and reimported it into the
new server, setup an SQL user with the same username and password and
assigned it as the DBOwner (same as the old SQL server). However, when I
change the mf20.dsn to point to the new server (SQL cluster name) it does
not work. I have tried using dsmain migrate, still to no avail.
Has anyone experienced problems with SQL clusters?
Any suggestions?
many thanks
Jamie
Jamie Marshall
Solutions Architect
Dataplex Systems Ltd.
t 0161 7867004
f 0161 7073344
e mailto:jamie.marshall@xxxxxxxxxxxxxxxxxxxx
w http://www.dataplex-systems.com
**************************************************************************************
THIS EMAIL AND ANY ATTACHED FILES IS/ARE CONFIDENTIAL
AND LEGALLY PRIVILEGED. If you are not the addressee, any
disclosure, reproduction, copying, distribution, or other dissemination
or use of this communication is strictly prohibited. If you have received
this transmission in error please notify Dataplex Systems Limited on
+44 (0) 161 707 3355 immediately and then delete this email.
Email transmission cannot be guaranteed to be secure or error free as
information could arrive late or incomplete, or contain viruses. Dataplex
Systems Limited therefore does not accept liability for any errors or
omissions in the contents of this message which arise as a result of
email transmission. If verification is required please request a hard copy
version signed by or on behalf of Dataplex Systems Limited.
Copyright in this email and any documents created by Dataplex Systems
Limited will be and remain vested in Dataplex Systems Limited, we assert
the right to be identified as the author of and to object to the misuse of
this email and such documents.
**************************************************************************************
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
***********************************************
This Weeks Sponsor: Wyse Technologies
Get a free whitepaper on how to secure
your corporate data from Wyse. Click Below.
http://thethin.net/wyse.cfm
***********************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
Other related posts:
