471,893 Members | 1,819 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 2324
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 zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.