Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Login Failed For User - Microsoft SQL Server, Error: 4064

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 05-04-2010
Member
 
Join Date: Jan 2010
Posts: 44
Login Failed For User - Microsoft SQL Server, Error: 4064
  

Hello, I am having installed the SQL Server instance for WSS 3.0, SQL Server 9.0.4035. If I try to click on the properties of a database, users, tables, or any object within the SQL Server Management Studio then I get the error message as the below, MICROSOFT##SSEE. When I click on properties of a database, users, tables, or any object within SQL Server Management Studio, I get this error:
Quote:
Cannot show requested dialog.
Cannot open user default database. Login failed.
Login failed for user 'PBTF\user. (Microsoft SQL Server, Error: 4064)
If you are having any solution for this, then please help me to solve this problem.

Reply With Quote
  #2  
Old 05-04-2010
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: Login Failed For User - Microsoft SQL Server, Error: 4064

Hey, I would suggest you to simply make use of the new Microsoft SQL Server installation and then you will able to get the solution for your problem. It is just needed to make use of the new installation which will simply ask you for the new login details and then simply by providing the new login details you will able to get the solution for your problem, so simply make use of the new setup and get solved for your problem.
Reply With Quote
  #3  
Old 05-04-2010
Member
 
Join Date: Apr 2008
Posts: 4,096
Re: Login Failed For User - Microsoft SQL Server, Error: 4064

Hello, you need to follow the steps below:
  • Open your SQL Express server.
  • Now you will get the Login option where you need to click on the Options button.
  • Here you will get the drop down box as “Connect To Database” where you need to select the option of the “master”
  • Now you will able to get the login successfully.
  • Then simply run the script as below:
    Quote:
    ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=master
    GO
Reply With Quote
  #4  
Old 05-04-2010
Member
 
Join Date: May 2008
Posts: 3,313
Re: Login Failed For User - Microsoft SQL Server, Error: 4064

Hello, you can simply able to change your default database for the your SQL Server by using the ALTER LOGIN. If you want to checkout your settings then you can simpoy You can check your current settings for all users using sys.server_principals. It may be also possible that you are having mixed mode enabled and if you want to solve that problem then you must need to make use of the enabling of the authentication mode. You can simply upgrade the CTP 15 (build 1187) and solve your problem.
Reply With Quote
  #5  
Old 05-04-2010
Member
 
Join Date: Jan 2008
Posts: 3,757
Re: Login Failed For User - Microsoft SQL Server, Error: 4064

Hello, I think the reinstallation would be the better option. I think your SQL Server is got corrupted and that is why you are getting this kind of error. So, if you want to solve that problem then you must need to make use of the new installation which will simply solve your problem. It is needed to make use of the new installation and solve your problem. It will take few minutes and you will able to solve your problem.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Login Failed For User - Microsoft SQL Server, Error: 4064"
Thread Thread Starter Forum Replies Last Post
Need help to create a login user form in Microsoft Excel Henriksen MS Office Support 2 23-02-2012 05:04 PM
Getting VMware VDM server authentication failed error, While trying to login in vdm client using vdm Ryszard Windows Software 3 15-09-2011 10:44 PM
Cannot open database "db1. Login failed for user 'BIGRED1\ASP.NET' Aadidev Software Development 4 16-06-2011 07:03 AM
Login Completely Blocked w/User Profile Service Failed the Login RaeS Vista Help 6 08-02-2011 11:39 PM
At login time get error “Error in service user profile session. No start to load user profile” Maal-Gaadi Operating Systems 5 28-12-2010 06:53 PM


All times are GMT +5.5. The time now is 11:49 PM.