Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SQL Server and Share Point...

  Asked By: Veer    Date: Oct 09    Category: Sharepoint    Views: 893

I am trying to connect to custom SQL Server database whcih is
created on the same SQL Server where the SharePoint database is
present, using the following Connection String.


I have set

<identity impersonate="true"/>

in the web.config file of the Visual Studio 2003 project, I am
trying to use impersonistaion here so that any user who is an
authenticated user should be able to perform all the Sql related

I have also assigned the ASPNET and IUSER rights to access the

The Windows Authentication mode is set for both the Sql Server and
in the IIS.

I get the error "Login failed for the user DOMAINNAME\username"

If I add the user to the SQL Logins the user is able to access the
pages, but I need all authenticated windows users to be able to
access the pages...

I am making these .aspx pages developed in Visual Studio project
available to the users who have logged into sharepoint using the
page viewer web part..

I have been working on this for past few days and have had no luck,
please help



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on SQL Server and Share Point... Or get search suggestion and latest updates.