SmashedHammer
asked on
Unattended MPS Join Server Farm
Hello,
I am having problems with an unattended install of MPS 4.0 to join an existing farm.
Essentially, I am modifying the mps.msi file using Orca. The install appears to run swimmingly until it tries to make an ODBC connection. At this point the install fails and rolls back.
When looking at the event log I see the following
--------------------------
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 12/8/2006
Time: 8:50:37 AM
User: <some hidden account name>
Computer: IMG-DCO-XXXX
Description:
Product: Citrix MetaFrame Presentation Server for Windows -- Error 26009. Could not Access the datastore using the DSN file, Username and password given function UseFileDSN returned failure in CTX_MF_IMA_Silent_ODBC
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 38 37 36 35 38 30 45 {876580E
0008: 33 2d 32 45 35 32 2d 34 3-2E52-4
0010: 46 34 38 2d 41 37 42 38 F48-A7B8
0018: 2d 32 39 38 42 39 44 37 -298B9D7
0020: 39 35 39 37 30 7d 95970}
--------------------------
Now, I am able to manually install MPS successfully and make a connection to the MS SQL 2000 server using identical credentials. The DSN file I am using is the one that was created by the manual install.
Our farm will be quite large and spinning disk is not an option. If you require more information please let me know. Any help guidance or ideas would be greatly appreciated.
Regards,
SH
I am having problems with an unattended install of MPS 4.0 to join an existing farm.
Essentially, I am modifying the mps.msi file using Orca. The install appears to run swimmingly until it tries to make an ODBC connection. At this point the install fails and rolls back.
When looking at the event log I see the following
--------------------------
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 12/8/2006
Time: 8:50:37 AM
User: <some hidden account name>
Computer: IMG-DCO-XXXX
Description:
Product: Citrix MetaFrame Presentation Server for Windows -- Error 26009. Could not Access the datastore using the DSN file, Username and password given function UseFileDSN returned failure in CTX_MF_IMA_Silent_ODBC
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 38 37 36 35 38 30 45 {876580E
0008: 33 2d 32 45 35 32 2d 34 3-2E52-4
0010: 46 34 38 2d 41 37 42 38 F48-A7B8
0018: 2d 32 39 38 42 39 44 37 -298B9D7
0020: 39 35 39 37 30 7d 95970}
--------------------------
Now, I am able to manually install MPS successfully and make a connection to the MS SQL 2000 server using identical credentials. The DSN file I am using is the one that was created by the manual install.
Our farm will be quite large and spinning disk is not an option. If you require more information please let me know. Any help guidance or ideas would be greatly appreciated.
Regards,
SH
ASKER
I have the username. In any reference .dsn I have found the password is not designated. If a password is requied, what is the designation for it (pwd=?) and I will give it a try
My DSN:
[ODBC]
DRIVER=SQL Server
UID=forces\s-cfs-XXXXXX
Trusted_Connection=Yes
Network=DBMSSOCN
DATABASE=CITRIXIMA
WSID=IMG-DCO-XXXXXXX
APP=Citrix IMA
SERVER=IMG-DCO-XXXXXX
Description=Citrix IMA
My DSN:
[ODBC]
DRIVER=SQL Server
UID=forces\s-cfs-XXXXXX
Trusted_Connection=Yes
Network=DBMSSOCN
DATABASE=CITRIXIMA
WSID=IMG-DCO-XXXXXXX
APP=Citrix IMA
SERVER=IMG-DCO-XXXXXX
Description=Citrix IMA
PWD should do it. Also, have you checked out the unattended.txt file (support\install of the PS4 Server CD), or have you tried msiexec.exe /i mps.msi <then all of the commands after this>
ASKER
I started out with using msiexec.exe /i mps.msi <then all of the commands after this> but I error out because the command is greater than 1023 characters.
I do not know how to use the unattended.txt. I will try pwd in the DSN now I will let you know
I do not know how to use the unattended.txt. I will try pwd in the DSN now I will let you know
ASKER
Still failed with the PWD in the DSN
Maybe UID="forces\s-cfs-XXXXXX" might be the problem... The \ might be causing the issues.
I meant, because of the \, I think it's necessary to put the quotes around the whole user ID.
ASKER
That was no good either. Is there any other information I can offer up to help this along?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Chris,
No problems!
Funny thing, that is the site that I started/based my install on.
We think that we have narrowed the problem to SQL server rights since we can mamually intall the server no problem.
I will keep you in the loop.
Thanks for sticking it out here!!!!
SH
No problems!
Funny thing, that is the site that I started/based my install on.
We think that we have narrowed the problem to SQL server rights since we can mamually intall the server no problem.
I will keep you in the loop.
Thanks for sticking it out here!!!!
SH
ASKER
Success!!!
I re-read the articles you posted above and found a couple of errors in my ways. I also believe that we had bad SQL Server permissions. In any event, I now have a way to automate the installation of my MPS farm.
Thanks for your help
I re-read the articles you posted above and found a couple of errors in my ways. I also believe that we had bad SQL Server permissions. In any event, I now have a way to automate the installation of my MPS farm.
Thanks for your help
Congrats! Glad you're able to cut down your install time :-)
Try specifying another port the SQL server connection. A "known error" is that SQL sometimes uses port 12001 and not 1433 as one would normally use.
Here is a dsn file you can try:
[ODBC]
DRIVER=SQL Server
UID=sql-user-name
Trusted_connection=No
Network=DBMSSOCN
DATABASE=CitrixDatastore
WSID=Terminal-Server-Name
APP=CitrixIMA
SERVER=SQL-Server-Name>,12
Description=XenApp 5 Datastore
Regards,
Tord Bergset
Thinmaster.com
Here is a dsn file you can try:
[ODBC]
DRIVER=SQL Server
UID=sql-user-name
Trusted_connection=No
Network=DBMSSOCN
DATABASE=CitrixDatastore
WSID=Terminal-Server-Name
APP=CitrixIMA
SERVER=SQL-Server-Name>,12
Description=XenApp 5 Datastore
Regards,
Tord Bergset
Thinmaster.com
Do you have the DB username/password in the DSN file? Have you manually created and tested a DSN file to make sure you're able to authenticate?
Chris