java.lang.RuntimeException: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.

Apache's JIRA Issue Tracker | David Robson | 5 years ago
  1. 0

    Currently you can specify connection parameters using --connection-param-file <properties-file>. This applies the connection parameters to the connection when generating the Sqoop code - but the parameters are not passed down to the mapper. Instead of specifying a parameters file couldn't we have a comma seperated list that could be specified on the command line or in sqoop-site.xml - that way it would be easier to override the settings per job, and they would be passed down to the mappers. It would then be simple to modify DBConfiguration.getConnection to read these.

    Apache's JIRA Issue Tracker | 5 years ago | David Robson
    java.lang.RuntimeException: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.
  2. 0

    Login failure in DB Connection( Any Help Pls) | Oracle Community

    oracle.com | 11 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'integration'.
  3. 0

    Login failure in DB Connection( Any Help Pls)

    Oracle Community | 6 years ago | 639372
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'integration'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java y Sql Server

    el-hacker.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: No se pudo realizar la conexión TCP/IP al host (aqui muestra mi servidor o mi ip), puerto 1433. Error: "Connection refused: connect. Verifique las propiedades de conexión, compruebe que hay una instancia de SQL Server ejecutándose en el host y aceptando las conexiones TCP/IP en el puerto y compruebe que no hay ningún firewall bloqueando las conexiones TCP en el puerto.".
  6. 0

    Unable to connect to MSSQL Server 2012 using sqljdbc4.jar

    Stack Overflow | 3 years ago | Leejoy
    com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'admin'. ClientConnectionId:1530f396-0935-4c41-92f1-016797a65edd

  1. balintn 2 times, last 2 months ago
  2. Andreas Häber 3 times, last 1 month ago
  3. abrazeneb 35 times, last 3 months ago
47 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
  2. com.microsoft.sqlserver
    SQLServerDriver.connect
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
    2. com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
    3. com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
    4. com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
    5. com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
    7. com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
    8. com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
    9. com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
    10. com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
    11. com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
    12. com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
    13. com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
    13 frames
  3. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:582)
    2. java.sql.DriverManager.getConnection(DriverManager.java:207)
    2 frames
  4. org.apache.sqoop
    DBInputFormat.setConf
    1. org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:181)
    2. org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:187)
    3. org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:162)
    3 frames
  5. Hadoop
    ReflectionUtils.newInstance
    1. org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:70)
    2. org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:130)
    2 frames
  6. Hadoop
    JobClient$2.run
    1. org.apache.hadoop.mapred.JobClient.writeNewSplits(JobClient.java:1011)
    2. org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:1031)
    3. org.apache.hadoop.mapred.JobClient.access$600(JobClient.java:172)
    4. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:943)
    5. org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:896)
    5 frames
  7. Java RT
    Subject.doAs
    1. java.security.AccessController.doPrivileged(Native Method)
    2. javax.security.auth.Subject.doAs(Subject.java:396)
    2 frames
  8. Hadoop
    UserGroupInformation.doAs
    1. org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1332)
    1 frame
  9. Hadoop
    Job.waitForCompletion
    1. org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:896)
    2. org.apache.hadoop.mapreduce.Job.submit(Job.java:531)
    3. org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:561)
    3 frames
  10. org.apache.sqoop
    Sqoop.run
    1. org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:141)
    2. org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:202)
    3. org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:465)
    4. org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403)
    5. org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
    6. org.apache.sqoop.Sqoop.run(Sqoop.java:145)
    6 frames
  11. Hadoop
    ToolRunner.run
    1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
    1 frame
  12. org.apache.sqoop
    Sqoop.main
    1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
    2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
    3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
    4. org.apache.sqoop.Sqoop.main(Sqoop.java:238)
    4 frames
  13. com.cloudera.sqoop
    Sqoop.main
    1. com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
    1 frame