Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

Can anyone tell me what permissions sharepoint 2010 needs to the mass

Asked By: Helen Ramsey Date: Oct 16, 2009 Category: MOSS Views: 1150

I am attempting to upgrade a MOSS 2010 database to a SP2010 database
using the PowerShell Mount-SPContentDatabase command. When I attempt to
do so, I get the following error: : Could not connect to server using
integrated security : Cannot connect to database master at SQL server at
server. The database might not exist, or the current user does not have
permission to connect to it.

The error in context is :

Mount-SPContentDatabase "wss_Content_dbname" -DatabaseServ

er "servername" -WebApplication http://sitename

Mount-SPContentDatabase : Could not connect to server using integrated
security

: Cannot connect to database master at SQL server at server. The
database might

not exist, or the current user does not have permission to connect to
it.

At line:1 char:24

+ Mount-SPContentDatabase <<<< "wss_Content_dbname" -DatabaseServer
"servername" -We

bApplication http://sitename

+ CategoryInfo : InvalidData:
(Microsoft.Share...ContentDatabase:

SPCmdletMountContentDatabase) [Mount-SPContentDatabase], SPException

+ FullyQualifiedErrorId :
Microsoft.SharePoint.PowerShell.SPCmdletMountCon

tentDatabase

Any help is greatly appreciated.

Tagged:can anyone tell me what permissions sharepoint 2010 needs to the mass

11 Answers Found

Answer #1 Answered By: Dominic Davis Answered On: Oct 16, 2009

Do you mean 2007 to 2010???????????????????

Answer #2 Answered By: Indu Raj Answered On: Oct 16, 2009

yes...........................................

Answer #3 Answered By: Khushi Srivastava Answered On: Oct 16, 2009

For mounting a specific database I think the AppPoolIdentity needs to have
dbo access to the database being mounted.

Answer #4 Answered By: Arti Patel Answered On: Oct 16, 2009

The AppPoolIdentity has permissions to the database . Any
other suggestions?

Answer #5 Answered By: Claire May Answered On: Oct 16, 2009

this is the reference i used when upgrading
sharepointgeorge.com/.../upgrading-content-database-sharepoint-2010-data\
base-attach-method/

have you tried

stsadm -o addcontentdb -url http://intranet.georgekhalil.com -databasename
WSS_Content_Intranet -username domain\username -password password

Answer #6 Answered By: Dan Dickerson Answered On: Oct 16, 2009

Yes, I get an access denied error.

Answer #7 Answered By: Phenil Poriya Answered On: Oct 16, 2009

OK, I was finally able to mount the web app and attach the database
using this command:

Mount-SPContentDatabase -Name (name of database) -WebApplication
http://(web <http://(web> app)

Now when I try to bring up the web site, it is prompting me for a user
name and password. When I enter on, it just keeps prompting.

Any suggestions?

Answer #8 Answered By: Dante Parsons Answered On: Oct 16, 2009

Did you check in Central Admin that you are the site collection
administrator for the site? Have you tried adding yourself to a Web
Application Security Policy with Full Control?

Answer #9 Answered By: Luke Davis Answered On: Oct 16, 2009

Yes I am a site collection administrator. I am not sure what you mean by
adding myself to a Web Application Security Policy. Can you explain
further?

Answer #10 Answered By: Daniella Landry Answered On: Oct 16, 2009

In Central admin there is a spot where you can set a permission Policy that
overrides any local settings for a user or group for the entire web
application. When doing FBA authentication its one of the ways to give or
restrict users from doing something.

Answer #11 Answered By: Bo Stafford Answered On: Oct 16, 2009

Not trying to afraid you but I met the similar fate and end up doing a clean
install of sharepoint with reimporting content database. Every thing worked well
after that.

I spend around 3-4 hours investigating the login prompt but finally decided to
do a fresh install. Please let us know if you find some workaround.

Didn't find what you were looking for? Find more on Can anyone tell me what permissions sharepoint 2010 needs to the mass Or get search suggestion and latest updates.