April 21, 2003 at 2:34 pm
Hi, I'm creating a new test sever for Sql server, Analysis Services, and Project Server. The SS and AS install went fine. Now I am trying to install project Server, and I can't get past this one error. I get the same permissions error wheather I'm creating a new database, or connecting to an existing one. I know my Sql Server logins have full privs. I've even created new logins and given them full privs. I still continue to get" "You do not have SECURITYADMIN and DBCREATOR Privileges on the SQL Server". Arrrggghh! This is my first install of Project Server, so I may be missing something basic, but I have gone at this install from a whole bunch of directions, and I can't get passed this hump. Please help!
Thanks,
Jerry
April 21, 2003 at 5:04 pm
What do you mean "full privilges" here? 'SA' or 'DBO'?
April 21, 2003 at 5:13 pm
I'm giving the Logon Id 'DBO' and still no luck. Do you happen to know of a similar Forum on the web dedicated to Project Server?
April 22, 2003 at 7:50 am
Ther are two type security roles in SQL Server, one is at server level and another is at database level. User with 'DBO' role has all permissions in the database including 'db_securityadmin' role. You may try to grant 'securityadmin' server role to that login and see whether your application works.
Microsoft NewsGroup may be another place you should ask.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply