playground:playground
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| playground:playground [2024/01/26 11:34] – [Set up Microsoft SQL Server Connection] amyw | playground:playground [2024/01/26 11:36] (current) – [Troubleshooting] amyw | ||
|---|---|---|---|
| Line 10: | Line 10: | ||
| - | ===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 21: | 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==== | + | |
| + | |||
| + | |||
playground/playground.1706286868.txt.gz · Last modified: by amyw
