| Arnie Rowland 2006-12-05, 7:12 pm |
| Perhaps one of these articles will help:
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/defaul...kb;EN-US;914277
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/ar.../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.googlegroups.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.
>
|