MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Using PSconfig to Deploy using DBA-created databases MOSS 2007 error

  Asked By: Gaurang    Date: Sep 09    Category: MOSS    Views: 1876

I'm attempting my first (clean) MOSS 2007 install on a VMWare test
box using the instructions at: http://tinyurl.com/2kw6rb
as our DBA wanted to be able to create and name the databases, rather
than letting setup do it.

Our DBA has set up the databases under Step 1, I ran Setup under step
2 and I am running the first psconfig script under step 3 to
configure the configuration databaseas:

Psconfig –cmd configdb –create –server ourDBServer\Instance –database
Our_Moss_ConfigDB –user domain\user –password xxxxxxx –
admincontentdatabase Our_Moss_CentralAdminDB

The script processes a minute or so, then returns:
The -cmd command is invalid.

I have the PSCDiagnostics log file, which is 1878 lines long, so some
work was done but I am stuck as to where to start troubleshooting.
Any idea on how to find out what/where this failure occured?



4 Answers Found

Answer #1    Answered By: Lynn Mann     Answered On: Sep 09

I had the same issues troubleshooting psconfig. You could try the

- Before you re-try, check to be sure that Our_Moss_ConfigDB is empty.
If there are any user-created objects in there, it will fail. You'll
have to delete them all (including stored procedures, functions, view,
and tables) or just drop and re-create the database.

- Be sure that the db is set up correctly, including collation and
owner. I trust that you're DBA is using http://tinyurl.com/ysyshn as a
reference? The url you posted is different. The collation must be
Latin1_General_CI_AS_KS_WS, which is not the default! It's not even
mentioned specifically in that MS url. The db owner must be the setup
account, and you must run the command under the setup account.

- enclose your password in double quotes.

Answer #2    Answered By: Damini Dande     Answered On: Sep 09

In writing an email to our DBA to ask for help
in review the DB setup, it dawned on me I was logged in as
myself during the install (and running PSCONFIG scripts) and
not as our install account -- I have added that to my notes as a

Now, can I do an uninstall, without issue so I can start over logged
in as the correct install account? I ask only because I am not sure
I have a snapshot of the VMware before the install.

Answer #3    Answered By: Irving Hurley     Answered On: Sep 09

My best guesses would be:

1) If you're a member of the local administrator's group on the machine,
you should be ok with your current installation as far as the binaries
installation goes. I understand that the uninstall leaves registry
entries in place anyway.

2) Can you confirm that the config database does not exist or is empty?
If it's there and contains objects, I would suggest that you ask your
dba to drop and re-create the database. You should then be able to
safely re-run psconfig  under the setup account.

If you want to be certain, I'd try and get a more authoritative response
or rebuild the server.

Answer #4    Answered By: Lalit Bhattacharya     Answered On: Sep 09

I went ahead and did an uninstall / reinstall under the correct
credentials. I am still getting a PSConfig error, but the log is
Our DBA is on vacation, and I'll be leaving for TechEd before he gets
back. So I will ask the MS experts while I am there and try again
when I get back to work.