Tag Archives: SQLServer

An error was reported when Java connected to SQL server. Sqljdbc could not be found_ auth.dll

Geeks, please accept the hero post of 2021 Microsoft x Intel hacking contest>>>

Recently, I am studying Java connection to sqlserver2008. But I always report an error: failed to load the sqljdbc_ auth.dll cause : no sqljdbc_ auth in java.library.path。

Environment: Windows 7 + Tomcat + JDK1.8 + Maven.
after a search, it is found that the domestic Baidu result is to add sqljdbc to java.library.path_ Auth.dll file. Or put it under system 32 stackoverflow problem:( http://stackoverflow.com/questions/15844875/jdbc-intellij-failed-to-load-the-sqljdbc-auth-dll )
Microsoft note 1: https://msdn.microsoft.com/zh-cn/library/gg558122.aspx )
Microsoft note 2: https://msdn.microsoft.com/zh-cn/library/ms378428.aspx# China (Simplified Chinese))
according to the above explanation, I used the following connection string and it passed
jdbc:sqlserver ://192.168.1.10:1433; DatabaseName=master; authenticationScheme=JavaKerberos;

Thoughts:

The people of our country don’t really understand. There are just a few words of copy and paste everywhere. It leads to a very poor understanding of the problem. It seems that English needs special attention in the future

[Five Methods] SqlServer_ View SQL server version information

Method 1

Execute SQL statement

SELECT @@VERSION

Method 2

Connect to SQL Server Management Studio and use the main version number information displayed by object explorer to display the current instance product version number 11.0.6020

Method 3

Look at the agent log

Method 4

In SQL Server Management Studio, by executing [sys]. [XP]_ Msver] to get the version number information

[sys].[xp_msver]

Method 5

SELECT   
 SERVERPROPERTY('servername') AS 实例名,  
 SERVERPROPERTY('ProductVersion') AS 实例版本,  
 SERVERPROPERTY('Edition') AS 产品版本,  
 SERVERPROPERTY('ProductLevel') AS 版本级别,  
 @@VERSION AS 版本信息