Viewing 15 posts - 526 through 540 (of 6,105 total)
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...
July 16, 2009 at 7:39 am
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...
July 16, 2009 at 7:36 am
It'll likely be in a previously recorded event from the same SPID.
July 16, 2009 at 7:34 am
james.menke (7/16/2009)
I had the same exact issue as listed in this forum.
I changed the SQL Service to run as a domain administrator...
July 16, 2009 at 7:30 am
Carlton Leach (6/25/2009)
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...
July 16, 2009 at 7:29 am
Was it working before? If so, did anything like a domain switch or anything of that sort occur?
July 15, 2009 at 1:59 pm
Add a CInt() around the expression. Also, are you putting the expression in the correct place? See:
July 15, 2009 at 1:58 pm
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...
July 15, 2009 at 1:52 pm
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....
July 15, 2009 at 1:51 pm
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?
July 15, 2009 at 1:47 pm
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 -...
July 14, 2009 at 12:53 pm
sho (7/13/2009)
wow - quick response 🙂thanks!
think i'll have to look into "ownership chaining" but if you have any good links to this feel free to pass them on.
cheers brian!
An intro...
July 14, 2009 at 12:50 pm
syed muhammad naveed (7/14/2009)
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...
July 14, 2009 at 12:46 pm
eduardo.pin (7/14/2009)
3) Run -- GRANT CONTROL SERVER TO "my login" for each user that you want to grant rights in the server.
We have seen this issue when a Windows user...
July 14, 2009 at 12:43 pm
Yes, if you have taken advantage of ownership chaining.
July 13, 2009 at 11:24 am
Viewing 15 posts - 526 through 540 (of 6,105 total)