DbFit-SqlServer Connection : Login failed for user 'DEV\abc'. ClientConnectionId:a12f7cab-7261-4fa7-8064-ea355f03f883

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

DbFit-SqlServer Connection : Login failed for user 'DEV\abc'. ClientConnectionId:a12f7cab-7261-4fa7-8064-ea355f03f883

FitNesse mailing list
Hello Friends,
 

 I am newbie to fitnesse dbfit, i am trying to connect to sql server and getting below error:

 

 com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'DEV\abc'. ClientConnectionId:a12f7cab-7261-4fa7-8064-ea355f03f883
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:208)
    at dbfit.api.AbstractDbEnvironment.connect(AbstractDbEnvironment.java:51)
    at dbfit.environment.SqlServerEnvironment.connect(SqlServerEnvironment.java:53)
    at dbfit.api.AbstractDbEnvironment.connect(AbstractDbEnvironment.java:78)
    at dbfit.fixture.DatabaseEnvironment.connect(DatabaseEnvironment.java:52)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at fitlibrary.closure.MethodClosure.invoke(MethodClosure.java:35)
    at fitlibrary.closure.MethodClosure.invokeTyped(MethodClosure.java:28)
    at fitlibrary.closure.CalledMethodTarget.invokeTyped(CalledMethodTarget.java:77)
    at fitlibrary.closure.CalledMethodTarget.invokeTyped(CalledMethodTarget.java:95)
    at fitlibrary.closure.CalledMethodTarget.invokeAndWrap(CalledMethodTarget.java:358)
    at fitlibrary.traverse.workflow.caller.ActionCaller.run(ActionCaller.java:37)
    at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretRow(DoTraverseInterpreter.java:176)
    at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretAfterFirstRow(DoTraverseInterpreter.java:66)
    at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretInFlow(DoTraverseInterpreter.java:151)
    at fitlibrary.DoFixture.interpretAfterFirstRow(DoFixture.java:47)
    at fitlibrary.FitLibraryFixture.doTable(FitLibraryFixture.java:83)
    at dbfit.fixture.DatabaseEnvironment.doTable(DatabaseEnvironment.java:22)
    at fit.Fixture.interpretFollowingTables(Fixture.java:121)
    at fit.Fixture.interpretTables(Fixture.java:107)
    at fit.Fixture.doTables(Fixture.java:81)
    at fit.FitServer.process(FitServer.java:81)
    at fit.FitServer.run(FitServer.java:56)
    at fit.FitServer.main(FitServer.java:41)

 

 

 Can you please help?
 

 Thanks

Reply | Threaded
Open this post in threaded view
|

Re: DbFit-SqlServer Connection : Login failed for user 'DEV\abc'. ClientConnectionId:a12f7cab-7261-4fa7-8064-ea355f03f883

FitNesse mailing list
Resolved:
I missed below step:

(http://dbfit.github.io/dbfit/docs/database-specific-information.html#microsoft-sql-server)
Microsoft SQL Server

Deploying the JDBC Driver

    Download MS SQL Server JDBC driver from their site (It is not open source and cannot be distributed with DbFit.)
    Deploy sqljdbc4.jar in DbFit’s lib folder - the same folder as dbfit-XXX.jar.
    Deploy auth\x86\sqljdbc_auth.dll in %programfiles(x86)%\Java\jre7\bin folder to allow integrated windows authentication

Then use connetion as

!|DatabaseEnvironment|sqlserver|
|Connect|jdbc:sqlserver://myhost;integratedSecurity=true|

and it worked.
 

    On Friday, 27 May 2016, 0:59, "[hidden email] [fitnesse]" <[hidden email]> wrote:
 

     Hello Friends,
I am newbie to fitnesse dbfit, i am trying to connect to sql server and getting below error:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'DEV\abc'. ClientConnectionId:a12f7cab-7261-4fa7-8064-ea355f03f883
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:208)
    at dbfit.api.AbstractDbEnvironment.connect(AbstractDbEnvironment.java:51)
    at dbfit.environment.SqlServerEnvironment.connect(SqlServerEnvironment.java:53)
    at dbfit.api.AbstractDbEnvironment.connect(AbstractDbEnvironment.java:78)
    at dbfit.fixture.DatabaseEnvironment.connect(DatabaseEnvironment.java:52)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:497)
    at fitlibrary.closure.MethodClosure.invoke(MethodClosure.java:35)
    at fitlibrary.closure.MethodClosure.invokeTyped(MethodClosure.java:28)
    at fitlibrary.closure.CalledMethodTarget.invokeTyped(CalledMethodTarget.java:77)
    at fitlibrary.closure.CalledMethodTarget.invokeTyped(CalledMethodTarget.java:95)
    at fitlibrary.closure.CalledMethodTarget.invokeAndWrap(CalledMethodTarget.java:358)
    at fitlibrary.traverse.workflow.caller.ActionCaller.run(ActionCaller.java:37)
    at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretRow(DoTraverseInterpreter.java:176)
    at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretAfterFirstRow(DoTraverseInterpreter.java:66)
    at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretInFlow(DoTraverseInterpreter.java:151)
    at fitlibrary.DoFixture.interpretAfterFirstRow(DoFixture.java:47)
    at fitlibrary.FitLibraryFixture.doTable(FitLibraryFixture.java:83)
    at dbfit.fixture.DatabaseEnvironment.doTable(DatabaseEnvironment.java:22)
    at fit.Fixture.interpretFollowingTables(Fixture.java:121)
    at fit.Fixture.interpretTables(Fixture.java:107)
    at fit.Fixture.doTables(Fixture.java:81)
    at fit.FitServer.process(FitServer.java:81)
    at fit.FitServer.run(FitServer.java:56)
    at fit.FitServer.main(FitServer.java:41)


