Cannot open SQL DB request for this login. (System.Data.SqlClient.SqlException)

Hi guys,

Everything seems to be fine, can browse the DB from VS, Preview data works fine in dataset, and the page works fine before adding any SQL DB code.

I draged n dropped a new DropDownList, Bind it to an object from dataset. And when I want to run the page I get this error !!!

I appreciate any help.

Thanks,
Mehdi

Can you provide us more details about your problem.|||

Do you have ASPNET user login created for your database with rights to access it? when you run VS studio it access database as you, web page access database as ASPNET so it has to have at least rights to read from your table and execute stored procedures if you have any.

Thanks

|||

How can I add the ASP.NET user to my database.

I remember I didn't have to do anything manualy on my PC at home and I didn't have this problem.

I think myself it is also matter of in what order you install, Visual Studio, IIS, MSDE

But how can I register ASP user to my database now ?

|||

Hi,

You need to connect to the SQL Server instance from VS IDE. Add ASPNET user to the logins and grant it proper permissions.