Skip to main content

Microsoft SQL Server

Prefer guided AI setup?

Instead of following these steps manually, you can use the AI Credential Assistant — describe what you want to connect and the AI will walk you through the setup step by step, tailored to your account.

Overview​

Connect your Microsoft SQL Server to Nirvai to automate database operations and data workflows.

Supported Authentication Methods​

  • Basic Auth (Username/Password)

Prerequisites​

  • Access to a SQL Server instance
  • Database credentials with appropriate permissions

Setup Instructions​

Basic Authentication​

  1. In Nirvai, go to Credentials > Add Credential
  2. Select Microsoft SQL Server
  3. Fill in the required fields:
    • Server: The SQL Server hostname or IP address
    • Database: The database name to connect to
    • Username: Your SQL Server username
    • Password: Your SQL Server password
    • Port: The server port (default: 1433)
    • Use TLS/SSL: Enable for secure connections
  4. Click Save

Connection Options​

  • Server: Can be hostname, IP, or named instance (e.g., server\instance)
  • Port: Default is 1433 for SQL Server
  • TLS: Recommended for production environments

What You Can Do​

  • Execute SQL queries
  • Insert, update, delete data
  • Run stored procedures
  • Manage tables and views
  • Perform bulk operations

Troubleshooting​

Common Issues​

  • Connection Timeout: Check firewall rules and server accessibility
  • Login Failed: Verify username, password, and user permissions
  • SSL Error: Try disabling TLS or check certificate configuration

Adapted from Microsoft documentation for Nirvai platform

Next Steps​

Got your credential? Connect it to an agent

Use the AI Tool Creator to turn this credential into agent-callable tools. Describe what your agent should be able to do and the AI investigates the API, configures the endpoints, and gives you a reviewable toolkit before saving anything.