EventID 3760 – Cannot open database DBNAME requested by the login in Sharepoint 2013

Solved by granting permissions using powershell

First find out what webapplication the database mentioned in the event belongs to, then grant permissions. In the example below I’m using a test account but in production it were application pool accounts for our portals that lacked the permissions to mysites DB.

PS C:\Windows\system32> $w = Get-SPWebApplication http://portal.test:8088
PS C:\Windows\system32> $w.GrantAccessToProcessIdentity(“TEST\user”)

Event ID: 3760
Task Category: Database
Level: Critical
Keywords:
User: NT AUTHORITY\IUSR
Computer: Sharepoint.test
Description:
SQL Database ‘SP_Cont_MySites’ on SQL Server instance ‘sp_core_db’ not found. Additional error information from SQL Server is included below.

Cannot open database “SP_Cont_MySites” requested by the login. The login failed.
Login failed for user ‘TEST\user’.

Advertisements

Tagged: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

smsagent

Tips, tricks and time-savers for the Windows and ConfigMgr administrator

To The Point

Anything about Technology and Business

Brian's Power Windows Blog

Microsoft in the Enterprise. Windows, Hyper-V, Exchange, SQL, and more!

PowerScripting Podcast

Shownotes and links for the PowerScripting Podcast, a podcast to help people learn Windows Powershell

Learn Powershell | Achieve More

What is this Powershell of which you speak?

%d bloggers like this: