SQL with Test Director

[thelabguy]

Having problems connecting Test Director to the SQL 7.0 DB. When I try to create a new project, it won't connect to the DB. Although other DB's are not installed on this server, projects can be successfully created.

The error reads:
Project creation failed
cannot connect with administrator privilages
general sql error
so on and so on...

Anything Obvious we're missing? (already thought Password)

 

[thelabguy]

Oooooops, fixed our own small problem. One of the SQL server settings was a little off. We just had to point it to it's self.

Thanks anyways!

(but we are supposed to be trying out Oracle instead of SQL, you may yet be able to share your knowledge!!)

 

[Guest_imported]

Dear all

I am having a problem trying to connect Test Director 7.0x to an imported SQL Server database. Basically, I have created a new database using the Project Administration facility (this connects ok), and then overwritten this with a backed up copy of Test Director (from a completely different server environment). During this database restore however, it appears that the user privileges are being redefined as when I try to login into the new database, the following message appears:

Session::Connect cannot connect to the database
Cannot connect to the database.
Session :: DbInit
BaseCursor :: BaseCursor
CDbConPool::GetDBh
DbConPool.cpp ; DbiOpenDatabase ; L102
Error:General SQL error.Alias: TD_gsoServer message: Server user 'td' is not a valid user in database 'td_gso'

The thing I cannot seem to work out is how to alter the connection to connect to the new database with the new login name.

Many thanks

Bradley