469,106 Members | 2,353 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

problem with database connectivity

I am using java applications to connect to my MS SQL Server database.
I am using ODBC for database connectivity.
If i am running my java applications in a remote PC and try to connect
to database server, unless i login to the
serer, i am unable to connect to database.
If a login to database server with it's username and password, then
the database is getting connected.

It is not correct to login to database server for database
connectivity.
what is the solution for this?
Jul 20 '05 #1
1 2239
ha*******@yahoo.com (harish) wrote in message news:<ff**************************@posting.google. com>...
I am using java applications to connect to my MS SQL Server database.
I am using ODBC for database connectivity.
If i am running my java applications in a remote PC and try to connect
to database server, unless i login to the
serer, i am unable to connect to database.
If a login to database server with it's username and password, then
the database is getting connected.

It is not correct to login to database server for database
connectivity.
what is the solution for this?


I'm not sure that I understand your question - do you mean that you
can only connect to MSSQL with Windows authentication, but you want to
use a SQL login? Or that you have to connect to Windows (eg. connect
to a file share) before you can connect to MSSQL?

Whatever the issue, it would be helpful if you could provide some
extra information - what version of MSSQL, what operating system on
the server and client, what authentication mode (Windows only or
Windows + SQL), how you want to connect (Windows account or SQL
login), what error you see when you try to connect etc.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by junaid | last post: by
3 posts views Thread by Niks | last post: by
reply views Thread by C Newby | last post: by
47 posts views Thread by Ivan Weiss | last post: by
22 posts views Thread by b_r | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.