I am trying to create a Service-Based Database inside the Visual Studio project, but keep getting error indicating the certificate chain was issued by an authority that is not trusted.

You asked the same question on Dec 29, learn.microsoft.com/en-us/answers/questions/5684868/i-am-trying-to-create-a-service-based-database-ins, and I explained why you got this error, and you accepted my answer.

I also said that when it comes to the exact steps in Visual Studio, I don’t know, since I don’t use Visual Studio (and I am not all familiar with the concept of “service-based database”). What I do know – or rather what I am convinced of – is that Visual Studio offers you the possibility to configure the connection string, and you need to find out where this is.

If you want help with that, you should probably ask with a Visual Studio tag. Your question should probably go something like this:

I am trying to add a Service-based database using the Visual Studio 2026 IDE by selecting:

Add/New Item/Service-based Database

I keep getting this message:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate was issued by an authority that is not trusted.)

I understand that this is because that connections now defaults to require encryption, and I need to activate the setting Trust Server Certificate, but I have not been able to find out how I do that.