Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

Instalation of Project Server 2003

I'm trying to install Project Server 2003 and it keep stoping with this error:
"Error 25624. Failed to execute SQL String. (-2147217900 CREATE TABLE dbo.MSP_ASSN_ENTERPRISE
(
RESERVED_DATA char(1) NULL,
PROJ_ID int NULL,
ASSN_ENTSUMPROJID int NULL,
ASSN_ACT_FINISH datetime,
ASSN_ACT_START datetime NULL,
ASSN_ACWP decimal(25,6) NULL,
ASSN_BCWP decimal(25,6) NULL,...
"
After this it's rolling back

Please help
0
FilipWitkowski
Asked:
FilipWitkowski
  • 2
  • 2
  • 2
  • +1
2 Solutions
 
FilipWitkowskiAuthor Commented:
One more thing. After rolling back I've got created ProjectServer database and I (user logged in - Administrator) is owner of this database with all rights.
0
 
BembiCEOCommented:
Project Server need access to the SQL Server. During setup, you are asked, which account to use to connect to SQL Server. This account must have at least the roles "security administrator" and "database creator" roles.

So setup a logon account or add a windowsdomain account (or use an existant SQL server account), and make sure, this account has the rights above (properties of the account). Then restart the setup and select this account for accessing the SQL server.

If there is no data in the project database, have a look in MS SQL Enerprise Manager, if the Database "ProjectServer" exists and delete it, before you try to reinstall.
0
 
FilipWitkowskiAuthor Commented:
OK I'm using an account domainname\Administrator, which is the administrator of the server. This windows-account is also added to SQL logins and I gave to him all possible roles, And still the same. I found this:
http://support.microsoft.com/?kbid=917401

When I'm running setupdb.cmd I get error:
"msg 2782 level 16 state 1, server servername line 3 DDl statement is not allowed. Error envountered while running Projtbls.sql"
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
harisrashidCommented:
hi,

In SQL Server, you probably do not have the user properties set. Make sure the MSProjectServerUser and MSProjectUser are set with a Default Database of the ProjectServer database you created. You also need to assign them to the Role of MSProjectServerUser and MSProjectUser.

Also refer to the link: http://blogs.lv0.net/mpatest/archive/2005/11/18/182.aspx

Regards,
Haris
0
 
BembiCEOCommented:
Yes, good question, do you use SQL 2005? If you use SQL 2000, have you installed at least SP 3 for SQL Server?
0
 
Irwin SantosComputer Integration SpecialistCommented:
This question has been classified as abandoned because there are no comments in the last 21 days. I will make a recommendation to the moderators on its resolution in approximately 4 days.  I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final disposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help.jsp#hs5

irwinpks
EE Cleanup Volunteer
0
 
Irwin SantosComputer Integration SpecialistCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:

Split - Bembi, harisrashid

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

irwinpks
EE Cleanup Volunteer
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now