Results 1 to 5 of 5

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

  1. #1
    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:
    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.

  2. #2
    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.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,089

    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:
      ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=master
      GO

  4. #4
    Join Date
    May 2008
    Posts
    3,319

    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.

  5. #5
    Join Date
    Jan 2008
    Posts
    3,758

    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.

Similar Threads

  1. Need help to create a login user form in Microsoft Excel
    By Henriksen in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 05:04 PM
  2. Replies: 3
    Last Post: 15-09-2011, 10:44 PM
  3. Replies: 4
    Last Post: 16-06-2011, 07:03 AM
  4. Replies: 6
    Last Post: 08-02-2011, 11:39 PM
  5. Replies: 5
    Last Post: 28-12-2010, 06:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •