Solved

SQL server error when trying to connect to sql server.

Posted on 2016-09-14
4
64 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 33

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 12

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 28

Expert Comment

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

Author Closing Comment

by:vbnetcoder
ID: 41820315
ty
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

816 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

11 Experts available now in Live!

Get 1:1 Help Now