Products
Applications
Support
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
All Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Members
Automic Workload Automation
Private Community
View Only
Community Home
Threads
Library
Events
Members
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Analytics v12: how to connect to MSSQL using Windows authentication only
peter_grundler_automic
Jan 03, 2017 10:05 PM
Add the parameter integratedSecurity=true to the connection string in your file application.properties ...
Tobias_Stanzel_241
Mar 16, 2017 12:41 PM
Thanks a lot for the information
1.
Analytics v12: how to connect to MSSQL using Windows authentication only
0
Recommend
peter_grundler_automic
Posted Jan 03, 2017 10:05 PM
Reply
Reply Privately
Options Dropdown
Add the parameter
integratedSecurity=true
to the connection string in your file application.properties (similar to the JWP configuration)
Don't specify a username or password for parameters "datasource.ae.***"
Copy the file
sqljdbc_auth.dll
(part of MS JDBC download package) into any folder
Add this folder to the java library path, i.e. the start command for Analytics should look like
java.exe -Xrs -Xms512m
-Djava.library.path=C:\Automic\AutomationEngine\bin\
-jar analytics-backend.jar
Start Analytics
2.
Analytics v12: how to connect to MSSQL using Windows authentication only
0
Recommend
Tobias_Stanzel_241
Posted Mar 16, 2017 12:41 PM
Reply
Reply Privately
Options Dropdown
Thanks a lot for the information
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Copyright 2019. All rights reserved.
Powered by Higher Logic