October 15, 2010 at 10:41 am
I've given some production engineers the same access rights to a database on my SQL 2000 server as i have;(public, db_owner, datareader, datawriter) and they're saying some days they can edit their procedures and some days they can't. They're using Access 2003 as thier tool to write/edit/run their stored procedures/queries. Since they have the same access rights as me why would their permissions disappear/re-appear? All i can think of is that it has to do with them using Access 2003 as i always use the admin console to do this stuff. Any suggestions? I would prefer not to install the admin console on their pc as that would give them full access to all of the DB's i have on their.
Thank you,
MH
October 15, 2010 at 10:53 am
I'd need to know what kind of credentials they are using, and how those are managed, before I could even begin to answer this. Are they using SQL logins, or domain accounts, or local server accounts?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 15, 2010 at 10:59 am
they are using domain accounts.
October 15, 2010 at 11:22 am
Then I've seen that behavior before. The computer with Access on it is probably losing its domain credentials for whatever reason. Possibly a network issue, possibly something with overnight processes on the server. I've seen it be an intermittent problem with up to 25 workstations, all with Access on them, all using domain credentials.
If they're up for it, ipconfig can usually fix it. If they're not up to that, logout-login will usually do it. Reboot is sometimes easier for the non-IT pro.
Have them try that, see if it helps.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 15, 2010 at 11:39 am
Thanks GSquared i'll have them try that.
Do you know if this problem disappears when the backend is SQL2008? I'm working on upgrading our sql2000 server to sql 2008 std.
October 15, 2010 at 1:04 pm
No clue. The company I ran into it at went out of business in 2007. No clue what happens with 2008.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply