Which version of SQL to install?

[Vighnesh Mu]

Hi,

I want to develop a java based web application in my system and planning to use MS SQL 2008 as back end(to be installed on the same system). But I am not sure which edition of MS SQL to use, can anybody tell me do I need to install "developer edition" or "express edition" or "standard edition" or other?
I tried installing "developer edition" and it got installed too, but I am unable to connect to DB because of some access related errors. I used "SQL Authentication" but didn't know the server name, user ID and password and also the port number needed to connect, somebody please help me on this. What will be the url for DB to connect through java if the database is installed on the same machine?

Thanks in advance.

[Paul Sturrock]

All should work - the licencing of some editions prevent them being used for production, but to develop against any is fine.

I used "SQL Authentication" but didn't know the server name, user ID and password and also the port number needed to connect, somebody please help me on this. What will be the url for DB to connect through java if the database is installed on the same machine?

Your driver documentation will cover this - without knowing which driver you are using, I can't say.

[Vighnesh Mu]

Paul Sturrock wrote:All should work - the licencing of some editions prevent them being used for production, but to develop against any is fine.

Thanks for the information paul, so can I go with any edition for my application?

Paul Sturrock wrote:Your driver documentation will cover this - without knowing which driver you are using, I can't say.

I didn't get this part, where can I get driver documentation? I am using MS SQL 2008 version.

[Paul Sturrock]

For developing yes, for production, no.

I didn't get this part, where can I get driver documentation? I am using MS SQL 2008 version.

I'm going to guess you mean the Microsoft supplied JDBC driver? In which case MSDN will have the online instructions, but I think you also get the help files installed when you install it (this suggests you do anyway).

[Vighnesh Mu]

Paul Sturrock wrote:For developing yes, for production, no.

For production which is the edition I need to use?

Paul Sturrock wrote:
I'm going to guess you mean the Microsoft supplied JDBC driver? In which case MSDN will have the online instructions, but I think you also get the help files installed when you install it (this suggests you do anyway).

I am planning to use "jtds" driver in java to connect to database using JDBC ,as per my requirement. But it needs url(containing DB location,port and driver), username and password to connect to the the database installed in my system. I am unable to find them. can you please suggest me where can I get these from SQL installation?

Thanks.

[Paul Sturrock]

Standard or Enterprise I think. Check with Microsoft.

jTDS have an extensive FAQ section that document all the stuff you need to know. See their web site.

[Vighnesh Mu]

Thanks a lot Paul.