Testlink with MSSQL

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
winsorc
TestLink user
Posts: 2
Joined: Thu Oct 18, 2012 8:32 pm

Testlink with MSSQL

Post by winsorc »

MS SQL Support

I'm trying to do a fresh install of TestLink on Windows Server 2008 R2 using IIS and MS SQL.

I tried following this http://www.teamst.org/forum/viewtopic.php?f=1&t=6952, however I'm stuck on the install page telling me:
Checking MSSQL Database Failed! MSSQL Database cannot be used.

I have another PHP Page I've written hosted by this webserver that can return results from my SQL Server 2008 Instance.

I go to the phpinfo() page from the IIS PHP Manager settings and I see that sqlsrv is enabled.

Any ideas why TestLink think's its not when it is?

I know this is an open source project but does TestLink support MS SQL And do they plan to support it in the future, I don't really want to run MySQL because we are a MSSQL shop around my office. At the same time I don't want to run something that is unsupported.
fman
Member of TestLink Community
Posts: 3102
Joined: Tue Nov 15, 2005 7:19 am

Re: Testlink with MSSQL

Post by fman »

1. we support MSSQL
2. if you do some searches in the forum you are going to find a COMPLETE explanation done by users that use it with success
3. Please follow the advide you received on the mail confirming you user, same advice that is present on each branch of forum on 'READ BEFORE POST' or something like that.

some info on MSSQL
http://www.teamst.org/forum/viewtopic.php?f=25&t=6970

if you search IIS
http://www.teamst.org/forum/viewtopic.p ... &hilit=IIS

if you search MSSQL in forum
http://www.teamst.org/forum/viewtopic.p ... ilit=MSSQL
winsorc
TestLink user
Posts: 2
Joined: Thu Oct 18, 2012 8:32 pm

Re: Testlink with MSSQL

Post by winsorc »

I did search and followed the COMPLETE instructions, however it didn't work with a fresh version testlink 1.9.4.

I did get it working by upgrading to PHP 5.3 from the web platform installer instead of version 5.2 which was what was recommended in step 3 from the complete instructions. I did this because I saw in the install manual for 1.9.4 that there is now php 5.3 support.

If you'd like I'll list out my install instructions once I get finished and I'm able to reproduce them.
fman wrote:1. we support MSSQL
2. if you do some searches in the forum you are going to find a COMPLETE explanation done by users that use it with success
3. Please follow the advide you received on the mail confirming you user, same advice that is present on each branch of forum on 'READ BEFORE POST' or something like that.

some info on MSSQL
http://www.teamst.org/forum/viewtopic.php?f=25&t=6970

if you search IIS
http://www.teamst.org/forum/viewtopic.p ... &hilit=IIS

if you search MSSQL in forum
http://www.teamst.org/forum/viewtopic.p ... ilit=MSSQL
fman
Member of TestLink Community
Posts: 3102
Joined: Tue Nov 15, 2005 7:19 am

Re: Testlink with MSSQL

Post by fman »

Just now I've reviewed your first post and Oops! I've found you already have followed instructions posted here (apologize for my quick answer).
I've installed without issues 1.9.4 using XAMPP ( I do not like IIS) and MSSQL 2008 express, without any special steps.
It would be great if you provide a document that will be useful for others.
abrjib0
TestLink user
Posts: 8
Joined: Thu Jan 31, 2013 7:42 pm

Re: Testlink with MSSQL

Post by abrjib0 »

Hi Guys,

As many of our friends did, I have also searched within Testlink Forum and in Google to find any concrete steps or instructions to install TestLink with MSSQL. Could anyone please provide an instruction to install the latest Testlink 1.9.5 using a MSSQL DB? We also plan to use LDAP and JIRA with testlink. Any support in this matter is highly appreciated.
New to TL and finding it GREAT! :-)
fman
Member of TestLink Community
Posts: 3102
Joined: Tue Nov 15, 2005 7:19 am

Re: Testlink with MSSQL

Post by fman »

You have to follow indication scattered on different post regarding MSSQL PHP Drivers, after this is OK; installing on MSSQL is done same way that for other DBMS type
You have apply after installation available fixes (from our mantis site)
abrjib0
TestLink user
Posts: 8
Joined: Thu Jan 31, 2013 7:42 pm

Re: Testlink with MSSQL

Post by abrjib0 »

Thanks fman
I lost most of my hairs and decided to install it with MySQL. :-) Used BitNami stack. Version 1.9.5. working great.. Many thanks for the wonderful product. I have used various Open source products and expensive licensed products in the past. It has almost every feature that an expensive Test Management tool could offer. Great job guys..
New to TL and finding it GREAT! :-)
jack090
Advanced user
Posts: 39
Joined: Tue Dec 21, 2010 4:16 pm

Re: Testlink with MSSQL

Post by jack090 »

Not to revive a thread that "doesn't" need a solution right now, but I will say that I plan on making a new guide using 1.9.5 when I get a little time this next month. I'll post it again if anyone is in need of it. (I'm still using 1.9.3).
TSSUSER
TestLink user
Posts: 1
Joined: Mon Sep 10, 2012 6:06 pm

Re: Testlink with MSSQL

Post by TSSUSER »

I try to install TESTLINK 197 using the following configuration:

WINDOW 7 (64Bits)
APACHE 2.4
PHP 5.4
MS SQL 2008

I get the following message: "mssqlnative extension not installed"

I put the extentions "php_sqlsrv_54_ts.dll" and "php_pdo_sqlsrv_54_ts.dll" in the \EXT
folder, the file phi.ini was modified in order to use these extensions.

Please help me.
Post Reply