Data View - can't connect to SQL Server

[Erin]

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?

 

[Kevin Spencer]

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.