Database Server Permissions

J

jane

I have been attempting to install Windows SharePoint
Services on the Project Server 2003 server. The SQL
database is/will be on a different server. What
permissions/rights does the userid need in order to
use/create the database on the SQl server. I found in
the "Prepare the Servers" documentation where it says "The
account must belong to the Database Creators and Security
Administrators roles." The SQL Server group assures me
that the permissions are set correctly, but it always
fails with the error "Login failed for user 'xxx-xxxxx'.
(Error code 18456)". Which leads to another question. The
SQL Server group wants to create the database and then
have me use that database when I do the install. Any
input to these questions/problems will be greatly
appreciated. Thanks,
 
J

Jack Kohn

Jane -

When I installed the Windows SharePoint Services (WSS) database, I
used the SQL "sa" ID as suggested in the docs. I had to call DBAs over
a few times to type in the password, but that was OK with them and me.
I vaguely recall trying to use a domain ID that "should have" worked,
but it didn't. "sa" worked.

My DBA group also wanted to install the Project database ahead of time
rather than letting the Project install program do it. The DBAs named
the database according to corporate standards and that worked fine. I
had no problems during installation.

However, there is a script to create the Project database. I don't
recall any script to build the WSS database. With the DBAs permission,
I let the WSS install build the WSSConfig database. The DBAs were less
than thrilled with some of what they saw. (The collation setting for
the WSSConfig DB doesn't match the non-default setting that the rest
of our databases use.)

I also vageuly recall during an early test trying to name the WSS
database something other than WSSConfig and having a problem later
down the road. This could just be my foggy memory, though.

Good luck.

-jmk
 
Top