Page 1 of 1

Error in connection to sql server

Posted: Tue Mar 27, 2012 3:35 am
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]

Re: Error in connection to sql server

Posted: Tue Mar 27, 2012 3:43 am
by aostad
BTW, the bug tracking database is in a remote machine.

Re: Error in connection to sql server

Posted: Tue Mar 27, 2012 12:17 pm
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.