####Update SDE Files using TLS Security for SQL Server
import os
import operator
import arcpy
dbloc = r"D:\MapsandGeodatabases\dbconnects/"
dblist = os.listdir(dbloc)
dblocnew=r"D:\MapsandGeodatabases\newdbconnects/"
user='xxx'
passw='xxx'
for dbl in dblist:
if '.sde' in dbl:
try:
desc = arcpy.Describe(dbloc + dbl)
cp = desc.connectionProperties
cpdb = cp.database
inst = cp.instance[+14:]
enco = ";Encrypt=yes;TrustServerCertificate=yes"
arcpy.management.CreateDatabaseConnection(
out_folder_path=dblocnew,
out_name=dbl,
database_platform="SQL_SERVER",
instance=inst+enco,
account_authentication="DATABASE_AUTH",
username=user,
password=passw,
save_user_pass="SAVE_USERNAME",
database=cpdb,
schema="",
version_type="BRANCH",
version="",
date=None,
auth_type="",
project_id="",
default_dataset="",
refresh_token='',
key_file=None,
role="",
warehouse="",
advanced_options=""
)
print(arcpy.GetMessages())
except Exception as e:
print(f"issue with sde connection file {dbl}: {str(e)}")
continue