IIS 6.0 as Web Server
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?