SQL Server failing
Hi.
After the weekend, no tests using SQL Server are passing.
Using image: Visual Studio 2022
Was using
services:
- mssql2017
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:
init:
- net start MSSQL$SQL2019
Then I'm getting
Build started
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.
Any suggenstions?
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
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
Hi Erik,
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
Hi
Here is a build with SQL Server 2019
https://ci.appveyor.com/project/wolftech/wolftech-news-core/builds/47046646
And one with 2017
https://ci.appveyor.com/project/wolftech/wolftech-news-core/builds/47045487
Thanks.
Erik Aandahl
Support Staff 3 Posted by Owen McDonnell on 15 May, 2023 03:03 PM
Hi Erik,
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
Hi
Thanks.
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
than Database=master)
"Server=(local)\SQL2019;Database=master;User
ID=sa;Password=Password12!;MultipleActiveResultSets=True"
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
Server/Instance Specified)
Data:
HelpLink.ProdName: Microsoft SQL Server
HelpLink.EvtSrc: MSSQLServer
HelpLink.EvtID: -1
HelpLink.BaseHelpUrl: https://go.microsoft.com/fwlink
HelpLink.LinkId: 20476
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.
Feodor Fitsner closed this discussion on 16 Jul, 2023 09:03 PM.