kubrakaradirek
67 lines
2.5 KiB
Bash
67 lines
2.5 KiB
Bash
# MSSQL Connection Configuration Template
|
|
#
|
|
# Copy this file to .env and fill in your actual values
|
|
# DO NOT commit the .env file to version control!
|
|
|
|
# ============================================================================
|
|
# SQL Server Connection - Choose ONE format below:
|
|
# ============================================================================
|
|
|
|
# OPTION 1: Local named instance
|
|
MSSQL_SERVER=localhost\SQLEXPRESS
|
|
|
|
# OPTION 2: Local default instance
|
|
# MSSQL_SERVER=localhost
|
|
|
|
# OPTION 3: Remote server with default port (1433)
|
|
# MSSQL_SERVER=192.168.1.100
|
|
|
|
# OPTION 4: Remote server with custom port (comma-separated)
|
|
# MSSQL_SERVER=192.168.1.100,1433
|
|
|
|
# OPTION 5: Remote named instance
|
|
# MSSQL_SERVER=PRODUCTION-SERVER\INSTANCE01
|
|
|
|
# OPTION 6: Domain server name
|
|
# MSSQL_SERVER=sql-prod.company.com
|
|
|
|
# OPTION 7: Domain server with port
|
|
# MSSQL_SERVER=sql-prod.company.com,1433
|
|
|
|
# ============================================================================
|
|
# Database Configuration
|
|
# ============================================================================
|
|
MSSQL_DATABASE=AdenTestDB
|
|
|
|
# ============================================================================
|
|
# Authentication - Choose ONE method:
|
|
# ============================================================================
|
|
|
|
# METHOD 1: SQL Server Authentication (username/password)
|
|
# Use this for: remote servers, Linux servers, specific SQL logins
|
|
MSSQL_USERNAME=sa
|
|
MSSQL_PASSWORD=your_password_here
|
|
|
|
# METHOD 2: Windows Authentication (leave both empty)
|
|
# Use this for: local Windows servers, domain-joined environments
|
|
# MSSQL_USERNAME=
|
|
# MSSQL_PASSWORD=
|
|
|
|
# ============================================================================
|
|
# Important Notes:
|
|
# ============================================================================
|
|
# - Port format: Use comma (,) not colon - Example: server,1433
|
|
# - Named instances: Use backslash (\) - Example: SERVER\INSTANCE
|
|
# - Default port: 1433 (can be omitted if using default)
|
|
# - ODBC Driver: Requires "ODBC Driver 17 for SQL Server" or newer
|
|
# - Security: Never commit this file with real credentials!
|
|
# - Escaping: In some shells, escape backslashes (\\) when setting env vars
|
|
# ============================================================================
|
|
|
|
# Example Production Configurations:
|
|
# -----------------------------------
|
|
# Azure SQL: MSSQL_SERVER=yourserver.database.windows.net
|
|
# AWS RDS: MSSQL_SERVER=yourinstance.region.rds.amazonaws.com,1433
|
|
# Docker: MSSQL_SERVER=localhost,1401
|
|
# Kubernetes: MSSQL_SERVER=mssql-service.namespace.svc.cluster.local,1433
|