problem when connectiong to database



Hi,


I try to make a connection with the database "test" contained in sql server
express 2005.

This is the connection string in the aspx file:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="Provider=SQLOLEDB;Data

Source=laptop\sqlexpress;Integrated Security=SSPI;Initial Catalog=test"
ProviderName="System.Data.OleDb" SelectCommand="SELECT * FROM
[mytable]"></asp:SqlDataSource>

Sql server express is installed with Windows authentification.

When runing the aspx page, i get: "Cannot open database "test" requested by
the login. The login failed"

I suppose the account ASPNET (machine account used for asp.net pages) has
not the right permissions.
So i started my "Sql server Management Studio Express", selected the
database "test" and went to the property "permissions".
There, i tried to add a user by clicking on button ADD: in the following
window, i can introduce the new user, but it refused all

of them (ASPNET, ASP.NET Machine account ...), even my administrator account
"Bart" is not recognized.


So i have two questions:

1)is the error due not enough permissions (of account ASPNET)?
2) if yes, how to give it the right permissions (write)?

Thanks for help
Bart




.


Loading