[THIN] Re: MS SQL datastor move
- From: "Mack, Rick" <RMack@xxxxxxxxxxxxxx>
- To: "'thin@xxxxxxxxxxxxx'" <thin@xxxxxxxxxxxxx>
- Date: Tue, 19 Nov 2002 07:18:56 +1100
Hi,
If you do your DSN mods via the odbc admin utility then you can check
connectivity before redirecting your IMA store. Also make sure that both SQL
servers are using the same locale (collation) otherwise you can have
problems on non-US sites.
regards,
Rick
Ulrich Mack
rmack@xxxxxxxxxxxxxx <mailto:rmack@xxxxxxxxxxxxxx>
Volante Systems
18 Heussler Terrace
Milton 4064, Queensland
Australia
tel +61 7 32467777
-----Original Message-----
From: Jamie Marshall [mailto:jamie.marshall@xxxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, November 19, 2002 4:32
To: 'THIN@xxxxxxxxxxxxx'
Subject: [THIN] MS SQL datastor move
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
--------------------------------------------------------------------------------------------------------------------
The information contained in this e-mail is confidential and may be subject
to legal professional privilege. It is intended solely for the addressee.
If you receive this e-mail by mistake please promptly inform us by reply
e-mail and then delete the e-mail and destroy any printed copy. You must
not disclose or use in any way the information in the e-mail. There is no
warranty that this email or any attachment or message is error or virus free.
It may be a private
communication, and if so, does not represent the views of Volante group Limited.
***********************************************
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:
