User Tools

Site Tools


playground:playground

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
playground:playground [2024/01/26 11:34] – [Set up Microsoft SQL Server Connection] amywplayground: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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki