Testlink with mssql 2005

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
Koray
TestLink user
Posts: 1
Joined: Mon Jun 15, 2009 3:38 pm

Testlink with mssql 2005

Post by Koray »

Hello

I've been trying to set up testlink on my local machine (with local mssql 2005) to test it.

I always get the same error when trying to set it up :
TestLink setup will now attempt to setup the database:
Creating connection to Database Server: Failed!
Please check the database login details and try again.
Database Error Message:
I am using wamp (latest version), uncommented mssql extension.
Installed the mssql driver and tested the connection to the database with a php script following this link :
http://technet.microsoft.com/en-us/libr ... 93139.aspx

Here is the script and it works :
<?php
$serverName = "DMC17775\SQLEXPRESS";

$connectionOptions = array("UID" => "admin", "PWD" => "mypassword", "Database"=>"testlink");

/* Connect using SQL Authentication. */

$conn = sqlsrv_connect( $serverName, $connectionOptions);
if( $conn === false )
{ die( FormatErrors( sqlsrv_errors() ) ); }
?>
Any idea ? I checked the source code and I gathered that the problem occurs when it is trying to connect to DB Server without choosing an specific database, I tryed to go deeper but without success.

If all fails I could probably try to just call my script instead but this will probably cause more problem than it will solves.
ellar
TestLink user
Posts: 7
Joined: Tue Jul 28, 2009 8:20 am

same problem

Post by ellar »

Can nobody solve that problem? I have exactly the same problem, with the provided script (the script from the TL manual) the connection works fine but the installation allways gives mit the following message:


TestLink setup will now attempt to setup the database:

Creating connection to Database Server: Failed!
Please check the database login details and try again.
Database Error Message:


Any ideas what to try?
ellar
TestLink user
Posts: 7
Joined: Tue Jul 28, 2009 8:20 am

problem solved

Post by ellar »

I could solve the problem by hardcoding admin name, admin password and servername. Everything seems the be installed correctly now expect the user that should be created, but lets see if this is a problem or not.

I will tell my next steps, as soon as I managed to login to TL.
ellar
TestLink user
Posts: 7
Joined: Tue Jul 28, 2009 8:20 am

Post by ellar »

so far so good, installation is successful now, but by clicking the link:

You can now log into the TestLink (using login name:admin / password:admin - Please Click Me!).

I am redirected to a FatalError page and no login is possible. manually executing login.php always gives me the same error page.
ellar
TestLink user
Posts: 7
Joined: Tue Jul 28, 2009 8:20 am

Post by ellar »

finally I made it :D

I had to change the db host from localhost to localhost\sqlexpress in the "config_db.inc.php" file.

now I can Log in and go on...lets the what else comes up now.
ellar
TestLink user
Posts: 7
Joined: Tue Jul 28, 2009 8:20 am

Post by ellar »

the problem seems to be in the hostname (localhost\sqlexpress). I do not know why but it is not correctly handled and that leads to the installation problems.
Post Reply