Link to home
Start Free TrialLog in
Avatar of tangteng78
tangteng78Flag for Malaysia

asked on

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

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 :(
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

No attachment.
Avatar of tangteng78


Sorry Dave. Did you missed out anything? As i can't see any comment.
Dave wanted to tell you that WE are missing the attachment containing the error message here.
Ohh...sorry guys. There you go.
From which OS did you upgrade? You might have to reapply the security settings of your local MSSQL server.
From window 8.0 to 8.1

How do i reapply the security setting of the MSSQL server?
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.
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial