Forum Discussion
SQL Server Management Studio
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
1) The tool doesn't matter, bothe send plain T-SQL commands to SQL Server engine, in this case "CREATE DATABASE".
2) SSMS = "SQL Server Management Studio" is to manage SQL Server, you can not create reports with. For this you have to use Visual Studio with SSDT (SQL Server Data Tools) / SSRS (Reporting Services) extension.
3) For simple purpose you don't need a paid certificate to encrypt (SSL) connection/communication.
Even if you want to you can use on first hand a "self-sign" certificate.
4 Replies
1) The tool doesn't matter, bothe send plain T-SQL commands to SQL Server engine, in this case "CREATE DATABASE".
2) SSMS = "SQL Server Management Studio" is to manage SQL Server, you can not create reports with. For this you have to use Visual Studio with SSDT (SQL Server Data Tools) / SSRS (Reporting Services) extension.
3) For simple purpose you don't need a paid certificate to encrypt (SSL) connection/communication.
Even if you want to you can use on first hand a "self-sign" certificate.
olafhelper Thank you. I thought (hoped) that. It is just that I have had no luck in VS2022 getting a thorough connection. If its not the port, its the certificate, or something else. I will persist. Thank you again Olaf, appreciated.
- Do you get an error message regarding SSL/encryption?
Then add the parameter "Encrypt=false" to the connection string to surpress it.
