Hi all
I've just started working in a company who haven't had a database administrator in a very long time, therefore I am starting to use tools that haven't been used before. It's an incredibly frustrating experience, especially given that our network support aren't being every helpful. I would be grateful for any advice or recommendations so I can go back to our network support and tell them exactly what they need to be doing to resolve this. We are on v11.
My first problem is the Web Report Server - it's intermittently working. When running a SSRS report via Tessitura, the user is asked for their login details. When you log in you get an error message - our network support say it's me but other users are experiencing the same problem:
Exception of type 'System.Web.HttpUnhandledException' was thrown.There was an error processing this request. Please check the details below.The authentication token is not valid. Please retry with a valid token.
My next problem is the below error message. This appears when I try to run a new SSRS custom report. I know there is something wrong with the dataset (I don't know exactly what because I can't access the error logs) but I get this error message when first opening the report - any ideas:
Thanking everyone in advance
This may or may not be helpful, but I think you may need to sit down with your network people and figure out exactly who is responsible for what, when it comes to application configuration and support. I'm the sole DBA for my organization, and my network guys' jobs are done when the servers are running and backed up, and the IPs and domain names are pointing to the right place. Everything beyond that, from installing the server applications to getting the client to run on a staff machine, is essentially on me, and so I have a level of access to those servers that allows me to do my job.
Someone may be able to chime in with a "to solve your problem do x" answer, but ultimately if there's an organizational issue here causing "not my job" syndrome, your efforts spent solving that problem will yield results far more valuable.
Thanks Nick.
I've already had that discussion with them. Unfortunately this is all their job, they're not open to me having that type of access - it's an external company we use. It's under discussion, internally.