Thank you.

Error:18456. severity:14, State:16

Thank you very much, I will try that.

Thank you very much, will change to small date time to store the birthdate.

Thanks, in the application log, I found there is msinstaller that tried to apply windows update Sql server sp3, and book online, for some reason it failed.

I don't need sp3...

Thanks

Thanks a lot

It works great.

Thanks

By the way is this EXcept only works in SQL?

Is it working in Microsoft Access, don't think so.

If the same situation in Access, how can I do it?

Thanks

Any help Please??

Thank you for your help.

When I install the reporting service on serverA, and use the database on serverB,

What special admission I need to add for the database or the installation process will automatically add...

No body can connect to it.

It caused the server hang.

I wonder if this is windows problem or others.

But once I cannot connect to reporting service then the whole server...

The problem I can no longer connect to the reporting server on the local machine.

And I can no longer connect to the database server either on the local server.

Yes, we have iis installed on the server.

Thanks a lot

I cannot find error message in the sql error log.

I can only see it in the event viewer.

The error is in the previous message

Thank you.

I'm glad it can still be backed up on F drive. But still I feel strange why the administrators cannot access E:\program files\microsoft sql server\MsSql.1\mssql\backup

I thought administor account should...