Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Cannot open user default database. Login failed. After upgraded to window 8.1

Hi,
My local database connection was all okay until i upgraded to window 8.1. I'm using web developer 2008 express and SQL Server 2008 R2.

The error as attached. Been trying to seach for solution, but to no avail. Please help :(
0
tangteng78
Asked:
tangteng78
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
No attachment.
0
 
tangteng78Author Commented:
Sorry Dave. Did you missed out anything? As i can't see any comment.
0
 
QlemoC++ DeveloperCommented:
Dave wanted to tell you that WE are missing the attachment containing the error message here.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
tangteng78Author Commented:
Ohh...sorry guys. There you go.
login-failed.jpg
0
 
QlemoC++ DeveloperCommented:
From which OS did you upgrade? You might have to reapply the security settings of your local MSSQL server.
0
 
tangteng78Author Commented:
From window 8.0 to 8.1

How do i reapply the security setting of the MSSQL server?
0
 
QlemoC++ DeveloperCommented:
If only I knew ... 8.0 to 8.1 should not have that effect, but maybe it is because the Microsoft Online accounts are more tightly integrated now.
If noone comes up with a better idea, you can do a repair install of MSSQL. That way you will fix authentication issues, but there might be a more direct way.
0
 
Scott PletcherSenior DBACommented:
Make sure the default db for that login is set and that it actually exists.

--NOTE: this code only works if this is a Windows User login, NOT a Windows Group login.
ALTER LOGIN [Ethan\EngTeng] WITH DEFAULT_DATABASE = master
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now