ADO.NET help - Filling a DataGrid with contents of a DataSet

[thebison]

Hi,

As a relative newbie to SQL Server/ASP.NET I'm hoping someone here
can help with my problem. I'm developing a timesheet application in
ASP.NET C# using Visual Studio 2003 with a database built in MSDE.
One of my forms needs to return a simple list of resources from my
database. I have followed the guide on the MSDN libraries, but for
some reason I continuously get the same error message.

What I've done so far is Create the database, tables, and populate
with some sample data using using Server Explorer in Visual Studio. I
have
connected to the database (using integrated security) and I am
trying to get the contents of the Resource table to appear on my
form. I have then created a DataAdapter (tested the connection, set
the SQL as a simple SELECT * from Resource, etc), which also generates
an sqlConnection for me. To test this I have previewed the generated
data, and it returns what I want, so I
have chosen to generate a DataSet of this (dsResource). I am then
trying to get
this data into a simple DataGrid. On the properties of the DataGrid
I have changed the DataSource to point at my Dataset. As I
understand it, I then have to add the following to my Page Load
section of my code.

sqlConnection1.Open();
this.sqlDataAdapter1.Fill(this.dsResource);
sqlConnection1.Close();

The form builds fine, but when I browse to the particular form I get
the following error for the sqlConnection1.Open(); line

Exception Details: System.Data.SqlClient.SqlException: Cannot open
database requested in login 'SCMS'. Login fails. Login failed for
user 'AL-NOTEPAD\ASPNET'.

To me this is an error with my connection string. My database
instance is actually 'AL-NOTEPAD\VSDOTNET'. However the properties
for sqlConnection1 are pointing to the correct datasource. I do not
know why the application is looking for user 'AL-NOTEPAD\ASPNET'. It
does not exist, to my knowledge.

Any help with this would be greatly appreciated, as I get the same
error with my code for forms-based login...


Thanks in advance..

 

[Terry Burns]

Yeah, You need to open up enterprise manager for the SQL Server and add your
ASPNET account to the database your are trying to connect to.

HTH

 

[Otis Mukinfus]

On 4 Feb 2006 07:22:41 -0800, "thebison"

[snip]

Exception Details: System.Data.SqlClient.SqlException: Cannot open
database requested in login 'SCMS'. Login fails. Login failed for
user 'AL-NOTEPAD\ASPNET'.

To me this is an error with my connection string. My database
instance is actually 'AL-NOTEPAD\VSDOTNET'. However the properties
for sqlConnection1 are pointing to the correct datasource. I do not
know why the application is looking for user 'AL-NOTEPAD\ASPNET'. It
does not exist, to my knowledge.

Check your web folder's user permissions in IIS. It looks to me as
though you have your web site anonymous user set to ASPNET and you
haven't given that user permissions on your database.

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com

 

[thebison]

Hi Terry, thanks for replying so promptly.

A quick question, as my DB is going to be fairly small and is more a
prototype application, I am using MSDE and only have that installed.
This does not come with enterprise manager. Can i get hold of this
seperately, or do you know of another way I can add the ASPNET account
to the database?

Thanks again..

 

[thebison]

Otis,

Thanks for replying, as I'm still quite new to Visual Studio and
ASP.NET, how do I check the webfolder's user permissions in IIS?

Regards

Al

 

[Otis Mukinfus]

Otis,

Thanks for replying, as I'm still quite new to Visual Studio and
ASP.NET, how do I check the webfolder's user permissions in IIS?

Regards

Al

1. Right Click on the "My Computer" icon on your desk top or in the
menu
2. From the resulting context menu, choose "Manage"
3. When the "Computer Management" window appears, click the plus sign
on "Services and Applications"
4. Click the plus on "Internet Information Services"
5. Open the "Web Sites" folder and the "Default Web Sites" folder.
6. Choose you web site from the web sites shown by right clicking it
and choose "Properties" from the context menu.
7. Click the "Directory Security" tab, then click the "Edit" button.
8. There are two possibilities here... You may see that the anonymous
user is set to "IUSR_YOURMACHINENAME" or "ASPNET".

Which ever of the settings you see there is the user your database
must have a logon for. In your case it appears that you will find it
to be "ASPNET".

Set the permissions on your database objects accordingly...


Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com

 

[Guest]

In web application, when you use integrated security connection, you are
using ASPNET account.

You can change in Framework machine.config

from
userName="machine" // ASPNET
to
userName="SYSTEM" // localsystem (high privilege admin)

HTH

Elton Wang

 

[dehranph]

hello thebison,

it seems to me that you are experiencing problem with the database
permissions you have on your sql server. This happens because ASPNET,
which is the default user account for your ASP.NET application, donot
have access permission to the database you are using.

If you have Enterprise Manager installed on your machine, you must
assign access permission to ASPNET account. Under Security folder,
Select New Login, browser for ASPNET account. Assign the database
VSDOTNET to ASPNET account.

b regards

rodel e. dagumampan
filipino c#/.net developer
http://community.devpinoy.org/blogs/dehranph

 

[thebison]

Hi everyone,

Thanks for all the help, I've sorted the problem in the short term by
downloading an MSDE alternative to Enterprise Manager
(http://www.asql.biz/DbaMgr.shtm) and assigned the relevant access to
the ASPNET user account. The DataGrid now works.

Thanks again

Al

 

[dehranph]

great!

also, SQL 2005 Express is a full featured and worth looking into. Its
free and support larger space.

b regards

rodel e. dagumampan
filipino c#/.net developer
http://community.devpinoy.org/blogs/dehranph