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 :(
tangteng78Asked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior 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
 
Dave BaldwinFixer of ProblemsCommented:
No attachment.
0
 
tangteng78Author Commented:
Sorry Dave. Did you missed out anything? As i can't see any comment.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Dave wanted to tell you that WE are missing the attachment containing the error message here.
0
 
tangteng78Author Commented:
Ohh...sorry guys. There you go.
login-failed.jpg
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.