JDBC with SQLserver – Connection refused: connect

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

If you are trying to use SQLserver with InfoCaptor and are using the SQL Studio Express 2005 then you might encounter connection refused error

Please try the following setup before attempting to connect

open the Configuration Manager
Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

Image

2. Then at the left hand tree. Select SQL Server 2005 Network Configuration-> Protocol for SQLEXPRESS-> TCP/IP

Image

3. Right click and enable it.

Image

4. A window box appear on double click the TCP/IP. Click on the “IP Addresses” Tab

Image

5. Set the TCP Port value to 1433 then click apply

6. Then at the left hand tree. Select SQL Server 2005 Services -> SQL Server (SQLEXPRESS) -> right click and restart.

Image

 

Now go back to InfoCaptor connection wizard and enter the connection details

Image

 

Where “rudrasoft” is the PC name where SQL server is installed. So use the appropriate name for your installation

If you go to your SQL Server Studio, you will see the name before the backslash

 

Image

The port is 1433 which we entered in the TCP/IP port settings

and the database is “Adventureworks”

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH