{"id":169,"date":"2012-01-27T07:51:04","date_gmt":"2012-01-27T07:51:04","guid":{"rendered":"http:\/\/blog.aceplaza.com\/?p=169"},"modified":"2012-01-27T07:51:04","modified_gmt":"2012-01-27T07:51:04","slug":"sql-developer-data-modeler-3-1-connection-to-sql-server-2008-using-microsoft-jdbc-driver","status":"publish","type":"post","link":"https:\/\/blog.aceplaza.com\/?p=169","title":{"rendered":"SQL Developer Data Modeler 3.1 Connection to SQL Server 2008 using Microsoft JDBC Driver"},"content":{"rendered":"<p>First, download the <a title=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?displaylang=en&amp;id=21599\" href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?displaylang=en&amp;id=21599\" target=\"_blank\">Microsoft JDBC driver<\/a>.<\/p>\n<p>Once extracted, I copied the sqljdbc4.jar file into the lib folder under the jdbc folder of the SQL Developer Data Modeler but you just need to know where the jar file is located.<br \/>\nGo to Tools &gt; Preferences &gt; Data Modeler &gt; Third Party JDBC Drivers and click the plus to add the location of the jar file. Then click the OK button.<br \/>\nIf on a Windows machine and you want to use integrated security, edit your system path to include the location of the sqljdbc_auth.dll file or copy the sqljdbc_auth.dll to an existing location in your system path, like Windows\\System32.<br \/>\nThen click File &gt; Import &gt; Data Dictionary.<br \/>\nClick the Add button.<br \/>\nClick the JDBC tab<br \/>\nChoose Other ThirdParty Driver<br \/>\nFor JDBC URL, type jdbc:sqlserver:\/\/[serverName[\\instanceName][:portNumber]][;property=value[;property=value] &#8211; or look <a title=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms378428%28v=sql.100%29.aspx\" href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms378428%28v=sql.100%29.aspx\" target=\"_blank\">here<\/a> for details about how to form the URL.<br \/>\nFor Driver Class, type com.microsoft.sqlserver.jdbc.SQLServerDriver<br \/>\nFor Database Type, choose SQL Server.<\/p>\n<p>Assuming your URL is correct, click the test button and you should get success.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First, download the Microsoft JDBC driver. Once extracted, I copied the sqljdbc4.jar file into the lib folder under the jdbc folder of the SQL Developer Data Modeler but you just need to know where the jar file is located. Go to Tools &gt; Preferences &gt; Data Modeler &gt; Third Party JDBC Drivers and click the &hellip; <a href=\"https:\/\/blog.aceplaza.com\/?p=169\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SQL Developer Data Modeler 3.1 Connection to SQL Server 2008 using Microsoft JDBC Driver<\/span><\/a><\/p>\n","protected":false},"author":721,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[20],"class_list":["post-169","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql"],"_links":{"self":[{"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=\/wp\/v2\/posts\/169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=\/wp\/v2\/users\/721"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=169"}],"version-history":[{"count":2,"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=\/wp\/v2\/posts\/169\/revisions"}],"predecessor-version":[{"id":171,"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=\/wp\/v2\/posts\/169\/revisions\/171"}],"wp:attachment":[{"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.aceplaza.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}