Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > System.Data.SqlClient.Sql...

System.Data.SqlClient.SqlException: Login failed for user 'SpiraTest'.

Friday, November 30, 2012

steve_claypool

We just purchased a license and we are trying to install against a remote SQL Server Enterprise server. I installed and evaluated the trial on a local SQLExpress instance without any issues, but we are getting an error when trying to navigate to the login page after installing the licensed version against our remote SQL Server. Are there any settings that need to be made to the SQL server, other than setting up the initial admin user for the install?

2 Replies

Friday, November 30, 2012

inflectra.david

re: steve_claypool Friday, November 30, 2012

Hi Steve

I would recommend submitting a help desk request for this issue since it sounds time critical and we don't check the forums as frequently as the help desk.

Did the installer complete the installation correctly? Do you see the database inside the SQL Server (using SQL Management Studio)? Do you see a login in the database called SpiraTest. Does the password match up with the onside the application's Web.Config file?

Regards

Adam

Friday, November 30, 2012

steve_claypool

re: inflectra.david Friday, November 30, 2012

We were able to resolve this. The user my DBA setup to install spira was "spiratest" and Spira was defaulting to creating a user named spiratest. I uninstalled and changed the user and login Spira wanted to create to SpiraTestUser and that resolved the issue.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

Statistics

Started: Friday, November 30, 2012
Last Reply: Friday, February 21, 2020
Replies: 2
Views: 4427

System.Data.SqlClient.SqlException: Login failed for user 'SpiraTest'.

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Edit Thread

Edit Message

Search Results