Creating the Project Server Database Manually before Installation

[Hardip]

Hi All

I realised that the Project Server 2003 database cannot be generated
automatically when installing Project Server 2003 on SQL 2005. I located the
following article:

http://office.microsoft.com/en-gb/help/HA011654021033.aspx

I've worked by way through points 1 - 6. However, I have the following
questions relating to Points 6 and 7.

1. I cannot locate the Query Analyzer, however I can see the PSRoles.sql
script in the Support/Database folder I copied over. How would I run this
script in SQL 2005 against my "ProjectServer" database?

2.Is "SQL Server Enterprise Manager" the same as SQL Server Management
Studio"? At the moment I don't login into SQL 2005. However, I think I
might be getting a little confused here as this points relates to logging
into the database or am I completely wrong?.

By the by, I've already changed the setting from "Windows Authentication
Mode" to "SQL Server and Windows Authentication mode" as this also errored
during setup - ho-hum.

Any clarifications or pointers would be welcome and much appreciated.
Thanks in advance to all who take time to help me.

Hardip

Ps: Its been a few years since I did this kind of stuff... I'm enjoying it
(sad but true)

 

[Hardip]

For Point 6 do I:

1. Right Click on the database ("ProjectServer)
2. Navigate to "Script Database as" > "CREATE to" > File > and then locate
the PSRoles.sql, then execute it?

Or am I really exploring the wrong options?

Hardip

 

[Ben Howard]

Hardip,

I blogged this a while back (actually it was part of a migration from MSDE
to SQL2005 for Project Server 2003) but it should help you in the 1st
instance.

http://appleparkltd.spaces.live.com...ogview&_c=BlogPart&partqs=amonth=6&ayear=2007


--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[Hardip]

Hi Ben

Thanks for the response. I managed to find the various setting by playing
around a little. I have another problem now its all setup. I'll post
another topic :-/

Thanks again,
Hardip