Teamcity build error
When building project in Teamcity getting error principla |'sa|' not found. Below is build log
[01:09:46][Step 1/1] Creating scratch database sqlCI_dced0ebc-8c69-4b09-86be-c4b013028bd5 (6s)
[01:09:46]STARTING: Creating scratch database sqlCI_dced0ebc-8c69-4b09-86be-c4b013028bd5
[01:09:52]##teamcity[buildStatus status='FAILURE' text='Creating scratch database sqlCI_dced0ebc-8c69-4b09-86be-c4b013028bd5 failed with error: Cannot find the principal |'sa|', because it does not exist or you do not have permission.']
[01:09:52]FINISHED WITH ERROR: Creating scratch database sqlCI_dced0ebc-8c69-4b09-86be-c4b013028bd5
[01:09:52][Step 1/1] ##teamcity[buildStatus status='FAILURE' text='Unexpected exception failed with error: Cannot find the principal |'sa|', because it does not exist or you do not have permission.']
Please help
Please sign in to leave a comment.
Hello,
Could you please try to run the same build via command line under the same user that the agent is running under? Please follow the guidelines. Does the build run successfully?
Thanks for your quick reply Alina. The error i am getting when temporary database in build setting is set to some named server. but i am not getting this issue when i set temporary database to sql localdb.
It seems that the issue is not TeamCity related, most probably this is an environment issue. Please use the guideline linked above to investigate the problem.