Re: Web Service accessing SqlServer WAS: SqlCo mmandBuilder

In SqlServer, open the database your trying to access and the add ASPNET
with access to your database with the Users node under the database.


Jeff Block


-----Original Message-----
From: Greg Robinson [mailto:greg@xxxxxxxxxx]
Sent: Wednesday, February 25, 2004 1:23 PM
To: DOTNET-WINFORMS@xxxxxxxxxxxxxxxxxxx
Subject: [DOTNET-WINFORMS] 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
>


**********************************************************************
PLEASE NOTE: The above email address has recently changed from a previous 
naming standard -- if this does not match your records, please update them to 
use this new name in future email addressed to this individual.

This message and any attachments are intended for the
individual or entity named above. If you are not the intended
recipient, please do not forward, copy, print, use or disclose this
communication to others; also please notify the sender by
replying to this message, and then delete it from your system.

The Timken Company
**********************************************************************