When the defauld DB of the user is deleted. We could not able to login to DB.
Error Message:
Cannot open user default database. Login failed.
Login failed for user 'xyz'. (Microsoft SQL Server, Error: 4064)
Solution:
Change the default DB.
USE [master]
GO
ALTER LOGIN [FAREAST\v-prcher]
WITH DEFAULT_DATABASE=[AnyOtherExistingDBName],
DEFAULT_LANGUAGE=[us_english]
GO
Subscribe to:
Post Comments (Atom)
Teams PowerShell
The PowerShell helps to get quick meta data around Teams. Install-Module -Name MicrosoftTeams Connect-MicrosoftTeams Get-TeamAllChannel...
-
I was trying to install SharePoint 2013, the setup was complaining about a pending system restart. Even after multiple restart / Shutdown. ...
-
Recently a new learner of C# asked me a question on C# Virtual & Abstract properties. It turned out to a deep dive. Detail follows. D...
-
source 1. Microsoft .NET Framework interview questions .NET 2. What is .NET Framework? 3. Is .NET a runtime service or a developm...
No comments:
Post a Comment