Can you please help?
Thanks
  #yiv8864694250 #yiv8864694250 -- #yiv8864694250ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8864694250 #yiv8864694250ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8864694250 #yiv8864694250ygrp-mkp #yiv8864694250hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8864694250 #yiv8864694250ygrp-mkp #yiv8864694250ads {margin-bottom:10px;}#yiv8864694250 #yiv8864694250ygrp-mkp .yiv8864694250ad {padding:0 0;}#yiv8864694250 #yiv8864694250ygrp-mkp .yiv8864694250ad p {margin:0;}#yiv8864694250 #yiv8864694250ygrp-mkp .yiv8864694250ad a {color:#0000ff;text-decoration:none;}#yiv8864694250 #yiv8864694250ygrp-sponsor #yiv8864694250ygrp-lc {font-family:Arial;}#yiv8864694250 #yiv8864694250ygrp-sponsor #yiv8864694250ygrp-lc #yiv8864694250hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8864694250 #yiv8864694250ygrp-sponsor #yiv8864694250ygrp-lc .yiv8864694250ad {margin-bottom:10px;padding:0 0;}#yiv8864694250 #yiv8864694250actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8864694250 #yiv8864694250activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8864694250 #yiv8864694250activity span {font-weight:700;}#yiv8864694250 #yiv8864694250activity span:first-child {text-transform:uppercase;}#yiv8864694250 #yiv8864694250activity span a {color:#5085b6;text-decoration:none;}#yiv8864694250 #yiv8864694250activity span span {color:#ff7900;}#yiv8864694250 #yiv8864694250activity span .yiv8864694250underline {text-decoration:underline;}#yiv8864694250 .yiv8864694250attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8864694250 .yiv8864694250attach div a {text-decoration:none;}#yiv8864694250 .yiv8864694250attach img {border:none;padding-right:5px;}#yiv8864694250 .yiv8864694250attach label {display:block;margin-bottom:5px;}#yiv8864694250 .yiv8864694250attach label a {text-decoration:none;}#yiv8864694250 blockquote {margin:0 0 0 4px;}#yiv8864694250 .yiv8864694250bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8864694250 .yiv8864694250bold a {text-decoration:none;}#yiv8864694250 dd.yiv8864694250last p a {font-family:Verdana;font-weight:700;}#yiv8864694250 dd.yiv8864694250last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8864694250 dd.yiv8864694250last p span.yiv8864694250yshortcuts {margin-right:0;}#yiv8864694250 div.yiv8864694250attach-table div div a {text-decoration:none;}#yiv8864694250 div.yiv8864694250attach-table {width:400px;}#yiv8864694250 div.yiv8864694250file-title a, #yiv8864694250 div.yiv8864694250file-title a:active, #yiv8864694250 div.yiv8864694250file-title a:hover, #yiv8864694250 div.yiv8864694250file-title a:visited {text-decoration:none;}#yiv8864694250 div.yiv8864694250photo-title a, #yiv8864694250 div.yiv8864694250photo-title a:active, #yiv8864694250 div.yiv8864694250photo-title a:hover, #yiv8864694250 div.yiv8864694250photo-title a:visited {text-decoration:none;}#yiv8864694250 div#yiv8864694250ygrp-mlmsg #yiv8864694250ygrp-msg p a span.yiv8864694250yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8864694250 .yiv8864694250green {color:#628c2a;}#yiv8864694250 .yiv8864694250MsoNormal {margin:0 0 0 0;}#yiv8864694250 o {font-size:0;}#yiv8864694250 #yiv8864694250photos div {float:left;width:72px;}#yiv8864694250 #yiv8864694250photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8864694250 #yiv8864694250photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8864694250 #yiv8864694250reco-category {font-size:77%;}#yiv8864694250 #yiv8864694250reco-desc {font-size:77%;}#yiv8864694250 .yiv8864694250replbq {margin:4px;}#yiv8864694250 #yiv8864694250ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8864694250 #yiv8864694250ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8864694250 #yiv8864694250ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8864694250 #yiv8864694250ygrp-mlmsg select, #yiv8864694250 input, #yiv8864694250 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8864694250 #yiv8864694250ygrp-mlmsg pre, #yiv8864694250 code {font:115% monospace;}#yiv8864694250 #yiv8864694250ygrp-mlmsg * {line-height:1.22em;}#yiv8864694250 #yiv8864694250ygrp-mlmsg #yiv8864694250logo {padding-bottom:10px;}#yiv8864694250 #yiv8864694250ygrp-msg p a {font-family:Verdana;}#yiv8864694250 #yiv8864694250ygrp-msg p#yiv8864694250attach-count span {color:#1E66AE;font-weight:700;}#yiv8864694250 #yiv8864694250ygrp-reco #yiv8864694250reco-head {color:#ff7900;font-weight:700;}#yiv8864694250 #yiv8864694250ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8864694250 #yiv8864694250ygrp-sponsor #yiv8864694250ov li a {font-size:130%;text-decoration:none;}#yiv8864694250 #yiv8864694250ygrp-sponsor #yiv8864694250ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8864694250 #yiv8864694250ygrp-sponsor #yiv8864694250ov ul {margin:0;padding:0 0 0 8px;}#yiv8864694250 #yiv8864694250ygrp-text {font-family:Georgia;}#yiv8864694250 #yiv8864694250ygrp-text p {margin:0 0 1em 0;}#yiv8864694250 #yiv8864694250ygrp-text tt {font-size:120%;}#yiv8864694250 #yiv8864694250ygrp-vital ul li:last-child {border-right:none !important;}#yiv8864694250