Error in connection to sql server

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
aostad
Member of TestLink Community
Posts: 183
Joined: Wed Apr 01, 2009 8:32 pm

Error in connection to sql server

Post by aostad »

By any chance, do you know the following error message is as a result of wrong uid/password or something else?
The admin userid/password used to connect mssql (sql server):

Thanks,
AO

[<<][4f7132d6c3a40566282250][DEFAULT][/testlink/lib/execute/execSetResults.php][12/Mar/27 03:24:06][12/Mar/27 03:24:06][took 0.173239 secs]
[>>][4f7132d6ef8ea615157337][DEFAULT][/testlink/lib/execute/execSetResults.php][12/Mar/27 03:24:06]
[12/Mar/27 03:24:07][WARNING][uo5ggjlo2gufsbcl23250oge60][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: message: Login failed for user 'aostadsa'. (severity 14) - in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 569
[12/Mar/27 03:24:07][WARNING][uo5ggjlo2gufsbcl23250oge60][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: RSQ01DBTF - in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 569
[12/Mar/27 03:24:07][WARNING][uo5ggjlo2gufsbcl23250oge60][GUI]
E_WARNING
mssql_query(): supplied argument is not a valid MS SQL-Link resource - in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 547
[12/Mar/27 03:24:07][ERROR][uo5ggjlo2gufsbcl23250oge60][GUI]
Connect to Bug Tracker database fails: (interface: TFS - Host:RSQ01DBTF - DBName: QF01TFS01 - User: aostadsa) - Login failed for user 'aostadsa'.
[<<][4f7132d6ef8ea615157337][DEFAULT][/testlink/lib/execute/execSetResults.php][12/Mar/27 03:24:06][12/Mar/27 03:24:07][took 0.840868 secs]
aostad
Member of TestLink Community
Posts: 183
Joined: Wed Apr 01, 2009 8:32 pm

Re: Error in connection to sql server

Post by aostad »

BTW, the bug tracking database is in a remote machine.
TurboPT
Member of TestLink Community
Posts: 343
Joined: Sun Dec 10, 2006 4:51 am

Re: Error in connection to sql server

Post by TurboPT »

Well, although it does have:
server_response wrote: mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: message: Login failed for user 'aostadsa'.
However, that does NOT mean that the credentials are wrong, but that the remote server may be denying your current machine from access. For example, your machine might be 10.30.1.1 and the remote could be 10.30.1.2, and you do not have a login allowed from 10.30.1.1. The login is a user/pass/host combination, and that would have to be applied at the remote configuration.

See this post, where I helped someone else with a similar issue with MySQL connecting to a remote Bugzilla.
Post Reply