Ok, I just set up Microsoft SQL Server 2000 Standard
Edition. I have it on a server running Windows 2000
Server. I then put it on one computer running Windows
2000 Pro. When I open an Access database and I try to run
the upsize wizzard to convert the database into SQL I
click tools -> database utilities -> upsizing wizzard. I
choose Create New Database, pick the correct server, and
put in my loggin information, and click Next then I get
the following error:

Connection Failed
SQL State: '28000'
SQL Server error: '18452'
[Microsoft][ODBC SQL Server Driver][SQL Server] Login
failed for user 'ashover'. Reason: Not associated with a
trusted SQL Server connection

Does anybody know how to fix this?
Thanks,
Aaron Shover

The server is probably in Windows only authentication
mode. Is there any reason you can't use NT authentication
to connect. If there is then it can be changed via EM from
Server Properties>Security tab (requires restart of the SQL
Service) or by editing the registry if you don't have EM
http://support.microsoft.com/default...;EN-US;q285097

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Aaron Shover" <ashover (AT) state (DOT) pa.us> wrote

Ok, I just set up Microsoft SQL Server 2000 Standard
Edition. I have it on a server running Windows 2000
Server. I then put it on one computer running Windows
2000 Pro. When I open an Access database and I try to run
the upsize wizzard to convert the database into SQL I
click tools -> database utilities -> upsizing wizzard. I
choose Create New Database, pick the correct server, and
put in my loggin information, and click Next then I get
the following error:

Connection Failed
SQL State: '28000'
SQL Server error: '18452'
[Microsoft][ODBC SQL Server Driver][SQL Server] Login
failed for user 'ashover'. Reason: Not associated with a
trusted SQL Server connection

Does anybody know how to fix this?
Thanks,
Aaron Shover