Differences

This shows you the differences between two versions of the page.

--- playground:playground [2024/01/25 14:57] – [Set up Microsoft SQL Server Connection] amyw
+++ playground:playground [2024/01/26 11:36] (current) – [Troubleshooting] amyw
@@ Line 1: / Line 1: @@
-====== Connecting to Microsoft SQL Server Express  Database on Windows from MIStudio ======
+======Playground======
-====Overview====
-This page details steps to configure a connection to a SQL Server Express database on windows10 from MIStudio.
-====Installing Microsoft SQL Server Express====
-Download and install Microsoft SQL Server Express:
-[[https://go.microsoft.com/fwlink/p/?linkid=2216019&clcid=0x409&culture=en-us&country=us]]
-On the finish screen, you will be asked to install Microsoft SQL Server Management Studio (SSMS), continue the process and install it. Or you can install SSMS from the Windows "Start” menu afterwards. Go to  Start > All Programs > Microsoft SQL Server Version # > SQL Server Installation Center,  select “Install SQL Server Management Studio” link to install.
-====Set up Microsoft SQL Server Connection====
-Microsoft SQL Server Express needs to have correct settings and parameters for successful connection.
-===1: Make Sure the Database has TCP/IP Enabled===
-===2: Make Sure Microsoft SQL Server Browser is Running===
-===3: Make sure SQL Authentication is Enabled to Allow Remote Connection===
-===4.  Add Login and User to the Database===
-==== Connect to SQL Server Express database with JDBC Driver in MIStudio====
-====Troubleshooting====