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.

36 comments :

  1. 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
  2. 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

  3. 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
  4. 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
  5. Excellent post! keep sharing such a informative post.
    spring training in chennai

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

    ReplyDelete
  7. 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
  8. 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
  9. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Best Java Training Institute Chennai

    ReplyDelete
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. Very interesting content which helps me to get the indepth knowledge about the technology. To know more details about the course visit this website.
    Digital Marketing Training in Chennai
    JAVA Training in Chennai
    core Java training in chennai
    Big Data Training in Chennai
    Hadoop Training in Chennai

    ReplyDelete
  17. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Tours and Travels in Madurai | Best Travels in Madurai | Madurai Travels

    ReplyDelete
  18. Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information. 
    Microsoft Azure online training
    Selenium online training
    Java online training
    uipath online training
    Python online training


    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. Mutual windows hosting can be moderate and offers most extreme security by presenting to date programming choices. Windows Hosting

    ReplyDelete
  21. If AWS is a job that you're dreaming of, then we, Infycle are with you to make your dream into reality. Infycle Technologies offers the best AWS Training in Chennai, with various levels of highly demanded software courses such as Oracle, Java, Python, Hadoop, Big Data, etc., in 100% hands-on practical training with specialized tutors in the field. Along with that, the pre-interviews will be given for the candidates, so that, they can face the interviews with complete knowledge. To know more, dial 7502633633 for more.

    ReplyDelete
  22. Python Course in Chennai | Infycle Technologies

    Infycle Technologies is the best software training institute in Chennai, providing an amazing Python course in Chennai that is 200% realistic and taught by industry experts. Aside from the preparation, mock interviews will be conducted for the students so that they can confidently face the interviews. All of this will result in full placement assurance in top MNC’s Company. For queries just call 7502633633 and have a free demo with us.
    Best python Course in Chennai

    ReplyDelete
  23. This article will outline all the different strategies you should be aware of when it comes to soccer.

    Best IAS Coaching In India

    ReplyDelete
  24. Infycle Technologies, the top software training institute and placement center in Chennai offers the Digital Marketing course in Chennai for freshers, students, and tech professionals at the best offers. In addition to the Oracle training, other in-demand courses such as DevOps, Data Science, Python, Selenium, Big Data, Java, Power BI, Oracle will also be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  25. https://www.sharmaacademy.com/mppsc-notes.php
    Sharma Academy is Central Indias largest provider of Mppsc Notes and Mppsc Study Material.

    ReplyDelete
  26. If you are dreaming of an IT job !!! Then AWS Course in Chennai!!Is the best choice for you. Yes, what you heard is Right Infycle offering you an AWS course for an Affordable price with experienced trainees, Practical Classes, Flexible timing, and more.

    ReplyDelete
  27. VRay Crack For SketchUp With KeyVRay Crack For SketchUp is an amazing tool for architects and designers. You can design anything that you want with its latest features.V-Ray Serial Key

    ReplyDelete