Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

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

  Asked By: Helen    Date: Oct 16    Category: MOSS    Views: 5559

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.

Share: 

 

11 Answers Found

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

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

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

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

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

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

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

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

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

Yes, I get an access denied error.

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

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

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

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

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

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.

 




Tagged: