You're biggest concerns are:

- The web server gets hacked and the database gets exploited (and potentially the SQL Server). The way to reduce this impact is to restrict the permissions...

If you don't give permissions, they don't have it. That's the way SQL Server works. So what you want to do is avoid the DENY and just GRANT the permissions...

It'll likely be in a previously recorded event from the same SPID.

james.menke (7/16/2009)

---

Your article tipped me off to find my solution.

I had the same exact issue as listed in this forum.

I changed the SQL Service to run as a domain administrator...

Carlton Leach (6/25/2009)

---

Hi Brian,

Further to this article: what services are required to be running on the SQL server?

I presume Kerberos Key Distribution Centre service has to be activated on...

Was it working before? If so, did anything like a domain switch or anything of that sort occur?

Add a CInt() around the expression. Also, are you putting the expression in the correct place? See:

Books Online: Expression Examples - Page Breaks

Not the account you want to use, but the account you are logged on as. You are performing an operation that requires as least Power User rights on all the...

Just to clarify, having administrative rights on the operating system does not guarantee that you'll have admin rights over the Analysis Services server. I'm guessing that's not the issue here....

More detail is definitely needed. In addition to the questions asked:

- How is the app connecting to the database?

- What types of access do end users have?

SQL Server's security model is rather simple: if you aren't given specific rights to do something, you can't do it. This takes care of #3. As for the rest.

#1 -...

An intro...

syed muhammad naveed (7/14/2009)

---

Hi,

while i am trying to regester my branch machine with my server

it showing this error message.

"Login Failed for user null not associated with trusted sql server...

We have seen this issue when a Windows user...

Yes, if you have taken advantage of ownership chaining.