Manual setup of Database in SQL Server 2005

[Steve Scott]

I am attempting the above process. I need to run the following command in the
command prompt window "SETUPDB.cmd <SQL ServerName> <DatabaseName> <UserName>
<Password> NOPAUSE"

I am a complete novice at using the command prompt utiluty.

My command prompt window is currently displaying "C:\Documents and
Settings\Administrator" My setupdb.cmd file is located in "C:\Documents and
Settings\Administrator\My Documents\DATABASE" but when I type this in it
doesnt work...

can anyone advise me on the full syntax of what I need to enter into the
command prompt window to get this to work?

Thanks in advance

 

[Rick Roszko]

This is the MS Project Server forum. You need to post this your question in
the SQL forum.

Additionally, if you are using MS Project Server, you need to use MS
SQL2000, not 2005.

 

[Gary L. Chefetz [MVP]]

Steve:

It seems as though you have the correct syntax, the question is whether
you're entering the correct values. Without telepathy as a device, it's
difficult to say. You can overcome the SQL 2005 limitation (not supported by
Microsoft for Project Server 2003) by reading the following information:

http://blogs.lv0.net/mpatest/archive/2005/11/18/182.aspx

 

[IISJUNKIE]

I hate when people give the generic look elsewhere and figure it out answer.

SQL2k5 & MSPS2k3 play fine together the SP1/2 update it looks like your
trying to run just needs some clarification.

1) in SQLENT-MGR make sure the account you are using has the proper
permissions, you have to be logged on locally to that server with your CMD
window open.
2) stage the upgrade where you can get to it. This means putting the
SQL-SP1/2 Update once you execute it will extract it somewhere, what ever
files it extracts (copy or move them to the root of [C:\ MSPS-SP1] for
example, then -
3) open your CMD window and type cd.. until your CMD windows shows just a
C:\
then cd = change directory to your folder by typing cd MSPS-SP1 this should
take you to the contents of the folder with the upgrade, and there is where
you run your command you listed. These specific directions are used for
applying SP1&2 & setting up the DB as well.
4) even though people say that this is NOT an SQL forum and questions like
this should be placed there - it will never change the fact that MSPS is a
SQL application with a web front end.. so this is the right place, you just
have to find someone kind enough to get off the high horse and help someone
that is in the exact place we all were at one time or another.

Good Luck