Android应用连接本地SQL Server报错，无法写入数据求助

Hey there! Let's break down the common issues that might be blocking your Android app from connecting to your local SQL Server and writing data. Since you mentioned you already have the try database and login table set up, let's start with the most likely culprits:

Local SQL Server instances often default to only accepting connections from the same machine. Here's how to open it up for your Android device:

• Open SQL Server Configuration Manager, navigate to SQL Server Network Configuration > [Your Instance Name] > TCP/IP, and enable it.
• Double-click TCP/IP, go to the IP Addresses tab, scroll to IPAll, and set the TCP port to 1433 (the default SQL Server port; note it if you use a custom one).
• Restart the SQL Server service to apply changes.
• Add an inbound rule to your Windows Firewall allowing TCP traffic on port 1433 (or your custom port) so your Android device can reach the server.
• Pro tip: Make sure your Android device and computer are on the same WiFi network first—cross-network connections need extra port forwarding setup.

Your JDBC connection string is critical; small errors here will break the connection. A correct format looks like this:

String connectionUrl = "jdbc:sqlserver://[YOUR_PC_LOCAL_IP]:1433;databaseName=try;user=[SQL_LOGIN_NAME];password=[LOGIN_PASSWORD];encrypt=true;trustServerCertificate=true;";

Key things to check:

• Use your computer's local LAN IP (e.g., 192.168.1.100) instead of localhost or 127.0.0.1—those point to the Android device itself, not your PC.
• Ensure you're using SQL Server Authentication (not just Windows Auth) and that your login has read/write permissions for the try database. Also, enable mixed-mode authentication in SQL Server settings.
• The encrypt=true;trustServerCertificate=true; flags are mandatory for modern JDBC drivers—they skip strict certificate checks for local testing.

Make sure you're using a compatible, up-to-date Microsoft JDBC Driver for SQL Server in your Android project:

• If you're using Gradle, add this dependency to your app-level build.gradle file (match the driver version to your project's JRE version):

  implementation 'com.microsoft.sqlserver:mssql-jdbc:12.4.0.jre11'
  

• Avoid outdated drivers—they might not support modern Android SDK versions or SQL Server features.

Android blocks network operations on the main thread, and you need explicit permission to access the internet:

• Add the internet permission to your AndroidManifest.xml:

  <uses-permission android:name="android.permission.INTERNET" />
  

• Run all database connection/write code on a background thread (use Kotlin Coroutines, AsyncTask, or a dedicated repository layer). For example, a simple Coroutine implementation:

  fun insertToLogin(username: String, password: String) = CoroutineScope(Dispatchers.IO).launch {
      val connectionUrl = "jdbc:sqlserver://192.168.1.100:1433;databaseName=try;user=sa;password=MyStrongPassword;encrypt=true;trustServerCertificate=true;"
      try {
          Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")
          val connection = DriverManager.getConnection(connectionUrl)
          val insertQuery = "INSERT INTO login (username, password) VALUES (?, ?)"
          val stmt = connection.prepareStatement(insertQuery)
          stmt.setString(1, username)
          stmt.setString(2, password)
          val rowsInserted = stmt.executeUpdate()
          if (rowsInserted > 0) {
              // Success! Switch back to main thread to update UI if needed
              withContext(Dispatchers.Main) {
                  // Show success message
              }
          }
          // Clean up resources
          stmt.close()
          connection.close()
      } catch (e: Exception) {
          e.printStackTrace() // Check Logcat for exact error details
          withContext(Dispatchers.Main) {
              // Show error message to user
          }
      }
  }
  

The "无法获取写入输出" message is vague—pull the full error stack trace from Android Studio's Logcat. Common errors include:

• NetworkOnMainThreadException: You're running network code on the main thread (fix with background threads).
• SQLException: Login failed for user 'xxx': Wrong credentials or insufficient permissions.
• SocketTimeoutException: Network connection is blocked (check firewall/IP settings).

If you still hit a wall, share the exact Logcat error message and your connection code snippet—we can narrow it down further!

内容的提问来源于stack exchange，提问作者Aakash Jain