Re: Can not connect to database server through FrontPage 2003
From: dln (dnadon_nospm_at_hotmail.com)
Date: 11/23/04
- Next message: MD Websunlimited: "Re: My website's format and layout appears incorrect in some browsers."
- Previous message: KeyKey23: "My website's format and layout appears incorrect in some browsers."
- In reply to: Richard Gutery: "Re: Can not connect to database server through FrontPage 2003"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 07:40:02 -0600
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
"Richard Gutery" <rgutery@mentorits.com> wrote in message
news:uPf%23JqM0EHA.2676@TK2MSFTNGP12.phx.gbl...
> 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" <dnadon_nospm@hotmail.com> wrote in message
> news:uRzwVeL0EHA.1396@tk2msftngp13.phx.gbl...
>> 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
>>
>
>
- Next message: MD Websunlimited: "Re: My website's format and layout appears incorrect in some browsers."
- Previous message: KeyKey23: "My website's format and layout appears incorrect in some browsers."
- In reply to: Richard Gutery: "Re: Can not connect to database server through FrontPage 2003"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
