jcarter_2 Posted October 27, 2023 Share Posted October 27, 2023 host name with a slash gives error, host name = svr01SQLexpress URL = jdbc:sqlserver://svr01SQLexpress:1433;databaseName=masterdBeaver and Azure data studio are ok with the url, is there a workaround to for Jaspersoft server to connect to this DB Link to comment Share on other sites More sharing options...
Mehak Rajkumar Posted October 31, 2023 Share Posted October 31, 2023 Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times. Link to comment Share on other sites More sharing options...
Badr Draifi Posted October 31, 2023 Share Posted October 31, 2023 Hi, this will probably be driver dependent, can you try accessing your database this way: "jdbc:sqlserver://localhost/master;instance=SQLexpress". Also, try using our shipped tibco software sqldriver. If none of the above works, please send the version of sqlserver jdbc driver you're using and the error log file. Link to comment Share on other sites More sharing options...
jcarter_2 Posted October 31, 2023 Author Share Posted October 31, 2023 Thanks for your replycorrected sever name -> mht01I tried adding the ';instance=SQLEXPRESS' at the end of the url , same error message(jdbc:sqlserver://mht01:1433;databaseName=master;instance=SQLEXPRESSwhere is this driver -> ' try using our shipped tibco software sqldriverwhere is the log?driver I'm using is below... Link to comment Share on other sites More sharing options...
Badr Draifi Posted November 27, 2023 Share Posted November 27, 2023 Please try this one instead as mentioned in my last comment : "jdbc:sqlserver://mht01:1433/master;instance=SQLexpress" If it didn't work, please review: I can't see the version and name of your driver from your last message. Please check if the driver you're using is actually supported in the community platform supported documentation here based on your version. tibco software sqldriver is shipped with the source code, only available for commercial edition This is where to get the log files: Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now