The Database Name List

< Previous section  |  Table of Contents  |  Index  |  Next section >

If you click the "..." associated with "Database Name" in windows for specifying databases, MainBoss displays a list of known MainBoss databases. If you have specified a "Database Server", the list shows databases on the given server; if "Database Server" is blank, MainBoss lists all known databases on all known servers.

Each line in the list provides information about a single database. The window has several columns:

Server Name: The instance of SQL Server that manages the database.

DataBase Name: The actual name of the database, as used by SQL Server.

Version: The version of the database. Usually, each different version of the MainBoss software uses a different version of the database; however, this may not always be the case. If the version of a database is older than the version expected by your current MainBoss software, you will have to upgrade the database before you can use it.

Organization Name: Your own personal name for the database. You can change this at any time, as described in Changing Organization Information.

User Record Exists: Whether or not the database's Users table has an entry for your login name.

Access Error: If MainBoss encounters an error when trying to access the database, the error message will appear in this column.

If you want to create a new database, you should choose some name that is not shown in the list. (Note that the window only shows MainBoss databases. If there are any non-MainBoss databases maintained by the same SQL Server, those databases do not appear in the list.)

Note: The list only shows MainBoss databases for which you have SQL Server permissions. You can have SQL Server permissions on a database but still not appear in the database's Users table; in this case, you will not be able to access the database with MainBoss, even though SQL Server would normally allow access.

If you want to add an existing database to your list of known databases, you can click on the appropriate name in the list. Adding a name to your list of known databases doesn't necessarily give you access to that database—you still have to be on the database's list of authorized users (Administration | MainBoss Users).

< Previous section  |  Table of Contents  |  Index  |  Next section >