Access databases using ADO.Net

Hi
I am using Visual Studio.Net 2003 and SQL 2000
Web applications run using the ASPNET user account.

I have to set up this account and grant it permissions before my Web application will have access to a SQL database.
How do I grant permissions ?.

There are two permissions in SQL Server the Database permissions in the database and the Server permissions under security in Enterprise manager. If you need more help post again. Hope this helps.

Access .Rdl from Asp.net webforms

Hi,

I am new to Sqlserver reporting.I have created few reports using vs2005 busineess intelligence projects and report designer-wizards.

I want to add/access those reports from webforms?is it possible?or do i need to deploy reports over report server.If i run the server i am able to see the report.

If i want to access from .aspx page what do i need to do?I tried adding existing item,.rdl but i do see only .xml part of .rdl .

Can anyone help me on this.

Thanks,

kar1978

Use ReportViewer control

It can be used with

// Set the processing mode for the ReportViewer to Remote

reportViewer.ProcessingMode =ProcessingMode.Remote;

or

reportViewer.ProcessingMode =ProcessingMode.Local

About login into sql server via asp.net

I want to design a form with C# that will able me to log in to my sql server with my sql login name and password.This should be the entry point, which is like the "SqlWebAdmin", Where i login first then have a view of databases that i have permission. The problem first is how to login into the sql server via ASP .net without knowing prior which database is mine?Any help plz?Most apps put their connect information in web.config, and read it out at run time.

about intergrated security

hi all

i am setting the sqlconnection string right this:

server="myserver";Intergrated security = "sspi"; database="mydb";

do i need to add ASPNET account to the sql server in order to get it works?

any dangerous do i need to face when i set the connection string right that?

thanks

Using Integrated Security, the Windows ASPNET user must be a user in the database.