Can not connect to database server through FrontPage 2003

[dln]

Hello all. I'm having a problem inserting a data view into a page off a
SharePoint Portal Server 2003 site when using FrontPage 2003 that maybe
someone can help me with. We have MS SQL Server 2000 SP3 server that uses
integrated Windows authentication (actually it has mixed mode
authentication, but we try to use integrated authentication whenever
possible). When using FrontPage, we attempt to add a database connection
and in the "Configure Database Connection" wizard dialog we specify the name
of the DB server and select the "Use Windows authentication" option. When
we click on "next", we receive the error:

"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"

We know integrated authentication works for this server - we can use it when
setting up an ODBC datasource or connecting through Visual Studio .Net. If
we use SQL Server authentication to connect to the DB server it works, but
we get a warning about storing the username and password in cleartext, so we
would prefer to not have to use this option.

Searching the web, I have found the only following article at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;831092. It tells me
how to work around the error, but not how to fix it. Has anybody
experienced this problem and/or knows of a way to fix it? Any and all help
is appreciated.

Thanks,

dln

 

[Richard Gutery]

Try making the account that is being used to connect to SQL as DBO for the
DB. If that works, then you'll need to look at the permissions on the DB and
tables in the DB.

I did this about a month back and it fixed the problem. Something in FP2K3 I
think.

Just a quick thought as there isn't much information on the config of SQL.

RG

 

[dln]

Thanks for the response - I've tried what you have suggested and still no
luck. Can you think of anything else that I might take a look at?

Thanks again,

dln