SQL Server failing

Erik Aandahl's Avatar

Erik Aandahl

15 May, 2023 08:07 AM

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?

  1. Support Staff 1 Posted by Feodor Fitsner on 15 May, 2023 01:29 PM

    Feodor Fitsner's Avatar

    Hi Erik,

    We are looking into that. Could you drop a link to a failing build please?

  2. 2 Posted by Erik Aandahl on 15 May, 2023 02:57 PM

    Erik Aandahl's Avatar
  3. Support Staff 3 Posted by Owen McDonnell on 15 May, 2023 03:03 PM

    Owen McDonnell's Avatar

    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. 4 Posted by Erik Aandahl on 15 May, 2023 03:47 PM

    Erik Aandahl's Avatar

    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

  5. Support Staff 5 Posted by Owen McDonnell on 16 May, 2023 06:51 PM

    Owen McDonnell's Avatar

    We've redeployed the problematic image update after identifying the issue.
    Please let us know if you experience the same errors.

  6. Feodor Fitsner closed this discussion on 16 Jul, 2023 09:03 PM.

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