Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
playground:playground [2024/01/26 10:34] amyw [Installing Microsoft SQL Server Express] |
playground:playground [2024/01/26 10:36] (current) amyw [Troubleshooting] |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| - | ====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=== | ||
| - | MIStudio connects a database using TCP/IP, making sure the database has TCP/IP enabled. | ||
| - | |||
| - | **To check if TCP/IP is enabled** | ||
| - | 1. Open the SQL Server Configuration Manager from Start > All Programs > Microsoft SQL Server Version # > Configuration Tools > SQL Server Configuration Manager.The Sql Server Configuration Manager window is displayed. | ||
| | | ||
| Line 23: | Line 16: | ||
| - | ===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==== | + | |
| + | |||
| + | |||