Re: Can not connect to database server through FrontPage 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Richard Gutery (rgutery_at_mentorits.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 12:36:16 -0700

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
>

Relevant Pages

  • understanding chkrootkit: sshd section
    ... Rhosts Authentication disabled, originating port will not be trusted. ... Secure connection to %.100s on port %hu refused%.100s. ... Warning: Remote host refused compression. ... Received RSA challenge from server. ...
    (comp.os.linux.security)
  • understanding chkrootkit: sshd section
    ... Rhosts Authentication disabled, originating port will not be trusted. ... Secure connection to %.100s on port %hu refused%.100s. ... Warning: Remote host refused compression. ... Received RSA challenge from server. ...
    (comp.security.unix)
  • Re: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • SQL 2005 Express and VS .Net 2003 wizard error More options
    ... Open the server explorer panel ... Go to the Provider tab and select SQL NAtive Client (DON'T use oledb ... Go back to the Connection tab and carry on setting up the connection ... I have installed Visual Studio 2005 Professional and then Visual Studio ...
    (microsoft.public.sqlserver)