Authentication, windows or custom

I have read most of the threads regarding form authentication as well as the suggested articles. Unfortunately I am not clear if I need to do custom security or stay with windows authentication

I would like to access a specific report using a URL so that all the features and funcionalty of the report is available to the user. There are to many users and reports to assign and maintain individual users and/or groups to a specific report.

Our users would access the report from either a windows or web application having already passed security. They would have a button to press to obtain the report. We would prefer to pass a specific userid to report services at this point that is authorized to view the report.

Can this be done without switching to custom security? To use form authentication must you switch to custom security? Would impersonation work?Hi,

If you go with Windows Authentication, then you can retrieve the Windows UserId from the Thread class - Thread.CurrentPrincipal.Identity.Name

Regards,
Vikram

Authentication problems

I am using form authentication to login into report service. When I execute
a report, the following error is displayed:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'DAISYS'.
(rsErrorOpeningConnection) Get Online Help
Unable to load DLL (oci.dll).
But if I use window authentication, it works fine.
Please help !!!Can someone help me ?
"May Liu" wrote:
> I am using form authentication to login into report service. When I execute
> a report, the following error is displayed:
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'DAISYS'.
> (rsErrorOpeningConnection) Get Online Help
> Unable to load DLL (oci.dll).
> But if I use window authentication, it works fine.
> Please help !!!|||This sounds like a file permission issue with the installation of the Oracle
client software. The ASP worker process is unable to load OCI.dll and other
configuration settings which are stored in the Oracle client installation
directory.
For instance, the Oracle 9.2 client is typically installed at:
C:\oracle\ora92. When you use Windows authentication, it seems like the
users executing reports have "Read & Execute" permissions at least on
\oracle\ora92\bin and \oracle\ora92\network\admin directories - and
therefore the ASP.NET work process can access and load the Oracle client
software (dlls and configuration fiiles) from there.
When you use Forms authentication, most likely the ASP.NET worker process
will run under a user account that does *not* have explicit Read & Execute
permissions on the directories of the Oracle client software. Make sure
these rights are explicitly granted to all files (child objects) in those
directories (on Win2003 on the directory security tab you have to click on
the Advanced button and in the new popup window you have to select "Replace
permission entries on all child objects ..." and click OK).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:823537DA-85E8-4C71-8F0D-6CFA0EAE4182@.microsoft.com...
> Can someone help me ?
> "May Liu" wrote:
> > I am using form authentication to login into report service. When I
execute
> > a report, the following error is displayed:
> >
> > An error has occurred during report processing. (rsProcessingAborted)
Get
> > Online Help
> > Cannot create a connection to data source 'DAISYS'.
> > (rsErrorOpeningConnection) Get Online Help
> > Unable to load DLL (oci.dll).
> >
> > But if I use window authentication, it works fine.
> > Please help !!!|||It works. Thanks a lot !!!
"Robert Bruckner [MSFT]" wrote:
> This sounds like a file permission issue with the installation of the Oracle
> client software. The ASP worker process is unable to load OCI.dll and other
> configuration settings which are stored in the Oracle client installation
> directory.
> For instance, the Oracle 9.2 client is typically installed at:
> C:\oracle\ora92. When you use Windows authentication, it seems like the
> users executing reports have "Read & Execute" permissions at least on
> \oracle\ora92\bin and \oracle\ora92\network\admin directories - and
> therefore the ASP.NET work process can access and load the Oracle client
> software (dlls and configuration fiiles) from there.
> When you use Forms authentication, most likely the ASP.NET worker process
> will run under a user account that does *not* have explicit Read & Execute
> permissions on the directories of the Oracle client software. Make sure
> these rights are explicitly granted to all files (child objects) in those
> directories (on Win2003 on the directory security tab you have to click on
> the Advanced button and in the new popup window you have to select "Replace
> permission entries on all child objects ..." and click OK).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
> news:823537DA-85E8-4C71-8F0D-6CFA0EAE4182@.microsoft.com...
> > Can someone help me ?
> >
> > "May Liu" wrote:
> >
> > > I am using form authentication to login into report service. When I
> execute
> > > a report, the following error is displayed:
> > >
> > > An error has occurred during report processing. (rsProcessingAborted)
> Get
> > > Online Help
> > > Cannot create a connection to data source 'DAISYS'.
> > > (rsErrorOpeningConnection) Get Online Help
> > > Unable to load DLL (oci.dll).
> > >
> > > But if I use window authentication, it works fine.
> > > Please help !!!
>
>sql

Authenticate against Active Directory

We are writing an enterprise application in which the user logs in by entering their username and password in a form. The user will enter their actual Active Directory credentials. I want to pass the username and password to a stored procedure that will check for a valid user account in an Active Directory. In Sql Server 2005 I know I could write a small .NET library that uses System.DirectoryServices , register it in SQL and access it from an stored procedure.

Can it be done in Sql server 2000?

The reason we are not just autheticating in the .NET code of the application is that we found that it does not work on Windows 98 cleints, hence the need to go through sql server.

Thanks

In SQL Server 2000, you can write an extended procedure. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_07_9rxv.asp for additional information on extended stored procedures.

Thanks
Laurentiu

Attaching files

I have just started using ASP.net.
I have to develop a system that attaches word and PDF files to form. I also need to be able to do a full text search on the documents attached.
I'm currently using SQL server 2000 as my backend DBMS, but I have never used it to attach files. My mates recommend using BLOGS but I'm not sure how to do this and I'm not sure if I can do a full text search using this solution.
Could some body please recommend a solution to get me started.
Thanks in advanced
PaddyYou have two requirements because Word and PDF files are better stored as IMAGE while FULL TEXT uses TEXT and NTEXT. FULL TEXT is an add on to SQL Server dependent on Microsoft Search and the Catalogs must be populate to get search results. Run a search for FULL TEXT, CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE in the BOL(books online). Hope this helps.