How to Log in to MS-SQL server 2008

[Pallab Bhattacharya]

Hi,

I am running a MS SQL server 2008, and want to connect from same system, can anyone please help me with the JDBC URL string and which .jar files needs to added in Drivers tab ?

Also want to know how to get the database name.

Current configuration is "windows authentication mode" and it works perfectly fine with Management studio.

Regards,
Pallab

[Takis Diakoumis]

hi

try the free jtds driver from here:

http://jtds.sourceforge.net/

the docs here http://jtds.sourceforge.net/faq.html include some info on uses windows authentication.

perhaps just enter details in the JDBC URL field on the connection tab only after setting up the driver.

for example:

jdbc:jtds:sqlserver://[host]:[port]/[database];domain=[windows-auth-domain]

substituting the correct relevant values.

let me know how you go.

thanks

Takis

--
You received this message because you are subscribed to the Google Groups "Execute Query" group.
To unsubscribe from this group and stop receiving emails from it, send an email to executequery...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

http://executequery.org

[Pallab Bhattacharya]

Hi Takis,

Thanks for quick reply, it worked !! Thanks for providing the pointers :)

Regards,
PAllab