Cannot create testlink DB "admin" user on MSSQL 20

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
frankv
TestLink user
Posts: 1
Joined: Tue Sep 01, 2009 1:38 pm

Cannot create testlink DB "admin" user on MSSQL 20

Post by frankv »

I got the following error when I installed Testlink 1.8.3 on SQL server 2008. The connection to the database is OK but the default user (admin) cannot be created in Testlink database. It seems that database.class.php attempt to use null user name and password. :(

Please help, I'm almost done with this installation!

The message:

TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!

Checking MSSQL version: OK! 10.0.1600 >= 8


Database testlink does not exist.
Will attempt to create:
Creating database `testlink`: OK!
ERROR ON exec_query() - database.class.php
0 - 'admin' is not a valid login or you do not have permission. - EXEC SP_PASSWORD NULL,'admin',admin

THE MESSAGE :: SQL [1] executed [took 0.0031 secs][all took 0.0031 secs]: EXEC SP_PASSWORD NULL,'admin',admin Query failed: errorcode[0] errormsg:'admin' is not a valid login or you do not have permission.

Creating Testlink DB user `admin`: Failed! - Could not create user: admin!
Processing:sql/mssql/testlink_create_tables.sql

Importing StartUp data OK!
Writing configuration file: OK!

YOUR ATTENTION PLEASE:
To have a fully functional installation You need to configure mail server settings, following this steps


copy from config.inc.php, [SMTP] Section into custom_config.inc.php.
complete correct data regarding email addresses and mail server.


Installation was successful!
You can now log into the TestLink (using login name:admin / password:admin - Please Click Me!).
bindu
TestLink user
Posts: 1
Joined: Mon Dec 27, 2010 6:12 am

Re: Cannot create testlink DB "admin" user on MSSQL 20

Post by bindu »

could you find a way out of this issue? I am facing the same problem wanted a solution
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Cannot create testlink DB "admin" user on MSSQL 20

Post by fman »

Workaround:
create using SQL client the user you want to use, then try with install
Post Reply