RE: Project Server 2003



Robert,

Thanks for replying to my post so quickly. I followed the instrucions but
when I got to the run script step, I ran the script from the copied database
folder and it command window showed up very briefly and then closed. Is that
what was supposed to happen? I was also wondering about the create database
manually step. Isnt that what I did in the first step? And are there any
particular settings I should specify when running the project installation.
Thanks for all your help.

Jeffrey Hurst

"Robert Li [MSFT]" wrote:

Hi Jeff,

Thanks for posting in our newsgroup.

From your description, I know that you need some guide on Installation of
project server with SQL 2005 on SBS. If that's not right, please don't
hesitate to let me know.

Please take the following steps:

1. Create the database.

a. Start SQL Server Management Studio.
b. In the Connect to Server dialog box, click Database Engine in the Server
type box, and then click Connect.
c. Right-click Databases, and then click New Database.
d. In the New Database dialog box, type the name of the database in the
Database name box. For example, type Project Server, and then click OK.
e. In the left pane of SQL Server Management Studio, expand Databases,
right-click the database, and then click Properties.
f. Under Select a page, click Options.
g. In the Compatibility level box, click SQL Server 2000 (80), and then
click OK.
h. Exit SQL Server Management Studio.

2. Run the Setupdb.cmd script. The Setupdb.cmd script is located in the
\Support\Database folder of the Project Server 2003 CD. To use the
Setupdb.cmd
script, follow these steps:

a. Copy the Database folder from the Project Server 2003 CD to a location
on the computer that is running SQL Server 2005.
b. Run the script. The Setupdb.cmd script uses the following syntax:
Setupdb.cmd SQLServerName Database Name Username Password NOPAUSE

3- Create the database manually

Also create the msprojectserveruser and msprojectuser - manually > assign
appropriate roles

4- Run the installation of project server

Hope this helps.

If you need further assistance, please don't hesitate to let me know.

Best regards,

Robert Li(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================

This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<Thread-Topic: Project Server 2003
<thread-index: AcfS8wVSHZV1zkRjSAO344Nqm2hALQ==
<X-WBNR-Posting-Host: 207.46.193.207
<From: =?Utf-8?B?SmVmZg==?= <Jeff@xxxxxxxxxxxxxxxxxxxxxxxxx>
<Subject: Project Server 2003
<Date: Mon, 30 Jul 2007 14:46:01 -0700
<Lines: 5
<Message-ID: <C8E7FD16-363A-44E5-AEBF-7B002348F2AA@xxxxxxxxxxxxx>
<MIME-Version: 1.0
<Content-Type: text/plain;
< charset="Utf-8"
<Content-Transfer-Encoding: 7bit
<X-Newsreader: Microsoft CDO for Windows 2000
<Content-Class: urn:content-classes:message
<Importance: normal
<Priority: normal
<X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
<Newsgroups: microsoft.public.windows.server.sbs
<Path: TK2MSFTNGHUB02.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:53423
<NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<I have a fresh installation of SBS2003, i have installed SQL 2005 with all
<default settings and i am also running CRM small business edition. I was
<wondering if there is any type of guide on installing Project Server with
SQL
<2005 installed. I have found some guides but they are all fresh
<installations with SQL 2000.
<


.



Relevant Pages

  • Re: Cannot Open SQL Server Table in Access.ADP File.
    ... Other possiblities would be that you didn't refresh the database window ... I have an SQL Server 2005 database which functions properly with my ... the Generate Script Wizard to recreate the SQL Server Database. ... Then, If I attempt to open another table, it opens. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Security
    ... except I'm having problems making it work in a script. ... ;Set properties of DB objects and open connection to database ... > from Books Online (within the SQL Server program group): ... > communicate with SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Database Access
    ... Do you create the group in SQL Server on the NT Domain? ... >> from a client script to ... > the database server would not be possible from client machines. ... You will want the sqloledb connection string. ...
    (microsoft.public.scripting.jscript)
  • Re: Scripting a SQL database
    ... Virtually everything SQL Server Enterprise Manager does can be ... To run the generated script in ASP, ... You can also create a DTS (Data Transformation Package) ... that you'll want to select the "copy database objects and data" ...
    (microsoft.public.inetserver.asp.db)
  • Re: Scripting a SQL database
    ... Virtually everything SQL Server Enterprise Manager does can be ... To run the generated script in ASP, ... You can also create a DTS (Data Transformation Package) ... that you'll want to select the "copy database objects and data" ...
    (microsoft.public.sqlserver.server)