gil shimer Posted February 3, 2013 Share Posted February 3, 2013 Hi,I've been working with both Jasper Server & iReport with SqlServer 2008 - all good I moved on to SqlServer 2012 with same connection string - but I'm getting: Exception Message: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "PromisecDB" requested by the login. The login failed.Level: SEVEREStack Trace:Cannot open database "PromisecDB" requested by the login. The login failed. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246) ... java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Any ideas?Should I change the JDBC, I'm using microsoft (sqljdbc4.jar)? Link to comment Share on other sites More sharing options...
oesina Posted February 5, 2013 Share Posted February 5, 2013 I understand this error comes from JasperReports Server? Is your iReport working fine?First check all the user rights to access your DB. Link to comment Share on other sites More sharing options...
Solution gil shimer Posted February 5, 2013 Author Solution Share Posted February 5, 2013 The problem was the Fire Wall Thanks Link to comment Share on other sites More sharing options...
gil shimer Posted February 7, 2013 Author Share Posted February 7, 2013 both the iReport and the site works fine, the problem was the fire wall Link to comment Share on other sites More sharing options...
oesina Posted February 7, 2013 Share Posted February 7, 2013 Thanks Gil for update, happy it's solved! 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