0

I have a SQL Server 2005 database that I can see in SQL Server Management Studio Express. There is a front end application, but since the upgrade to Windows 10, I cannot access the database with it. In SQL Server Management Studio Express there are no object folders listed for the database - and the summary shows 0 items. The database folder has a correctly named mdf file of 197MB.

I have very little experience of SQL Server so would appreciate any pointers.

Improve this question
0

1 Answer 1

Reset to default
4

Unfortunately (regarding your problem) Microsoft is pretty clear about your situation on this SQL Server 2005 information doc:

This section provides support information about instances of SQL Server 2005 in Windows 8.1 or Windows 8 environments. It also describes the options that are available for customers who are using SQL Server 2005.

Microsoft SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows 10, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. You will receive a warning in the Action Center if Windows 10, Windows 8.1, or Windows 8 detects an instance of SQL Server 2005.

To resolve this issue, upgrade or remove the existing instance of SQL Server 2005. For information about how to upgrade SQL Server, see Upgrade to SQL Server.

Improve this answer
8
  • Thanks for that - I don't have the SQL Server admin password. Will I be able to upgrade without that?
    – Aquamarine
    Commented Aug 29, 2022 at 21:17
  • @Aquamarine, in order to regain admin access you could try Recover a lost SA password. I'd suggest creating a new admin account since changing the old one could break some application (possibly) using it.
    – Ronaldo
    Commented Aug 29, 2022 at 21:40
  • @Aquamarine were you able to reestablish SQL Server by Upgrading it? If not, maybe you could try to follow the Go back to Windows 8.1 doc to revert to whatever Windows version you had before on the machine. Please, remember to mark the answer as the correct one if it has properly answered your initial question.
    – Ronaldo
    Commented Aug 31, 2022 at 16:44
  • I installed the newer version but no luck so far.
    – Aquamarine
    Commented Sep 2, 2022 at 12:18
  • 1
    Thank you for your help
    – Aquamarine
    Commented Sep 9, 2022 at 12:10

Not the answer you're looking for? Browse other questions tagged or ask your own question.