Reconnect to SQL server with SSMS

See more:

SQL

server

SSMS

Hi Friends,

I have a strange situation. I have a database server with SQL Server 2017 and upgraded it today to SQL Server 2019 (I need the String_Split function). On my DB server nothing changed I can do everything with SSMS. In the sql server config manager all protocols are enabled.

On my work machine I could connect to the db server with the sa account, but since the update to SQL Server 2019 my login via SSMS is refused.

If I start Visual Studio projects for web api's. I run them with F5 using the SA account without any problem.

What in SSMS is stopping me?

What I have tried:

- Tried via network in explorer and (re)set the network visibility option
- in VS2022 no problem in connecting to the db
- Azure studio cannot connect
- SSMS cannot connect