Previous Topic

Next Topic

Book Contents

Changing Database Login Data

If you move or rename either your BigTime SQL server or the database in which BigTime's data is stored, you will need to update Monitor's database connection data. You do that using the View... Database Info menu in Monitor.

You'll see the database login screen, and you can fill in the name of the server\instance, the database name, the SQL login and password which BigTime should use to login to the database.

Note that BigTime uses SQL authentication (not integrated NT authentication) to attach to your SQL database. You may need your SQL Server DBA to assign you a database login.

See Also

BigTime Database Maintenance

Backing Up Your BigTime Database

Restoring Your BigTime Database

Default Database Login Information

If you've installed BigTime onto a corporate server, then your dba controls the BigTime login information. If you've installed a default instance of BigTime (e.g. - the desktop installation), then the connection information is as follows:

Property

Value

Server

[ServerName]\BIGTIME

User Login

sa

Password

BIGTIME

Default Database

BIGTIME

You can use those same settings to create ODBC connection(s) to your BigTime database. Just make sure that the computer you are creating a connection from can see the BigTime server, and then create an ODBC connection with the following settings:

Property

Value

Driver

SQL Server

DSN Name

BIGTIME

Server

[ServerName]\BIGTIME

Login Mode

SQL Server authentication

Login ID

sa

Password

BIGTIME

Default Database

BIGTIME