![visual studio server explorer sql express visual studio server explorer sql express](https://www.snel.com/wp-content/uploads/screenshot-hv01.snel_.com_8006-2020.09.17-12_29_48-700x523.png)
You’ll note you’ve been returned to the Add Connection dialog. I entered a weak password for this demo so I could show you the dialog, so to move things along I’ll click Yes to continue with the password I entered. If this were a production system I would absolutely click No, and go enter a much more complex password.
![visual studio server explorer sql express visual studio server explorer sql express](https://asp.mvc-tutorial.com/Images/ArticleImages/9/working-with-databases/view_sql_server_object_explorer.png)
What it’s simply letting you know is that your password is not very secure. Note if you use a very simple password, as I did for this example (I picked arcanecode as the password) you may get an error dialog. Note this is your chance to encrypt the database, as I mentioned I always click this ON. Now you’ve got everything filled out, just click the “Create” button.Ī new dialog will appear. However, you can select not to do so if you want. It makes them more secure, and adding a password will also allow you to encrypt the database to keep it safe from prying eyes. I always create my databases with a password.
![visual studio server explorer sql express visual studio server explorer sql express](https://voiceofthedba.files.wordpress.com/2018/09/2018-09-18-20_20_30-sqlbuilds-microsoft-visual-studio_thumb.png)
On the next screen, make sure the Data source is set to the “Microsoft SQL Server 2005 Compact Edition (.NET Framework Data Provider for SQL Server CE)”, if not click the Change button to launch a dialog where you can select it.įor Data Source make sure My Computer is picked, then enter the directory and path where you want your database stored. Note do NOT pick the Create New SQL Server Database… option, this works with full blown SQL Server such as SQL Server Express, not SSCE. Now right Click on Data Connections, and pick “Add Connection…”. First, if Server Explorer is not visible select View, Server Explorer from the menu. Instead, you can create the SSCE database right from within Visual Studio 2005. For example, if you will be deploying the database with your app, it’s not really necessary to write the code to create it. While it’s great for your app to be able to be able to create its own database(s), it’s not always necessary.
#VISUAL STUDIO SERVER EXPLORER SQL EXPRESS HOW TO#
In the past I showed how to create a new SQL Server Compact Edition (SSCE) database using code.