FilipWitkowski
asked on
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
"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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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"
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"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, good question, do you use SQL 2005? If you use SQL 2000, have you installed at least SP 3 for SQL Server?
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:
https://www.experts-exchange.com/help.jsp#hs5
irwinpks
EE Cleanup Volunteer
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:
https://www.experts-exchange.com/help.jsp#hs5
irwinpks
EE Cleanup Volunteer
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
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
ASKER