Microsoft SharePoint install permissions

Question

Microsoft SharePoint install permissions

Linda Johanning

SSCertifiable

Points: 6727
More actions
January 9, 2006 at 11:08 am

#103025

We have SharePoint installed that currently uses MSDE but want to install it to use either SQL 2000 or SQL 2005. I want the analyst to install on a SQL 2005 test box but he gets an application error (can't seem to find exact message) but it's probably due to permissions. I created a standard login and granted create database and security admin rights, but don't want to grant sysadmin. I'd rather work out the permission issue before getting stuck with granting sysadmin in production 🙂 I've searched the Knowledge Base and have found nothing regarding SQL Server permisisons for the install. Does anyone know what permissions are needed? Thanks,
Linda

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

Why don't you install it? Normally installing anything requires system admin privileges (not SQL Server sysadmin, but sysadmin on the computer).

It would help greatly if you provided the error message. Check the Windows Event Viewer logs, normally you can find the popup messages in the Application or System logs.

-SQLBill

Linda Johanning SSCertifiable Points: 6727 More actions · Answer 2

I forgot there was one persistent error in the Application Log (below), but it turns out that the person doing the install was typing in the incorrect password.

#50070: Unable to connect to the database on ServerName. Check the database connection information and make sure that the database server is running.

So it appears that "create database" and "security admin" were sufficient for the install. Now I am seeing a different error:

Failed to locate the assembly in the SafeControl assembly paths.

I guess I'll have to do some reading on "assemblies" before I can figure out what's going on. Thanks.

Linda

nunYoBidnez Ten Centuries Points: 1128 More actions · Answer 3

Hi Linda, entering the password correctly helps greatly. Sharepoint must have Security Admin and Database Creator server roles. It is easiest to install with the sysadmin in AD and SQL, then changing the Set SharePoint Administration Group (WSS) or Configure Server Farm Account Settings (SPS).

I haven't read anything about Sharepoint being supported on SQL Server 2005, it does work well on SQL Server 2000 SP4. There are some caveats, too many to go over, but reading the admin install guide does cover a lot of them.

Are you installing WSS or SPS? One Sharepoint server and a backend SQL server or all on one box?

Kindest Regards,

The art of doing mathematics consists in finding that special case which contains all the germs of generality.

Linda Johanning SSCertifiable Points: 6727 More actions · Answer 4

Granting sysadmin rights and then taking it away is what I wanted to avoid. I would venture to guess that "something" would break after removing sysadmin. I personally think it is best to grant needed permissions at the start rather than removing them--especially since there is the possibility of breaking part of the application. I am not installing the application nor will I be the "owner" so I'm sticking with "least privilege".

I am told that SharePoint with sp1 will work with SQL 2005. I guess we'll find out after testing 🙂

Linda

nunYoBidnez Ten Centuries Points: 1128 More actions · Answer 5

Hi Linda, can't say I disagree. I have installed Sharepoint SPS SP1 on SQL Server 2000 SP4 with the two required roles and it worked without any difficulties. I have also installed it with sysadmin, then changed to the required roles without problem. But ours is a large farm with front end web, index, search and clustered SQL servers. A single server install should be straight forward after reading the guides. Which step in the install process results in the "Failed to locate the assembly in the SafeControl assembly paths" error?

If you can find the content for Sharepoint working with SQL 2005, please send me the link. Thanks

Kindest Regards,

The art of doing mathematics consists in finding that special case which contains all the germs of generality.

Linda Johanning SSCertifiable Points: 6727 More actions · Answer 6

Don't forget the SQL 2005 is much more secure. What worked for SQL 2000 (removing sysadmin) may not necessarily work for 2005 🙂

The application install completed and the 2 databases were created. The analyst is now trying to set everything up (not sure what that entails). I'll post the error or problem if he can't solve it himself.... Thanks.

Linda

nunYoBidnez Ten Centuries Points: 1128 More actions · Answer 7

Hi Linda, great news, congrats. Monitor the web.config files, you may need to set the trust level in your server web.config to FULL, and <customErrors mode="Off" /> to see errors generated by Sharepoint and SQL Server. Thz

Kindest Regards,

The art of doing mathematics consists in finding that special case which contains all the germs of generality.