SQL Server failing
After the weekend, no tests using SQL Server are passing.
Using image: Visual Studio 2022
But got error message:
Starting SQL Server 2017 Developer
Waiting for service 'SQL Server (SQL2017) (MSSQL$SQL2017)' to start...
Start-Service : Failed to start service 'SQL Server (SQL2017) (MSSQL$SQL2017)'.
At line:1 char:1
+ Start-Service 'MSSQL$SQL2017'
+ CategoryInfo : OpenError: (System.ServiceProcess.ServiceController:ServiceController) [Start-Service], ServiceCommandException
+ FullyQualifiedErrorId : StartServiceFailed,Microsoft.PowerShell.Commands.StartServiceCommand
Tried to change to SQL Server 2019, using:
- net start MSSQL$SQL2019
Then I'm getting
net start MSSQL$SQL2019
The SQL Server (SQL2019) service is starting.
The SQL Server (SQL2019) service was started successfully.
But all tests are still getting error:
System.InvalidOperationException : Instance failure
The exact same code worked fine before the weekend, but a re-build this morning failed.
After that all builds/test runs are failing.
|?||Show this help|
|ESC||Blurs the current field|
|r||Focus the comment reply box|
|^ + ↩||Submit the comment|
You can use
Command ⌘ instead of
Control ^ on Mac
Support Staff 1 Posted by Feodor Fitsner on 15 May, 2023 01:29 PM
We are looking into that. Could you drop a link to a failing build please?
2 Posted by Erik Aandahl on 15 May, 2023 02:57 PM
Here is a build with SQL Server 2019
And one with 2017
Support Staff 3 Posted by Owen McDonnell on 15 May, 2023 03:03 PM
Thanks for the links.
As we investigate further into the minor update that may have been causing this issue on VS2022 image, we've rolled back to previous working image. Let us know if the problem persists.
4 Posted by Erik Aandahl on 15 May, 2023 03:47 PM
SQL Server 2017 works fine.
SQL Server 2019 is still failing, but that may be other things. We haven't
used 2019 before.
Was trying with this connectionString (should probably be something other
And got this error
System.Data.SqlClient.SqlException : A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
HelpLink.ProdName: Microsoft SQL Server
Support Staff 5 Posted by Owen McDonnell on 16 May, 2023 06:51 PM
We've redeployed the problematic image update after identifying the issue.
Please let us know if you experience the same errors.