Project Build Error: Invalid database name, Earlier it was working fine. See attachmen

Ashish

Readyroll project was being built successfully but since few days it has started giving attached error whereas I haven't provided any change to the project. DB name is SQLDevOpsDB but it gives the error that No SqlDevOpsDB_LIN66005 exist whereas it is given as SqlDevOpsDB and Onpremise server name starts from LIN...It seems it is attaching the part of server name by itself and giving error.

JackJarvis

Hello

The screenshot you posted doesn't seem to show the entire build output. Could you post it here in a text file? Having this information will help us look into your problem further.

Thanks

Ashish

Hi Jack,

Thanks for responding.It's the error displayed on VSTS site and unfortunately It's not allowing me to copy the text. Not sur if it is accessible to you, sending you the link in case if it is accessible

https://sqldevopsaccount.visualstudio.com/SQLDevOpsTeamProject/SQLDevOpsTeamProject Team/_build/results?buildId=160&_a=summary&view=logs

Ashish

I could copy the following text from Summary page but unable to copy detailed one. That would be great if you are able to provide inputs looking at it.

SQLDevOpsDatabase\OnPremiseReadyroll\Post-Deployment\01_Finalize_Deployment.sql(0,0): Error : An error occurred while attempting to verify project scripts:
Msg 15010, Level 16, State 1, Server LIN66005670\LOCALDB#D9AC3FCB, Line 1
The database 'SqlDevOpsDB_LIN66005' does not exist. Supply a valid database name. To see available databases, use sys.databases.



Process 'msbuild.exe' exited with code '1'.

JackJarvis

This might be a problem with the way your build is set up in VSTS. Could you send screenshots of your VSTS build configuration, in particular the ReadyRoll build tasks that specify the target database and server?