thx everyone.

Happy Turkey.

It doesn't seem to be accurate.

I think it is the version of BCP. I locally run BCP -V on 2 SQL boxes with different patched; both give...

thx guys.

will pass this to the developers.

I think it won't hurt anything if I re-apply SP2 even it already has SP2 applied, is it correct?

IIS box doesn't have SQL server engine installed. SQL and IIS are on separate boxes.

SELECT @@VERSION will tell me the version of the SQL box that the IIS is...

Finally it works.

The developer just said it is something with the driver itself; he tried to blame me at first for the login fail error though.

Lack of T-SQL skills seen often with ASP programmers from the dot com era. Sorry if others feel ofended. I seen lot of things can be done in...

It seems easy to me in QA but not to my developers. EM is their favorite.

Thanks.

In BOL search for "SSPI".

I ain't programmer. My developers had problem with NT authentication. Later we found the magic word.

I design DBs in SQL and use Reverse Eng. in VISIO for docs. I have both VISIO and ERwin; I perfer VISIO.

Here it is.

We are ASP, IIS, and SQL. I am SA, all developers has read and write to all tables and views. There are lookup tables for rates....

The silly thing is all programmers here prefer to use EM to update the table. So they will not use SP or UPDATE statement! The table is...

Thank you for your sharing. I am very happy if there is a writen instruction or guideline made from a real DBA focusing on step by step for programmers...

Forgot to mention that this login ID has read and write permissions to the database used in the connection string.

My SQL box is at an Exodus data center. All developers are sitting at local office. So absolutely SQL must be mixed mode to authenticate the logins. ...