Microsoft SQL Server
SQL Server support with Blueprint setup, Windows sign-in, custom connection fields, and image data nodes.
Product Overview
Microsoft SQL Server gives Blueprint users setup fields for server, database, login, password, and Windows sign-in. It also supports database image workflows for projects that store textures or uploaded images in SQL Server.
Core Capabilities
Microsoft SQL Features
Blueprint Connection Setup
Fill in SQL Server connection fields directly in Blueprint, or use an advanced connection string when needed.
Windows Sign-in
Use Windows-based access when the running account already has permission for the database.
Reusable Server Settings
Store reusable SQL Server settings in a project asset for cleaner Blueprint setup.
Image Data Nodes
Upload images and read image data back as Texture2D assets through Blueprint.
Select and Update Events
Update UI and retry flows from connection, select, update, and image-result status events.
Advanced Connection Control
Use advanced fields for named servers, encryption, or custom deployment settings.
Blueprint Setup Flow
- 1Fill in the SQL Server connection fields in Blueprint.
- 2Choose SQL login or Windows sign-in.
- 3Bind connection, select, update, and image-select events.
- 4Run SQL queries, or use image nodes when working with binary image columns.
- 5Read rows, values, or image results back into your Blueprint UI.
Setup Notes
- Use image nodes when your SQL Server table stores image data.
- Use advanced connection fields only when your server setup requires them.
- Use Windows sign-in only when the running account has database permission.
Shared Database Features
Blueprint Nodes for All Databases
Use the same Blueprint-style flow to connect, check status, run queries, and close the connection.
Async Runtime Queries
Run select, insert, update, and delete SQL from gameplay or editor tools without freezing the project.
Easy Result Reading
Read query output as Blueprint-friendly rows and columns for UI tables, save data, and admin screens.
Blueprint-First Workflow
Place the actor or add the component, fill in connection fields, bind events, connect, and run queries from Blueprint.
Status Events
Show loading, success, failure, and retry states in your UI with Blueprint events.
Advanced Connection Fields
Use optional fields for SSL, timeouts, custom ports, or full connection strings when your project needs them.