kamxpert Posted June 21, 2014 Share Posted June 21, 2014 Dear Friends,I want to connect ireport with SQL Server. I am using version 4.5 of i report.I am trying but unable to connect. following steps i m taking.1. Database JDBC connection.2.JDBC Driver-----> MS SQL Server(2005) .....3. Server address ----> localhost4. database----->SQLSERVER5.then username and passwordwhen i clink on test button it gives below error.SQL problems: Cannot open database "SQL SERVER" requested by the login. The login failed.jdbc:sqlserver://192.168.0.6:1433;databaseName=SQL SERVER Please resolve the issue. i will be thankful Regards, Link to comment Share on other sites More sharing options...
adan.ribeiro Posted June 21, 2014 Share Posted June 21, 2014 I supposed you are in a local station traying to connect yout database, aren't you?If so, certify your server is online.Paste your code here and, if you can, paste your form's code too. Usually this kind of problem tendency to relate to sintax errors. Link to comment Share on other sites More sharing options...
hozawa Posted June 23, 2014 Share Posted June 23, 2014 >4. database----->SQLSERVER>databaseName=SQL SERVERSeems you've inserted a space in database name. 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