No longer can access Office accounting 2009 to close out year. Had been able to access through Windows 11 until now.

Question

Not sure if this is the correct group. I am a hold out using the OLD Office Accounting 2009. Do have a new program starting 2025.

Have been able to use on Windows 11 until now. Issue seems to be not able to connect to Microsoft sequel server. Need access to close out 2024 and produce reports for tax filing.

Any suggestions?

Answer 1

Hello,

Here’s a step-by-step guide to troubleshooting the issue of not being able to connect to Microsoft SQL Server in Office Accounting 2009 on Windows 11:

1. Check SQL Server Services: Make sure that SQL Server services are running:

Press Windows + R, type services.msc, and press Enter.

Look for services related to SQL Server (e.g., "SQL Server (MSSQLSERVER)") and ensure they are running.

If the service is not running, right-click on it and select "Start."

1. Verify SQL Server Configuration:

Open the SQL Server Configuration Manager and ensure that the SQL Server instance is configured to use TCP/IP. Navigate to: SQL Server Configuration Manager > SQL Server Network Configuration > Protocols > TCP/IP.

If TCP/IP is disabled, right-click on it and select "Enable."

1. Check Firewall Settings:

Ensure that the firewall is not blocking SQL Server's port (usually 1433). You can either temporarily disable the firewall or configure it to allow communication on the SQL Server port.

1. Check the Database Connection String:

Ensure that the connection string in Office Accounting 2009 is correct, including the database name, username, and password. Double-check that the correct instance of SQL Server is being referenced.

1. SQL Server Version Compatibility:

It’s possible that there are compatibility issues between Office Accounting 2009, Windows 11, and SQL Server. Try updating your SQL Server version or running Office Accounting 2009 in compatibility mode for an earlier version of Windows (e.g., Windows 7 or Windows 10).

1. Check the Database Files:

If SQL Server itself is running but you can’t connect, check if the database files are corrupted or if there are permission issues preventing access.

1. Repair or Reinstall Office Accounting 2009:

If none of the above steps resolve the issue, you might need to repair or reinstall Office Accounting 2009 to fix any corrupted or missing files.

If these steps don't solve the problem, please provide additional error messages or details, and we can troubleshoot further.

Answer 2

Hello,

Here’s a step-by-step guide to troubleshooting the issue of not being able to connect to Microsoft SQL Server in Office Accounting 2009 on Windows 11:

1. Check SQL Server Services: Make sure that SQL Server services are running:

Press Windows + R, type services.msc, and press Enter.

Look for services related to SQL Server (e.g., "SQL Server (MSSQLSERVER)") and ensure they are running.

If the service is not running, right-click on it and select "Start."

1. Verify SQL Server Configuration:

Open the SQL Server Configuration Manager and ensure that the SQL Server instance is configured to use TCP/IP. Navigate to: SQL Server Configuration Manager > SQL Server Network Configuration > Protocols > TCP/IP.

If TCP/IP is disabled, right-click on it and select "Enable."

1. Check Firewall Settings:

Ensure that the firewall is not blocking SQL Server's port (usually 1433). You can either temporarily disable the firewall or configure it to allow communication on the SQL Server port.

1. Check the Database Connection String:

Ensure that the connection string in Office Accounting 2009 is correct, including the database name, username, and password. Double-check that the correct instance of SQL Server is being referenced.

1. SQL Server Version Compatibility:

It’s possible that there are compatibility issues between Office Accounting 2009, Windows 11, and SQL Server. Try updating your SQL Server version or running Office Accounting 2009 in compatibility mode for an earlier version of Windows (e.g., Windows 7 or Windows 10).

1. Check the Database Files:

If SQL Server itself is running but you can’t connect, check if the database files are corrupted or if there are permission issues preventing access.

1. Repair or Reinstall Office Accounting 2009:

If none of the above steps resolve the issue, you might need to repair or reinstall Office Accounting 2009 to fix any corrupted or missing files.

If these steps don't solve the problem, please provide additional error messages or details, and we can troubleshoot further.

Just now reading this response. Internet had been down since this weekend.

Am I reading steps correctly, that need to have access to the sql server? I only have access to my desktop. SQL is from Microsoft.

Program works fine on PC with Windows 10, but cannot access as says my company was created on another PC.

Thank you for your time.

Answer 3

Windows Client for IT Pros and Windows Server forums are moving to Microsoft Q&A

We’re transitioning to Microsoft Q&A for a more streamlined experience. Starting 21 February, new questions can only be posted on Microsoft Q&A. Existing discussions will remain accessible here. 

From the 26 February customers looking for support on Answers will be automatically redirected to Microsoft Q&A.