Web Service accessing SqlServer WAS: SqlCommandBuilder

Along the same lines, I am building a prototype web service that uses our
DAL (remoted assembly hosted by IIS) to query sql server.  The web service
is on my local machine, sql server and the DAL are on our server.

I keep getting a sql server exception like "Access denied..." from our DAL
when using the DAL from the web service.

I recall from playing with .NET web services 2 years (I have not touched
them since) ago that the ASPNET account needs to see sql server.  How do I
do this?



-----Original Message-----
From: Discussion forum for developers using Windows Forms to build apps
and controls [mailto:DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx]On Behalf Of
Beauchemin, Bob
Sent: Wednesday, February 25, 2004 11:05 AM
To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
Subject: Re: [DOTNET-WINFORMS] SqlCommandBuilder


Have a look at SQL profiler and see what its doing. It's listed in my
book and, IIRC offhand its:

SET FMTONLY ON        -- do not return results, only metadata
SET NOBROWSETABLE ON  -- use "browsetable" format to return additional

                      -- metadata, but don't use a physical browse table
SELECT....            -- execute query

SqlCommandBuilder is public, but sealed/NotInheritable

Cheers,
Bob Beauchemin
http://staff.develop.com/bobb


-----Original Message-----
From: Discussion forum for developers using Windows Forms to build apps
and controls [mailto:DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx] On Behalf Of
Vince P
Sent: Wednesday, February 25, 2004 7:37 AM
To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
Subject: Re: [DOTNET-WINFORMS] SqlCommandBuilder

Unless you're telling me to go to the connection to get the error
information :)


___________
Vince P  http://66.93.114.145/vince/

MSN Messenger: this address
AIM: pacelvi

"Nobody said it'd be easy. Nobody said that it would be this hard." -
Coldplay


-----Original Message-----
From: Discussion forum for developers using Windows Forms to build apps
and
controls [mailto:DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx] On Behalf Of Vince
P
Sent: Wednesday, 25 February, 2004 09:32
To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
Subject: Re: [DOTNET-WINFORMS] SqlCommandBuilder

I know what my connection string is.. I'm using Integrated Security. I
didn't' anticipate/(think through) that it (is probably) going directly
to
the tables to get parameter information on  a SP... It must be going to
a
system table or my user tables... All of which the general users have no
access to.





___________
Vince P  http://66.93.114.145/vince/

MSN Messenger: this address
AIM: pacelvi

"Nobody said it'd be easy. Nobody said that it would be this hard." -
Coldplay


-----Original Message-----
From: Discussion forum for developers using Windows Forms to build apps
and
controls [mailto:DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx] On Behalf Of Adam
Straughan
Sent: Wednesday, 25 February, 2004 09:04
To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
Subject: Re: [DOTNET-WINFORMS] SqlCommandBuilder

You need to look at the SqlConnection object, which is where the users
connection security is setup via the connection string.

adam

> -----Original Message-----
> From: Vince P [mailto:pacelvi@xxxxxxxxxxxxx]
> Sent: 25 February 2004 15:15
> To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
> Subject: [DOTNET-WINFORMS] SqlCommandBuilder
>
> One of my WinForms is throw up errors about Dynamic SQL not
> being authorized on users who aren't DB Admins.
>
> This particular WinForm uses a class in my data tier that
> uses a SqlCommandBuilder to retreive SqlParameters of a
> SqlDataAdapter (of a Stored
> Procedure)  (note: the form and data tier are running user's
> box, the DB itself is remote)
>
> I'm going to work under the assumption the SqlCommandBuilder
> is using the User's Windows identity to run some Sql against
> the DB tables, and since those users don't have table access,
> the error is being thrown.
>
>
>
> ___________
> Vince P  http://66.93.114.145/vince/
>
> MSN Messenger: this address
> AIM: pacelvi
>
> "Nobody said it'd be easy. Nobody said that it would be this
> hard." - Coldplay
>