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

Friday, November 30, 2012
Avatar
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
Avatar
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
Avatar
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: 4398