Thank you!

Thank you, I do use windows mode for now.

Another question related with this, even sa account is disabled, I can still change a db owner to sa from a...

if we migrate to R2, do we need to have SQL server R2 developer edition in order to develop SSIS?

Will 2008 version SSIS package still work on R2 SSIS?

Thanks

Thank you, I tried it , it works fine although the table is big.

For the other post who asks me if I can combine them together, my answer is...

Thanks a lot, I found it.

It is SharePoint Timer Service.

It use this users login to connect to SQL server.

And after I disable the service, then it works fine now....

Thank you, I found the PID, but in the application server, task manager, how can I find out a processID number?

Thanks

Thanks all,

Yes, this articel would be...

But I can browse from SSMS to see those online databases .mdf files, but just cannot see those detached databases' .mdf files.

And I can see all of them are there...

I did a profiler trace, this time only trace failed login, I caught this user name there.

The application name doesn't tell me much, it just said .netsqlclientdataprovidor

database is master.

So...

I login to the application server, I cannot find what application is trying to connect to this sql server.

and I see in this SQl server windows event viewer, security, there...

Thanks, all,

will give a try. Yes, the table and columns name are fake. I just want to make it easier to demonstrate.

Thanks

I will check the calling server, and see if I can find something, and will post back

Thanks for the help

Is there a way to stop this alert and error?

Thanks

I run profile and add those columns, but in the login column, in the trace I cannot see the user name for this particular user.

Thanks, I found the IP address, it should be right after the client.

I found the server name, will check into it.

Thanks,

Also is there a way that I can find out...