MSSQL PROBLEM

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

MSSQL PROBLEM

Postby yes2000 » Wed Jun 23, 2010 2:24 pm

Hi All,

I think I did all the installations steps correctly, I am using MSSQL, I did supply the server name and the user name and password and everything seems working and when test link try to create database I get the following message
Test Link setup will now attempt to setup the database:

Creating connection to Database Server: OK!

Checking MSSQL version: OK! (9.00.3042 >= 8)

Connecting to database `testlink`: OK!

And then nothing at all, I did open the SQL server I found the database but I found no tables, any idea

Regards,
yes2000
TestLink user
 
Posts: 4
Joined: Wed Jun 23, 2010 2:07 pm

Re: MSSQL PROBLEM

Postby yes2000 » Wed Jun 23, 2010 5:20 pm

SOLVED
yes2000
TestLink user
 
Posts: 4
Joined: Wed Jun 23, 2010 2:07 pm

Re: MSSQL PROBLEM

Postby TurboPT » Wed Jul 14, 2010 2:03 am

Can you please share your discovery?

Others could possibly benefit from what you found.
TurboPT
Member of TestLink Community
 
Posts: 339
Joined: Sun Dec 10, 2006 4:51 am

Re: MSSQL PROBLEM

Postby mallpraveen » Sun Nov 07, 2010 1:21 pm

I have also got the same issue. I can see the DB but no tables. testlink login page redirects to install page always ..not sure may be tables are not there.
If anybody can help us regarding this , it would be great.
mallpraveen
TestLink user
 
Posts: 3
Joined: Sun Nov 07, 2010 12:12 pm

Re: MSSQL PROBLEM

Postby mallpraveen » Sun Nov 07, 2010 3:49 pm

I got my testlink working fine.
I just sitted whole day and finally found the solution ..by just trying here and there ...odd stuffs ..and finally it worked.
Few days ago I had installed testlink with mysql which worked fine without any issue. But with mssql I faced lot of issues.

So here is the solution in steps ( I am not good with explanation so sorry for that):
1. In sql2005 installation chose to use "sa" account and set the password for that.(User can go for windows authentication mehtod too but testlink installation itself fails and says there is no mutual trust for account, it seems like its not a testlink propblem ..its a problem between php and sql server) ...There are multiple blogs too for setting the mutual trust...but none of that solved my problem. So I went ahead using sa username only
2. on testlink installation page there are two places where you have to enter the username and passwords. a) At first place
user enters the sa/password. 2)In second place user enters any username/password which user thinks(According to message appears on page ) ..it will be created during testlink installation. When I entered the username/password ...the final page doesnt display anything other than 3-4 ok statements and final statement would connection with database. Which is bad. And if you try login to testlink assuming install was successful it redirects to install page.

What I simply did , I entered the sa/password at second place too and installtion was successful. Installtion script checked the user and dispaled user already exist.

It worked fine when I entered the existing user. I dont know why It didnt work when I enter username/password which doesnt exist on server(Which woked when I used mysql).
mallpraveen
TestLink user
 
Posts: 3
Joined: Sun Nov 07, 2010 12:12 pm


Return to Installation and configuration



Who is online

Users browsing this forum: Google [Bot] and 2 guests