search

dataplat / dbachecks

✔ SQL Server Environmental Validation
https://dbachecks.readthedocs.io/en/latest/
MIT License
460 stars 141 forks source link

Can't connect to SQL Instance Expected $false #1020

Open derekengel opened 9 months ago

derekengel commented 9 months ago

Hello and thank you for your time. I'm just testing dbachecks and I have a small lab environment. After installing the module, and making sure that Pester is at the correct verison, I run the following:

`$SQLServer = "SQLTest1"

Invoke-DbcCheck -SqlInstance $SQLServer -Check LastGoodCheckDB`

It begins to run, but throws:

Can't connect to SQLTest1 Expected $false, because the instance should be available to be connected to!, but got $true.

This looks to come from Database.Tests.ps1 line 208.

This database is accessible. It's local on the server I'm running this from. I can connect to the SQL instance just fine from PowerShell.

flagardien commented 6 months ago

I'm also having the same issue... I don't suspect that it's my account since Test-DbaConnection localhost returns favourable results. Really excited to try this, but I cannot seem to get started since this error just simply won't go away :)