Wednesday, May 28, 2014

Connect to SQL Server in SQL Workbench Using Integrated Windows Authentication

Just a quick note to anyone may be looking for the steps:
  1. Download Microsoft JDBC driver package from here (download the tarball package) 
  2. Unzip the package and copy sqljdbc_auth.dll simply to system32 folder or any location defined in PATH
  3. Copy sqljdbc4.jar to any location 
  4. Setup SQL Server jdbc driver in SQL Workbench, point the jar to the sqljdbc4.jar 
  5. Create a new connection using the sample URL
    jdbc:sqlserver://[hostname]:[port];integratedSecurity=true;databaseName=[database_name];  
Note: integratedSecurity=true means using windows integrated authentication The jdbc driver will try to load the sqljdbc_auth.dll in order to authenitcate the user. No username and password is reqired in connection profile as it uses windows login user.

35 comments :

  1. I agree with your thoughts!!! As the demand of java programming application keeps on increasing, there is massive demand for java professionals in software development industries. Thus, taking training will assist students to be skilled java developers in leading MNCs. Best Java Training in Chennai | JAVA Training Institutes in Chennai

    ReplyDelete
    Replies
    1. I have read your blog its very attractive and impressive. I like it your blog.


      SEO Services in India SEO Company in India SEO Company in India

      Guaranteed SEO services Guaranteed SEO

      Delete
  2. This idea is mind blowing. I think everyone should know such information like you have described on this post. Thank you for sharing this explanation.Your final conclusion was good. We are sowing seeds and need to be patiently wait till it blossoms.

    Digital marketing company in Chennai

    ReplyDelete
  3. Someone essentially lend a hand to make severely posts I would state. That is the very first time I frequented your website page and thus far? I surprised with the analysis you made to create this particular submit incredible. Fantastic job!

    Online Training in Chennai

    ReplyDelete
  4. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feelhappy about it and I love learning more about this topic
    seo company in chennai

    ReplyDelete

  5. I read a weblog, I hope that it doesnt sadden me as much as this one. I’m talking about, I know it was my selection to read, but I actually thought youd have something interesting to say. Great work admin..

    Online Training in Chennai

    ReplyDelete
  6. This blog is having the general information. Got a creative work and this is very different one. We have to develop our creativity mind. This blog helps for this. Thank you for this blog. this is very interesting and useful.
    Web Designing Training in Chennai

    ReplyDelete
  7. Great information shared in this blog. Helps in gaining concepts about new information and concepts.Awsome information provided.Very useful for the beginners.
    dot net Training in Chennai

    ReplyDelete
  8. I have read your blog its very attractive and impressive. I like it your blog.


    JavaEE Training in Chennai JavaEE Training in Chennai Core Java 8 Training in Chennai Java 8 Training in Chennai Java Online Training Java Online Training

    Java Training in Chennai Java Training in Chennai Core Java Training in Chennai Core Java Training in Chennai

    ReplyDelete
  9. Excellent post! keep sharing such a informative post.
    spring training in chennai

    ReplyDelete
  10. Excellent post! keep sharing such a informative post.
    dot net training in chennai

    ReplyDelete
  11. Thank you for sharing such a nice and interesting blog with us. Hope it might be much useful for us. keep on updating...!!
    seo company in india
    digital marketing company in india

    ReplyDelete
  12. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.

    AWS Training in Chennai

    ReplyDelete
  13. Free Flash Games happywheelsdemo.in unblocked
    happy wheels happywheelsgame.inPlay Free sudoku hearts minesweeper

    freecell spades yahtzee msn free games Play Free sudoku hearts

    minesweeper freecell spades yahtzee

    ReplyDelete
  14. Truely a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic. keep sharing your information regularly for my future reference. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.

    Laser Root Canal Treatment In Chennai

    Best Dental Clinic In Velachery

    ReplyDelete
  15. I’m not sure where you’re getting your information, but good topic. I need to spend some time learning more or understanding more. Thanks for fantastic info I was looking for this information for my mission.

    MSBI Training in Chennai

    Informatica Training in Chennai

    Dataware Housing Training in Chennai

    ReplyDelete
  16. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete
  17. Interesting blog about how to conncet sql server in sql workbench which attracted me more.Spend a worthful time.keep updating more.
    Digital marketing company in Chennai

    ReplyDelete
  18. Wonderful post.This is nice post and gives in depth information. I like to read this post because I met so many new facts about it actually. Thanks a lot
    Online Marketing Services in bangalore

    SEO Company Bangalore
    affordable seo packages india

    ReplyDelete
  19. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Best Java Training Institute Chennai

    ReplyDelete
  20. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    digital marketing training in chennai

    ReplyDelete
  21. Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written. cheap web hosting

    ReplyDelete
  22. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..

    rpa training in Chennai

    rpa training in anna nagar | rpa training in marathahalli

    rpa training in btm | rpa training in kalyan nagar

    rpa training in electronic city | rpa training in chennai

    rpa online training | selenium training in training

    ReplyDelete
  23. Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which I need, thanks to offer such a helpful information here.
    Data Science training in marathahalli
    Data Science training in btm
    Data Science training in rajaji nagar
    Data Science training in chennai
    Data Science training in kalyan nagar
    Data Science training in electronic city
    Data Science training in USA

    ReplyDelete
  24. A solid, sturdy workbench is fundamental for each carpentry workshop. Dependability is the key element for any workbench as it will straightforwardly add to your capacity to cut wood accurately and accordingly influence the whole task.Best rolling workbenches

    ReplyDelete
  25. This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
    python online training
    python training in OMR
    python training institute in chennai

    ReplyDelete
  26. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    Devops Training in pune

    ReplyDelete
  27. Data science is a fast-moving field – if you’re pursuing a data science career, or even if you’re just interested in data-related topics, you need to invest time to keep up with the trends. Following a few top blogs is a great way to stay abreast of developments in data analysis, statistical software, data visualization, and more. These AUTOMATIONMINDS bloggers consistently offer great resources and tutorials, along with opportunities to connect with and learn from other leading data science professionals.
    DATA SCIENCE training in chennai


    ReplyDelete
  28. Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.

    Best Selenium Training in Chennai | Selenium Training Institute in Chennai | Besant Technologies

    Selenium Training in Bangalore | Best Selenium Training in Bangalore

    AWS Training in Bangalore | Amazon Web Services Training in Bangalore

    ReplyDelete
  29. At this time, it seems like Word Press is the preferred blogging platform available right now. (from what I’ve read) Is that what you’re using on your blog? Great post, however, I was wondering if you could write a little more on this subject?
    safety courses in chennai

    ReplyDelete
  30. This blog is the general information for the future. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.

    Cloud Training
    Software Testing Training
    Oracle DBA Training
    Angular Training in Chennai
    This blog is the general information for the future. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.

    Cloud Training
    Software Testing Training
    Oracle DBA Training
    Angular Training in Chennai

    ReplyDelete