Re: One Web Service updates SQL, another can't?
From: Steve Ricketts (steve_at_velocedge.com)
Date: 10/26/04
- Next message: Magnus Blomberg: "EXEC in stored procedure"
- Previous message: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- In reply to: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- Next in thread: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- Reply: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 26 Oct 2004 13:11:35 -0400
I'm sending raw SQL and should have told you that I was opening the database
as "sa". db_denydatawriter for sa is not checked. Does that help?
sr
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:uichWz3uEHA.2520@TK2MSFTNGP15.phx.gbl...
> Assuming that you're using raw T-SQL - not stored procs - I'd look at who
is
> a member of the db_denydatawriter role in the problem database. Another
> thing to look at is the permissions for that user in EM. That may tell
you
> if there are any explicit DENY's.
>
> --
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
>
>
> "Steve Ricketts" <steve@velocedge.com> wrote in message
> news:eZ5PcW3uEHA.3828@TK2MSFTNGP12.phx.gbl...
> I have a production and development system both running on one PC under
W2K
> with SQL7sp4. One Web Service can access and update the SQL Server 7
> database fine. Another instance of the same Web Service code, accessing a
> different, but identical database, can read but not update records. It
> seems like whichever Web Service I start first is allowed to read and
write,
> but the other has only read permissions.
>
> Is there a exclusive, read-only, permissions setting that I've missed
> somewhere? The problem is simply the second Web Service can't write to
SQL,
> but why is the big question. Any help would be greatly appreciated, I'm
> into days on this one!
>
> Thanks,
>
> Steve Ricketts
>
>
- Next message: Magnus Blomberg: "EXEC in stored procedure"
- Previous message: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- In reply to: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- Next in thread: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- Reply: Tom Moreau: "Re: One Web Service updates SQL, another can't?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
