Knowledge Base Article

Home Page > Knowledge Base > KronoDesk

Home Page > Knowledge Base > Spira Platform

Home Page > Knowledge Base > Spira Platform > SpiraPlan

Home Page > Knowledge Base > Spira Platform > SpiraTeam

Home Page > Knowledge Base > Spira Platform > SpiraTest

Article After restoring a backup of my database, I keep getting unable to login to database errors?

by Adam S on Tuesday, June 9, 2015

This usually just means that the restored database just needs to be linked to the existing database server login. This can be done by executing the appropriate SQL command listed below:
  1. Using SQL Server Authentication
    USE SpiraTeam
    GO
    EXEC sp_change_users_login 'Update_One', 'SpiraTeam', 'SpiraTeam'
    GO
  2. Using Windows Authentication on Windows 2003/2008/Vista/7
    USE SpiraTeam
    GO
    ALTER USER SpiraTeam WITH LOGIN = [NT AUTHORITY\NETWORK SERVICE]
    GO
  3. Using Windows Authentication on Windows XP
    USE SpiraTeam
    GO
    ALTER USER SpiraTeam WITH LOGIN = [MACHINENAME\ASPNET]
    GO

The example above was written with SpiraTeam in mind, since it uses the database name 'SpiraTeam'. If you are experiencing the same issue with SpiraTest, SpiraPlan or KronoDesk, please substitute the name in the SQL commands accordingly.

Attachments
Article Info
Last Updated: 6/9/2015
Article ID: KB156
# Views: 720
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.