Database Connection Can't Connect to SQL Server using Windows Authentication

J

Joseph

Hi.

We have a MS SQL Server 2000 SP3 server that uses integrated Windows
authentication. We need to use FrontPage 2003 to add a database
connection to the "Configure Database Connection" wizard on a
Sharepoint Services Site. We have specified the name of the DB server
and selected the "Use Windows authentication" option, but get the
following error upon pressing "Next":

"Server Error: An error occurred while retrieving the list of Databases

from <server>: The data retrieval service encountered an error during
connection to the data source. Contact the server administrator for
more
information"

On the Server running Sharepoint Services, we can connect to our SQL
Server using ODBC connections. On my local machine, I can also connect
to the SQL Server, since I am a DBA. It is rather confusing... Whose
logon is being used agains the SQL Server?

I read something about trust level in web.config might be an issue.
The one that got automatically created by Sharepoint Services has

<securityPolicy>
<trustLevel name="WSS_Medium" policyFile="C:\Program Files\Common
Files\Microsoft Shared\Web Server
Extensions\60\config\wss_mediumtrust.config" />
<trustLevel name="WSS_Minimal" policyFile="C:\Program Files\Common
Files\Microsoft Shared\Web Server
Extensions\60\config\wss_minimaltrust.config" />
</securityPolicy>

I came across
http://support.microsoft.com/default.aspx?scid=kb;EN-US;831092. We are
in an intranet and do not use proxies, Enable update query support is
already enabled on our sharepoint web server, and we do not want to use
SQL server authentication. I'm not clear why the article appears to be
pushing us toward configuring and using single sign on!

Is it possible to use SQL Server with Windows Authentication, which
appear to be options in Configure Database Connection?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top