Solved

Problem connecting to SQL Server 2005 developer edtion from JRun 3.1

Posted on 2007-03-29
9
289 Views
Last Modified: 2013-12-02
Environment:

IIS 6.0 as Web Server
ASP
JRUN 3.1 as App Server
SQL Server 2005

We are using an ASP application for the authentication and Java / JRUN 3.1 for reporting application.

I have a problem in connecting to the SQL Server 2005 from the Java (XSLT) code. This works fine when I use SQL Server 2005 standard edition (a copy of production). But when I try with the developer edition of SQL Server 2005, on my local machine (which I will be using temporarily), it is not connecting to the database. The error I am getting is "<message><![CDATA[Opening DB Connection develsql Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver URL: jdbc:microsoft:sqlserver://SERVERNAME:1433;DatabaseName=DBNAME]]></message>".

Using the database parameters like server name, database name, user name and password, in Microsoft SQL Server Management Studio, I am able to connect.

The developer edition should be same as enterprise edition and it should have all the features of the standard edition.

Can someone suggest what I need to look into or whether I need to install any JDBC drivers?

Thanks
Sri.
0
Comment
Question by:sriniram
  • 4
  • 4
9 Comments
 
LVL 16

Expert Comment

by:rboyd56
Comment Utility
You are right there is not difference between the Standard Edition and Developer in this respect.

This is just a shot in the dark but have you enabled TCP/IP and named pipes, using the SQL Server Configuration Tool, on the developer instance?
0
 
LVL 30

Expert Comment

by:mayankeagle
Comment Utility
>> This is just a shot in the dark but have you enabled TCP/IP

That's could be missing is what is my guess too
0
 
LVL 30

Expert Comment

by:mayankeagle
Comment Utility
>> whether I need to install any JDBC drivers?

Not if you are using this one:

http://www.microsoft.com/downloads/details.aspx?familyid=6d483869-816a-44cb-9787-a866235efc7c&displaylang=en
0
 

Author Comment

by:sriniram
Comment Utility
Generally I will not install any JDBC driver separately. It works when I use the standard edition (copy of productiion).

I have the productiion environments with standard edition and developer edition. How I can check whether the JDBC driver is installed?

I think I have enabled the TCP/IP and names pipes. When I configure theh ODBC data source, I can see both of these enabled. Is there any other way I can check these?

Thanks
Sri
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:sriniram
Comment Utility
Using the the link you gave, I created the JDBC driver but still the connectivity is not taking place. I removed the developer edition  and installed the standard edition of SQL Server 2005 and it works fine even without the JDBC driver.

Then again i reverted back tot developer edition of SQL Server 2005, I am getting the same problem.

The error is:

<message><![CDATA[Opening DB Connection develsql Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver URL: jdbc:microsoft:sqlserver://ServerName:1433;DatabaseName=dbName]]></message>
</entry><entry><date>30 Mar 2007 10:51:19,906</date><priority>ERROR</priority><ndc></ndc><thread>jcp-0</thread><category>com.JLT.embryo.embryoSql</category><location>com. JLT. embryo.embryoSql.buildDOMfromSQL (embryoSql.java:202)</location>
<message><![CDATA[A SQL Exception occurred ([Microsoft][SQLServer JDBC Driver]Error establishing socket.), the SQL was getReportList 'P123456', '8%0A'  ]]></message>
</entry><entry><date>30 Mar 2007 10:51:19,906</date><priority>ERROR</priority><ndc></ndc><thread>jcp-0</thread><category>com.JLT.embryo.embryoSql</category><location>com.JLT.embryo.embryoSql.buildDOMfromSQL (embryoSql.java:203)</location>
<message><![CDATA[Stack Trace: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.

Any suggestions plesae?

Thanks
Sri
0
 
LVL 30

Expert Comment

by:mayankeagle
Comment Utility
>> I will not install any JDBC driver separately

You need to install the correct JDBC driver for the database.

>> it works fine even without the JDBC driver.

Then JRun already has a JDBC driver.

>> Any suggestions plesae?

Did you check if TCP/ IP is enabled on the DB?
0
 
LVL 30

Expert Comment

by:mayankeagle
Comment Utility
>> I created the JDBC driver but still the connectivity is not taking place.

Did you add it to JRun's classpath?
0
 

Author Comment

by:sriniram
Comment Utility
I reinstalled everything and it is working fine.

Thanks for the support.
Sri
0
 

Accepted Solution

by:
sriniram earned 0 total points
Comment Utility
This problem is being solved by re-installing the sql server.

I request the moderator to close this item.

Thanks
Sri
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
In this article I will describe the Backup & Restore 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.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

772 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

12 Experts available now in Live!

Get 1:1 Help Now