The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
The Microsoft SQL Server 2000 driver for JDBC does not support connecting by using Windows NT authentication. You must set the authentication mode of your SQL Server to Mixed mode, which permits both Windows Authentication and SQL Server Authentication.
<operator name="DatabaseExampleSource" class="DatabaseExampleSource"> <parameter key="database_system" value="Microsoft SQL Server (Microsoft)"/> <parameter key="database_url" value="jdbc:sqlserver://MYSERVER;integratedSecurity=true"/> <parameter key="username" value="not_a_real_username"/> <parameter key="password" value="nkZ10Qek8Qw="/> <parameter key="query" value="select * from mytable"/></operator>
ratheesan wrote:Hi Keith,Where you mentioned the name of database such as master,northwind ...in this url "jdbc:sqlserver://MYSERVER;integratedSecurity=true"ThanksRatheesan
jdbc:sqlserver://MYSERVER;integratedSecurity=true;databaseName=mydatabase
keith wrote:I'm not certain why you're getting the error. A couple of things that might be affecting it are:1) Is your SQL Server install configured to user Windows authentication?2) Is sqljdbc_auth.dll in the Windows system directrory, or a directory listed in the PATH environment variable on the client?3) Are you connecting from a non-Windows client?Beyond those suggestions, you'll need to consult the Microsoft JDBC or SQL Server documentation.
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
Join us for a community conversation to explore how different modeling approaches in Simcenter PSIM can help engineers simulate power electronics systems while balancing accuracy, simulation speed, and design insight. What you'll learn: Power transistor modeling : Thermal and high fidelity models Protection component…