problem with database connectivity

[harish]

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?

[Simon Hayes]

Re: problem with database connectivity

harishksh@yahoo .com (harish) wrote in message news:<ff46df6e. 0402012122.496c 63e7@posting.go ogle.com>...[color=blue]
> 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?[/color]

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