In order to ensure a proper SQLServer access to the database server instance's databases, the following actions are needed.
Steps:
1. Verify that the SQLServer's Database instance service has started. This is managed in the database server's "Administrative Tools", in "Services", where the service name usually goes by "SQL Server (instance_name)". Notice instance_name refers to the name of your database instance.
2. Open a command prompt window.
3. At the commando prompt, type the following command:
osql -U sa
4. Press ENTER. You should be prompted for a password.
5. Type your "sa" account password and press ENTER. If the following line appears, then your password is correct and you will be connected to you database engine.
1>
6. Type the following command:
SELECT name FROM sysdatabases
7. Press ENTER. Type the following command:
go
8. Press ENTER. A list with the current instance's available databases should appear.
The database specified in BizAgi's configuration should be there.
9. Check your BizAgi's configuration to make sure it matches with the database information you have just verified.
---------- Post added at 06:02 PM ---------- Previous post was at 05:59 PM ----------