Solved

SQL server error when trying to connect to sql server.

Posted on 2016-09-14
4
50 Views
Last Modified: 2016-09-28
Could anybody explain what the issue is?  

[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource Server1JDBCConnections:ServerConnection.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource Server1JDBCConnections:ServerConnection.
[ADA.1.204] Cannot connect to the database with DataSource class "com.microsoft.jdbcx.sqlserver.SQLServerDataSource".
[Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.
0
Comment
Question by:vbnetcoder
4 Comments
 
LVL 32

Accepted Solution

by:
ste5an earned 500 total points
ID: 41798014
The requested instance is either invalid or not running.

When your SQL Server instance is running, check whether it is a named instance, then you need either SQL Server Browser running or a fixed IP. Also check your network connection from your machine to SQL Server, especially are there any FW involved?

And last but not least, check your configuration data for e.g. spelling errors.
0
 
LVL 11

Expert Comment

by:Nakul Vachhrajani
ID: 41798023
The requested instance is either invalid or not running

It  looks like the SQL Server instance is down/not accessible. Are other users/systems able to connect to the server successfully?
0
 
LVL 18

Expert Comment

by:Pawan Kumar Khowal
ID: 41798145
Are u able to ping the DB server ?
0
 

Author Closing Comment

by:vbnetcoder
ID: 41820315
ty
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now