Re: Data View - can't connect to SQL Server

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

From: Kevin Spencer (kevin_at_DIESPAMMERSDIEtakempis.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 10:42:04 -0500

Post your Connection String. First, it has nothing to do with IIS. It may
have something to do with your SQL Server, as there are different ways of
authenticating with SQL Server (Mixed or Windows authentication). I'd need
to see your Connection String to make any further diagnosis. 

-- 
HTH,
Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.
"Erin" <Erin@discussions.microsoft.com> wrote in message 
news:3AABF226-CAFC-4A26-ABE7-A6CB0BB35F24@microsoft.com...
>I am trying to create a data view.   This is on a WSS site.    When I 
>attempt
> to configure the db connection, I cannot get it to work.  This is true
> whether I use Windows Authentication or give it a specific 
> username/password.
>  The error I get is:
>
> An error occurred while retrieving the list of databases.  An 
> authentication
> error occurred.  Your logon information may be incorrectly entered, you 
> may
> not have permission to access this data source, or the requested
> authentication method may not be supported.  Contact the server 
> administrator
> for more information.
>
> I know there is not a logon problem, as I'm using this same account for
> other connections.  And, it doesn't work with windows authentication 
> either.
> I suspect there is some setting on the IIS or SQL side preventing this
> connection.
>
> Ideas?
>
>

Relevant Pages

  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to database
    ... when you use iis, its uses the aspnet account which is local and is probably not set up to access your sqlserver. ... I open Visual Web Developer 2008 express on desktop and Select File>open Website, and browse to a folder on DevBox. ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: More on that login problem - found the logs -
    ... I see that I'm using both SQL Server and Windows authentication; ... "Startup service account" startup runs the ... Should I try to make a new SQL server registration? ... Not associated with a trusted SQL Server connection"). ...
    (microsoft.public.sqlserver.connect)
  • Re: More on that login problem - found the logs -
    ... Verify that you are using both SQL Server and Windows authentication using ... Not associated with a trusted SQL Server connection"). ... Which account are you using to connect to the database? ...
    (microsoft.public.sqlserver.connect)
  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)