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)
-
Windows 8.1 added with lot of small improvements, this post highlight the Navigation Customization. Right click on Task Bar and bring the P...
-
Engineering Excellence Having solid engineering process and tools in place help to improve the agility of the system. Here is the high-level...
-
Dumeter Netmeter toast.net->Internet Speed Test
No comments:
Post a Comment