Can anyone help?

From: ThomBeaux (ThomasAtIEM_at_HotMail.Com)
Date: 07/17/03


Date: Thu, 17 Jul 2003 11:16:48 -0700


If you did not "use trusted connection", and entered a
ogin and password, you did not enter the right password.

If you have Mixed Authentication turned on in SQL Server,
try using a trusted connection.

Else, go into enterprise manager and change the password
of that use, IF it is a SQL Server login.

ThomBeaux

>-----Original Message-----
>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: '18456'
>[Microsoft][ODBC SQL Server Driver][SQL Server] Login
>failed for user 'ashover'.
>
>Does anybody know how to fix this?
>Thanks,
>Aaron Shover
>
>.
>



Relevant Pages

  • Re: dsn-less connection
    ... Doug Steele, Microsoft Access MVP ... SQL Server login and was able to remove the specific dsn that's in the ... be possible to have it default to not Use Trusted Connection so it would ... Dim dbCurrent As Database ...
    (microsoft.public.access.security)
  • Re: Correct Deleted Default Database??
    ... It is not possible to restore dropped database because SQL Server deleted ... connected over trusted connection users and SQL Authentication is disabled ...
    (microsoft.public.sqlserver.security)
  • Re: MS OLE DB Provider for SQL Server Error: Invalid authorization spe
    ... > MS OLE DB Provider for SQL Server Error: ... > This is a basic 3-tier system, front end, data broker, database. ... > The middle tier uses SQL OLE DB to talk to the database. ... Books Online for SQL Server SP3 at ...
    (microsoft.public.data.oledb)
  • Re: Correct Deleted Default Database??
    ... >>It is not possible to restore dropped database because ... >>connected over trusted connection users and SQL ... Using Query Analyzer or any other tool try to login ... but SQL Server complains that sa is ...
    (microsoft.public.sqlserver.security)
  • HELP!! SSMSE and Windows VISTA
    ... I can not create a new database with SQL SERVER MANAGEMENT STUDY ... (Micorosoft SQL Server Error: 262) ...
    (microsoft.public.sqlserver.connect)

Quantcast