Problem connecting to SQL Server 2005 developer edtion from JRun 3.1

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.
sriniramAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rboyd56Commented:
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
Mayank SAssociate Director - Product EngineeringCommented:
>> 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
Mayank SAssociate Director - Product EngineeringCommented:
>> 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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

sriniramAuthor Commented:
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
sriniramAuthor Commented:
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
Mayank SAssociate Director - Product EngineeringCommented:
>> 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
Mayank SAssociate Director - Product EngineeringCommented:
>> I created the JDBC driver but still the connectivity is not taking place.

Did you add it to JRun's classpath?
0
sriniramAuthor Commented:
I reinstalled everything and it is working fine.

Thanks for the support.
Sri
0
sriniramAuthor Commented:
This problem is being solved by re-installing the sql server.

I request the moderator to close this item.

Thanks
Sri
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java App Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.