Data Deploy using Windows Authentication!! Urgent!!

Hi,

I have done data deploy using sql authentication but now i have a requirement to do the same data deploy using windows authentication. Could anyone help me out in this????

Regards,

Uday

Find more posts tagged with

Comments

moonkhanna

Could you please explain your requirement in more detail? I do not think, it is possible to do a data deployment using windows authentication but you can workarround depending on your requirement

nbwoven

The driver thats shipped with the product is written completley in Java and therefore platform independent (type 4 driver), that is why it can't read the current NT session account and thus can only connect with a SQL Server login user "sa".

If you want use "Windows NT authentication" with the OOB driver, then you need to use named pipes without a username and password . This should work with SQL Server 7.0 or higher and from a windows client only.

fbousqu

I think SQL Server Window Authentification is only possible from a trusted client, that means a server member of the domain.