I've got SQL Server Express 2005 running as a backend and a front-end
made with microsoft access. I can connect when I run the front-end on
the same machine as the SQL Server but as soon as I try to set up a
network ODBC connection I get these errors. (The access front-end can
see the SQL Server - just not login to it).
This is the error I get:
Connection failed.
SQLState. '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'sa'. The user is not associated with a trusted SQL Server connection.
I have tried this with several different user name/password
combinations with varying degrees of permissions but none of them can
login. There is norton protection on but I set it to allow this type of
connection.
I went through the SQL Server 2005 connection FAQ with no result.
Perhaps one of these articles will help:
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"p" <p.macrae@.gmail.com> wrote in message
news:1165358176.124238.273490@.73g2000cwn.googlegro ups.com...
> I've got SQL Server Express 2005 running as a backend and a front-end
> made with microsoft access. I can connect when I run the front-end on
> the same machine as the SQL Server but as soon as I try to set up a
> network ODBC connection I get these errors. (The access front-end can
> see the SQL Server - just not login to it).
> This is the error I get:
> Connection failed.
> SQLState. '28000'
> SQL Server Error: 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'sa'. The user is not associated with a trusted SQL Server connection.
> I have tried this with several different user name/password
> combinations with varying degrees of permissions but none of them can
> login. There is norton protection on but I set it to allow this type of
> connection.
> I went through the SQL Server 2005 connection FAQ with no result.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment