Hello,

I am new to Sql Express. (2022)

So I have a few questions that would help me along, thank you.

I am programming in Visual Studio 2022.

1. Is it imperitive that I use SQL Server Management Studio to create MDF in SQLEXPRESS DATABASE ENGINE? OR, just use VS2022?

2. Do I need to utilise SQL Server Management Studio to create a Report Server Project (and have ‘report run’ feature functionality) OR, just use Visual Studio 2022? 

3. Do I need to ‘buy’ a Server Certificate?

I have been using localdb and creating reports using a Report Server Project. But of course I can not get them to run under localdb. I have read and tried everything that I can. Besides creating a SqlExpress database server, I only managed to allow open the correct port in Microsoft Firewall Defender. Regarding permissions, certificates ect…, I am lost.

Any help and guidance is appreciated.

Many thanks,

Shane1961

​ Hello, I am new to Sql Express. (2022) So I have a few questions that would help me along, thank you. I am programming in Visual Studio 2022. 1. Is it imperitive that I use SQL Server Management Studio to create MDF in SQLEXPRESS DATABASE ENGINE? OR, just use VS2022? 2. Do I need to utilise SQL Server Management Studio to create a Report Server Project (and have ‘report run’ feature functionality) OR, just use Visual Studio 2022?  3. Do I need to ‘buy’ a Server Certificate? I have been using localdb and creating reports using a Report Server Project. But of course I can not get them to run under localdb. I have read and tried everything that I can. Besides creating a SqlExpress database server, I only managed to allow open the correct port in Microsoft Firewall Defender. Regarding permissions, certificates ect…, I am lost. Any help and guidance is appreciated. Many thanks, Shane1961  Read More

​