asked on 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 :(
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 :(
Microsoft SQL ServerMicrosoft SQL Server 2008ASP.NET
Last Comment
Scott Pletcher
No attachment.
ASKER
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.
ASKER
Ohh...sorry guys. There you go.
login-failed.jpg
login-failed.jpg
From which OS did you upgrade? You might have to reapply the security settings of your local MSSQL server.
ASKER
From window 8.0 to 8.1
How do i reapply the security setting of the MSSQL server?
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.
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.