Thanks TurboPT for all the suggestion. I am using SQL server 2005 enterprise edition. and it has Mixed Mode enabled. Let me explain the whole scenario once again.
Environment: SQL Server 2005 Enterprise Edition running on windows server 2003.
Apache
Problem 1:Initially, I had Php 5.3 and whenever i tried to install, i was getting
" Warning!: Your PHP installation don't have the mssql extension mssql- without it is IMPOSSIBLE to use Testlink.Failed!"I tried installing mssql driver for php;
http://www.microsoft.com/sqlserver/2005 ... river.aspx, but the dll which comes with it was php_sqlsrv_52_nts_vc6.dll. I also tried with other dll which came in the package but everytime i was getting the same error as mentioned above.
Solution 1:The solution was to install php 5.2.17 which has php_mssql.dll. Now the above error dissapeared and testlink was able to recognise the mssql extension. Obviously i had to enable the dll on php.ini file
Problem 2Now i am getting an internal server error, I tried both on apache and IIS 7. I don't know where and how to debug. As mentioned above, the sql server is enterprise version and has mixed mode enabled.
Solution 2 As a workaround, i installed on mysql which created the custom_db.config file. Then i ran
C:\inetpub\wwwroot\testlink\install\sql\mysql\
a. testlink_create_tables.sql
b. testlink_create_default_data.sql
Both these created the desired db and put default data into it. After that, i ran,
c) C:\inetpub\wwwroot\testlink\install\sql\alter_tables\1.9.1\mssql\DB.1.4\step1\db_schema_update.sql
d) C:\inetpub\wwwroot\testlink\install\sql\alter_tables\1.9.1\mssql\DB.1.4\stepZ\z_final_step.sql
And finally i changed the custom_db.config to point to my new db in sqlserver and it worked correctly. This way i got testlink working.
Problem 3While running
solution 2 above,
c) C:\inetpub\wwwroot\testlink\install\sql\alter_tables\1.9.1\mssql\DB.1.4\step1\db_schema_update.sql gives an error. This is at running the two sql statement
in db_schema_update.sql
ALTER TABLE /*prefix*/req_versions ADD revision INTEGER NOT NULL DEFAULT '1';
ALTER TABLE /*prefix*/req_versions ADD log_message TEXT NULL DEFAULT NULL;
Solution 3These steps are not required and should be skipped.
Note I am surprised that even i am installing 1.9.2 manually, i had to run schema upgrade, i think it should have been part of below two statement
a. testlink_create_tables.sql
b. testlink_create_default_data.sql
Finally, I however still want to run a full install through the automatic install process and not the workaround in solution 2.