problem when connectiong to database
- From: "Bart" <baa@xxxxxxx>
- Date: Thu, 22 Mar 2007 17:29:29 +0100
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
.
- Follow-Ups:
- Re: problem when connectiong to database
- From: William \(Bill\) Vaughn
- Re: problem when connectiong to database
- From: Russell Fields
- Re: problem when connectiong to database
- Prev by Date: Re: Cannot connect to SQL Server 2005
- Next by Date: Re: equivalent of "load data local infile" of Mysql?
- Previous by thread: SQLAGENT Started and Stopped
- Next by thread: Re: problem when connectiong to database
- Index(es):
Loading