Re: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo


BrianMultiLanguage wrote:
Will the error is in the subject line.

ust to be sure, you have some machines working and one particular machine
(the laptop) is not working, right?
YES
Are you using Named Pipes or TCP-IP?
TCP-IP
Is
the laptop using a trusted connection or SQL Server security mode?
trusted.
What was
the exact text of the error message?
When user starts up database, they get:
Connection failed:
SQLState: '28000'
SQL Server Error: 18452
microsoft,odbc sql server driver, sql server, login failed for user '(null)'
Reason: not associated with a trusted SQL server connection.
What things have you tried that did not
resolve the problem?
Make a new connnection.
Try pipes.
f/w on/off
Login as admin, works fine.
The other fixes i listed below.

"Cindy Winegarden" wrote:

Hi Brian,

Just to be sure, you have some machines working and one particular machine
(the laptop) is not working, right? Are you using Named Pipes or TCP-IP? Is
the laptop using a trusted connection or SQL Server security mode? What was
the exact text of the error message? What things have you tried that did not
resolve the problem?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com


"BrianMultiLanguage" <BrianMultiLanguage@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:3D81F886-58B5-4C09-AA8A-1529B54CE72B@xxxxxxxxxxxxxxxx
We changed from sql 7 to 2000, crissis mode.
One use with a laptop keeps getting the error when connecting to the sql
server.
SQL 2000 latest, mixed mode.
Laptop xp pro latest, mdac is latest.

I looked up sql server 26000 and 18452. I was not able to resolve the
problem. Still an untrusted connection.

I do know it is in the user profile but what?


You should specify the to login otherwise it should not allow you to login in.

.

Relevant Pages

  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... remote connection. ... should I just check named pipes only or both TCP/IP and ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ...
    (microsoft.public.sqlserver.connect)
  • Re: netbios and named pipes sql replication.
    ... Once the client switched to named pipes, ... > connection with. ... > When we took named pipes support off the SQL server with the MS patch, ... > We had to manually walk thru the ODBC setup and configure the CLIENT ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Express slow when connecting from client on network.
    ... connection to Named Pipes, ... Perhaps your SQL Server Native Client on the XP computer is ...
    (microsoft.public.sqlserver.clients)
  • Re: Error while connecting remote SQL server
    ... There might be possoble you have defined aliases for the SQL server in your ... An error has occurred while establishing a connection to the server. ... (provider: Named Pipes Provider,error:40-Could not open ... (provider: Named Pipes Provider, error: 0 - No process is on the other ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo
    ... microsoft,odbc sql server driver, sql server, login failed for user '' ... not associated with a trusted SQL server connection. ... you have some machines working and one particular machine ... the laptop using a trusted connection or SQL Server security mode? ...
    (microsoft.public.sqlserver.clients)