Error: 208, Severity: 16, State: 0

[thomas62j5]

We are running sql profiler to audit security and exceptions in sql server, and we are seeing a lot of these errors:

Error: 208, Severity: 16, State: 0

A lot of them are originating from the sourcegear client, and I was wondering if you might know why?

[ian_sg]

This error indicates a reference to an object that SQL Server can't find.

Is there any text associated with the error within profiler? Are you doing anything in particular when you see these? Does the Vault client report an error when this occurs on the server?

It would also help if you could provide the version of Vault that you're running.

Thanks.

[thomas62j5]

Is there any text associated with the error within profiler?

Nope.

Are you doing anything in particular when you see these?

It is hard to tell, because we are constantly tracing, and then the next day I go in and check the data, and that is when I see a lot of these.

Does the Vault client report an error when this occurs on the server?

I have not seen any errors from vault, at least not any that would correlate to the # of times this error is showing up.

It would also help if you could provide the version of Vault that you're running.

We are currently running 3.0.4 and 3.0.5 clients against a 3.0.4 server. I will upgrade the server and clients to the latest version today though.

[ian_sg]

With the profiler client, are you connecting to SQL Server using an administrative account? It sounds like it may actually be that profiler itself is unable to find certain SQL Server objects, and that's where the errors are coming from.

[thomas62j5]

The profiler is actually created from the sa account, so I think it should work ok. I will check on that aspect.