Sharepoint SQL Server 2005 Connection via SharePoint Designer with a Windows Domain Account vs Single Sign On RRS feed

  • Question

  • Establishing a database connection: MOSS 2007, SharePoint Designer 2007, SQL Server 2005 with mixed authenticaton.

    In the Configure Database Connection panel:

    • Server Name: Entered our Server name
    • Under Authentication/Save the username and password to the data connection:
    • User Name: Entered the Windows Domain Account Name
    • Password: Entered the Password assigned by the SQL Server DBA


    Received the following: An error occurred while retrieving the list of databases from Server.... An authentication error occurred. Your logon information may be incorrectly entered. You may not have permission to access the data source. or the required authentication method may not be supported.

    Is there any reason that a SQL Database Connection vis SharePoint Designer can not be made using a Windows Domain Account and password credentials which were reportedly to have been validated?

    When using a SQL User account, instead of a Windows Domain account, authentication was successful.

    Is Should Single Sign On method more secure?

    Our IT security has "concerns with a database or connection that has an account with no policies exposing the Business to vulnerabilities. Although Sharepoint may be secure and authenticate against the domain, the accounts themselves are ways to connect on the various devices and would not be secure".

    Any insight would be appreciatied.








    • Moved by Mike Walsh FIN Monday, April 25, 2011 3:30 PM Not programming - SPD q (From:SharePoint - Development and Programming (pre-SharePoint 2010))
    Monday, April 25, 2011 1:40 PM


All replies