Remote connection failed

I am getting the following error ...

Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'myUserName'. Reason: Not associated with a trusted SQL Server connection.

Upon examination of the SQL Server Log, I see the exact same message.

The connection string being used is ...
"Driver={SQL Server}; Server=xxx.xxx.xxx.xxx; Address=xxx.xxx.xxx.xxx,1433;
Network=DBMSSOCN; Database=myDatabase"

SQL Server Properties - Security tab has the following settings ...

Authentication: Windows only
Audit level: All
Allow cross-database ownership chaining: not checked

When SQLDriverConnect is called, an SQL Server Login dialog comes up
allowing me to Use Trusted Connection or provide Login ID and Password. If
Use Trusted Connection is checked, then same error as above is returned
except myUserName is replaced by "(null)". If not checked, then the login
has failed with all username/password combinations I know of on my server.

Referencing an earlier posting dated 10/31/2005 entitled "Error connecting
through the web", Sue Hoegemeier wrote, "Use Integrated Security=SSPI with
an OLE DB provider in your connection string instead of supplying a username
and password." Sue, what does this part of the connection string "look"
like? Can you give me an example? Also, how can the Reason given in the
error message be remedied?

Any help would be greatly appreciated. Thanks.


.

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)