Let "the specified msprojectserverrole account does not belong to the msprojectserverrole role" go to death

When I was writing this blog, the project server of the Project Server was installedProgramIs in the cheerful state of copying files. I want to cool down the cup of coffee in front of me to this point!

In fact, nancrazy should refer to this topic as "installing projectserver2003 on sql2005 database" or "installing projectserver2003 on sql2005 database" and so on. However, if you have experienced numerous installation failures, you may think of a question that is even more difficult than nancrazy.

First, let's talk about the software environment:

1. Chinese version Windows Server 2003 r2
2. English version sql2005 en
3. Chinese SharePoint Services 2.0 with Service Pack 2
4. Chinese version projectserver2003

According to the installation instructions of projectserver2003, nancrazy configures a variety of users and then installs the Chinese version of SharePoint (it's a pain to remove nancrazy's English version of SharePoint, that's the orcas TFs beta1 environment. After several (more than 3) hardships, I finally installed the SharePoint Chinese version. Then the Windows SharePoint Services Configuration Wizard is run, and after two failures, finally, we got two valuable urls: "SharePoint Management Center URL" and "Create a top-level website under this URL.

At this time, the South crazy is full of confidence, but did not expect that the South crazy patience has been exhausted by the previous steps and multiple fault!

Next, install projectserver2003.

The steps are as follows (the following section is in the copy installation guide. You can skip the Section 20 to view the following content. I also want to learn from Microsoft ):

2. On the computer on which you want to install Project Server 2003, insert the Project Server 2003 CD into the CD-ROM drive, or connect to a network installation location.
4. If "automatic playback" is enabled for installation from Project Server 2003 CD, click "Server Installation" in "Project Server 2003 installer ", alternatively, find and run the setup.exe file on the Project Server 2003 CD-ROM (or network installation location.
6. On the "user information" page of "Installer", enter the user name, abbreviation, organization, and product key, and then click "Next ".
8. Read and accept the license agreement, and then click "Next ".
10. In the "installation location" box, specify the installation location of Project Server 2003, and then click "Next ". The default location is c: \ Program Files \ Microsoft Project Server 2003.
12. On the "select a service to be installed on this server" Page:
    (A) Click the "Microsoft Office Project Server Sample Data" list and then click "run from local computer ".
    (B) Click "Next ".
    NoteThe sample database must be further configured after Project Server 2003 is installed. For more information, see the sampledb.htm file in the support \ sample \ 2003 folder of the Project Server 2052 CD.
14. On the "Enter Database Server Information" Page:
    (A) Select the "create database" option to create a new database for Project Server 2003 data.
    (B) In the "Database Server" box, type the name of the SQL Server 2003 instance to be used with Project Server 2000.
    (C) Select "SQL Server Authentication.
    (D) type the login name and password of the SQL Server account to create the Project Server 2003 database table (account 2 in the user account list ).
    (E) Click "Next ".
16. On the "Enter connection information for the 'view' table" Page, accept the default settings and click "Next ". This will install Project Server 2003 "view chart" in the Project Server 2003 master database ".
18. On the "Create Database account information" Page, type the password used when Project Server 2003 and Microsoft Office Project professional 2003 access the SQL Server 2000 database, and then click "Next ". The entered password will be assigned to the account listed in the "Login Name" box.
20. On the "Enter Analysis Services connection information" Page:
    (A) In the "Analysis Server" box, type the name of the analysis services server to be used with Project Server 2003.
    (B) In the "Login Name" box, type the name of the Windows domain account used by Project Server 2003 to access the analysis services server (account 1 in the user account list ).
    (C) In the "password" box, type the password for the Windows domain account, and then click "Next ".
    NoteIf you select to enter the Analysis Services connection information, you must run the pscomplus.exe utility to set the user account and password information.
22. On the "select Website" page, click "default website", and then click "Next ".
24. On the "Enter web server address information" Page:
    (A) Under "intranet protocol and server name for accessing Microsoft Office Project Server", select the Intranet protocol (http: // or https: //), and then type the server name in the next box.
    Note when you type a server name, you do not need to include the Protocol (http: // or https ://).
    (B) You can also select the exclusive protocol (http: // or https: //) from the list under "exclusive protocol and domain name used to access Microsoft Office Project Server ://), enter the domain name in the next box.
    NoteWhen you type a domain name, you do not need to include the Protocol (http: // or https ://).
    (C) Click "Next ".
26. On the "Enter SMTP Mail Server Information" Page:
    (A) In the "SMTP mail server" box, type the name of the SMTP mail server for Project Server 2003 notifications and reminders. To send notifications and reminders to Project Server 2003, type smarthost.
    (B) In the port box, type the port number of the email server. The default port is 25.
    (C) In the "sender address" box, type an email address to include this address in the "sender" Field of the email sent by Project Server 2003, and then click "Next ".
28. On the "connect to the Web server running Windows SharePoint Services" Page:
    (A) Under "Windows SharePoint Services Management URL", select the Protocol (http: // or https: //) used on the Sharepoint Server ://), enter the server name and port number in the next box. This is the "SharePoint Management Center URL" link provided by the "Windows SharePoint Services Configuration Wizard.
    Note when you type a server name, you do not need to include the Protocol (http: // or https ://).
    (B) Under "create a website under this Windows SharePoint Services URL", select the Protocol (http: // or https: //) used on the Sharepoint Server ://), enter the URL of the Project Server 2003 website. This is the "Create a top-level website under this URL" link provided by the "Windows SharePoint Services Configuration Wizard.
    NoteWhen you type a server name, you do not need to include the Protocol (http: // or https ://).
    (C) Click "Next ".
    NoteIf you select to enter the Windows SharePoint Services connection information, you need to run the pscomplus.exe utility to set the user account and password information.
30. On the "enter account information for Windows SharePoint Services (CONTINUE)" Page, type the Windows account name and password used to manage Windows SharePoint Services (account 1 in the user account list ), click "Next ".
32. On the "connect to the Web server running Microsoft SharePoint Portal Server" page, you can select the SharePoint Portal Server connection information of the input unit or select the "enter this information later" option, click "Next ".
34. On the "Select installation environment" Page, select the option for deployment, and then click "Next ".
36. On the "Enter administrator password" Page, type the password used for the Administrator account, and then click "Next ".
    Note: make sure that this password is provided for future reference. This Administrator account is required when you log on to Microsoft Office Project Web Access 2003 for the first time.
38. On the summary page, click Install ".
    Install the Project Server 2003.
40. On the "installation completed" page, click "finish ".

 

Look at the official website, please do not make your "Sh-" sound by the complicated steps above. If Nan Crazy tells you, if you add the preceding steps to configure and install SharePoint and run the Windows SharePoint Services Configuration Wizard, the above steps should at leastMultiply by fiveLeft and right. You should just breathe out, not just breathe out.

If you follow the steps above to install projectserver2003, which of the following errors occurs in the sql2005 database?First error in step 19th and then step 9th!

Follow the steps above to install projectserver2003. All the preceding operations are normal. In Step 19th, you will get a 25624 error. It generally means that a script error occurs when the installer creates a DBO. msp_web_sp_qry_gettasksids stored procedure.

This is because this script is not compatible with sql2005. Then the installation is rolled back. You have to repeat the above annoying steps for the next installation. go crazy!

Microsoft has a solution for this:

1.	Run SQL Server 2005 to manually create a database before installing Project Server 2003 on your computer.
2.	Set the database Compatibility Level to SQL Server 2000 (80.
3.	Run the installer to install the Project Server 2003.
4.	Connect to the database by using the installation program on the enter Database Server Information page to connect to other existing database options.

Project Server 2003 runs SQL Server 2005 to create and configure databases. To do this, follow these steps:

1. Create a database. A. Start sqlservermanagementstudio. B. In the connect to server dialog box, click in the server type box, database engine, and then click Connect. C. Right-click the database and click Create Database. D. In the new database dialog box, type the database name in the Database File Name box. For example, type projectserver and click OK. E. In SQL Server Management studio in the left pane, expand the database, right-click the database, and click. F. On the Select page, click options. G. In the compatibility level box, click SQL Server 2000 (80), and then click OK. H. Exit sqlservermanagementstudio.

2. Run the setupdb. CMD script. The setupdb. CMD script is located in the Project Server 2003 CD \ support \ database folder. To use the setupdb. CMD script, follow these steps: A. copy the database folder from the Project Server 2003 CD to the running SQL Server 2005 computer. B. run the script. The setupdb. CMD script uses the following syntax: setupdb. CMD sqlservername databasename username and password nopause highlights: 2. in step B, the numbers on the screen were full of flowers, such as numbers 1, 2, 1, 2, and 1. One of my friends came and asked: what is this? answer: This is the highest level of programming. Use the binary Code to write a database!

After the database is created, run the projectserver2003 installation program again. In Step 7th, Nan crazy carefully selected the "connect to other existing databases" option, entered the information, and went to the next step, next, go to step 9th. At this time, nancrazy noticed that there are already two users in my database: "msprojectserveruser" and "msprojectuser ". Therefore, nancrazy did not hesitate to fill in the two users and their passwords. However, when Nan crazy clicked "Next", the following hateful stuff came out:

The specified msprojectserverrole account does not belong to the msprojectserverrole role.

Dizzy! How is the difference between products and products so big? I am crazy!

Check whether the two users belong to the correct msprojectserveruserrole role and msprojectuserrole. No, add, retry, and fail!

An old brain adds all server roles to msprojectserveruser and msprojectuser. Retry and fail!

An old brain adds a database role to msprojectserveruser and msprojectuser in user mapping. Retry and fail!

I said on the Internet that sql2005 lost the passwords of these two users, set them again, and try again!

It is said on the Internet that the default databases of both users must be set to the projectserver database. Good, set, retry, and fail!

The "domain \ User Name" method is used to enter the user. Retry and fail!

What codepage should I change from the Registry on the Internet? modify the code according to his instructions. Retry and fail!

On the Internet, it is said to re-run setupdb. CMD to re-establish the database. OK, re-run setupdb. cmd, retry, and fail!

......, Retry, failed!

......, Retry, failed!

......, Retry, failed!

 

This problem has been annoying for a long time, And suddenly reminds me: in fact, this error may not be caused by the reason of the permission. Is it possible to catch the error in the Microsoft installation program, if the error is reported to throw by November 21? I think that when I installed businessobjects myself recently, I was unable to connect to the server when I was creating a database and then re-established the user. The procedure is as follows:

1. In the sql2005 database, delete "msprojectserveruser" and "msprojectuser" under the security \ logins directory.
2. Delete "msprojectserveruser" and "msprojectuser" in the projectserver database (this step is very important. sql2005 does not automatically delete users bound to the database ).
3. Recreate the msprojectserveruser user, set its default database to projectserver, and grant the msprojectserveruserrole database role permission to the user mapping.
4. Recreate the msprojectuser user, set its default database to projectserver, and grant the msprojectuserrole database role permission to the user mapping.
5. Run the projectserver2003 installation program again. In Step 7th, select "connect to another existing database", enter the database server and other information, and click Next.
6. Next, go to step 2 and enter "msprojectserveruser" and its password in the user who accesses the database in Microsoft Office Project Server 9th; in Microsoft Office Project professional 2003, enter "msprojectuser" and its password. Click Next.
7. OK, pass!

......

When nancrazy finishes writing this blog, nancrazy projectserver2003 has been correctly installed!