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 |
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 |