When you try to log on to a Microsoft Business Solutions - Enterprise Reporting database, you receive the following error message:
Database and application versions do not match. Please contact your sales representative concerning an upgrade.
This problem occurs if the name of the Microsoft SQL Server database on the server includes a space. Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
To resolve this problem, rename the database by using a name that does not contain a space.
To rename the database, follow these steps:
1. Start SQL Server Enterprise Manager.
2. Locate the database whose name contains a space. Make sure that you know where the .mdb file for this database is located on the server.
3. Right-click the database, click All Tasks, and then click Detach Database.
4. Right-click Databases, click All Tasks, and then click Attach Database.
5. In the Attach Database dialog box, locate the .mdb file for this database.
6. In the Attach as field, rename the database. Use a name that does not contain any spaces.
7. Update your Open Database Connectivity (ODBC) connection with this new database name.
This blog was created to help CIOs, Program leads, solution architects and administrators.
Subscribe to:
Post Comments (Atom)
Digital Transformation unleashed
You're the CIO/CDO sitting in your weekly update executive meeting with the CEO, CFO, COO, and others. You start the meeting with the pr...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...
-
Did you hear about the latest trend in databases? If not then you should read this article about NoSQL or "not only SQL". NoSQL...
No comments:
Post a Comment