Problem Connecting to another SQL DB using SQL Security

I am attempting to create a Data Source connection to a SQL Server DB using
SQL Authentication so that I can create DataViews and cannot (I get "Server
Error: An error occurred while retrieving the list of
Databases". However, I can do this fine when I use an Office Web Component
to the same DB. Any ideas why one works and the other does not? MSKB 831092
seems to imply that I must use Windows Authentication, but I'm not really
sure if this correct.

TIA
Dean


.

Relevant Pages

  • Re: Connect to Desktop SQL Server 2000 from Pocket PC
    ... SSPI is in fact supported, but you have to provide user ID and password ... This might be useful if SQL authentication is disabled on a server. ... > Xref: cpmsftngxa10.phx.gbl ... >> I need to connect from a program in the Pocket PC to SQL Server in my ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... Are you sure SQL Server is set up to use both SQL Authentication and Windows ... "John Beschler" wrote in message ... > I don't think it's a problem with the IUSR account because ASP runs fine. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Windows Service Login Failed when accessing SQL.
    ... SQL Authentication should work since you specify the login ID and password ... connect to the SQL Server DB successfully. ... > Windows Service Login Failed when accessing SQL. ...
    (microsoft.public.dotnet.distributed_apps)
  • Authentication to server with SSL through firewall
    ... Every SQL Server will have SSL certificate ... SQL authentication with encryption requested in connection string. ...
    (microsoft.public.sqlserver.security)
  • Re: error-"not associated with a trusted ..."
    ... When you CONNECT to your SQL Server, you have to choose one or the other, ... but Kim is talking about the configuration of the server itself. ... must be set up to ALLOW both Windows Authentication and SQL Authentication. ... The other choice is WIndows only. ...
    (microsoft.public.sqlserver.security)