RE: SQL server Login connection failed sqlstate 28000 sql server e

From: aleksg01 (aleksg01_at_discussions.microsoft.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 04:41:01 -0800

Thanks for replying. It is greatly appreciated. Here is a list of versions:
- sql server 7.0 sp3 in mixed mode running on a windows 2000 server sp3
- windows xp pro sp2
- mdac 2.8 - ran the mdac checker and everything is fine
- access 2002 sp3

We have a number of Access applications, using sql as the backend. Before
we did the latest SP2, everything worked fine. We could do mods to the
access database, and reconnect to the sql server using odbc - dsn connection.
 Now when we make mods to the database, reconnect, then we get that error. I
can uncheck the trusted connection box, type in the user name and password
and get into the database, but this doesn't flow with end users, who need
that automatci connection to the database. I am saving the database as
either an mdb or mde, and in either case, it still errors out.

I have searched the web and found many threads with this error and similiar
situation, but no concrete resolutions. I also have a case opened with
Microsoft, two weeks old now and they are still working on it.

Hope this helps.

"Michael Cheng [MSFT]" wrote:

> Hi aleksg01,
>
> From your descriptions, I understood that your application remains working
> fine until you try to save the version that was relinked. Have I understood
> you? Correct me if I was wrong.
>
> First of all, what's your SQL 7's version? Have you make sure to upgraide
> the latest service pack, which should be SQL Server 7 SP3
>
> SQL Server 7.0 Service Pack 3 for Intel Platforms
> http://www.microsoft.com/downloads/details.aspx?FamilyID=9c71f91c-a88f-4d31-
> 9e8b-9fd63fbdbdcf&DisplayLang=en
>
> Secondly, you are using mdb or adp file? I have noticed that if a new file
> was made, everything was fine, right? Is it possible for you to use some
> other SQL client tools to connect the SQL Server from this XP SP2?
>
> If not, the following links in the Knowledge base article might help
>
> How to enable SQL Server connectivity on Windows XP Service Pack 2
> http://support.microsoft.com/kb/841251
>
> How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
> http://support.microsoft.com/kb/841249
>
> Thirdly, please download Component Checker from the link below to make sure
> the integrity of your MDAC
>
> MDAC Utility: Component Checker
> http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-
> bf53-14332ef092c9&DisplayLang=en
>
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
>
> Sincerely yours,
>
> Michael Cheng
>
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---------------------------------------------------------------
> Get Secure! - http://www.microsoft.com/security
>
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>

Relevant Pages

  • Re: large varchar columns in SQL server
    ... I had users' data stored in a SQL server database that was ... database is gone but we kept the resulting web page. ... Depending on the version of your MDAC driver, ...
    (microsoft.public.inetserver.asp.db)
  • error 3021 no current record, only sometimes
    ... I have an Access 97 database front end (with some lookup tables there ... too) which also has a MS SQL Server 2000 back end, ... getting ODBC errors when trying to open ... way and the same version of MDAC. ...
    (comp.databases.ms-access)
  • Re: 64 bit MDAC needed
    ... MDB uses Jet Engine, which is 32 bit, and will not have 64 bit version, for sure. ... You may consider to upgrade your *.mdb database to *.accdb, then use MS Access database engine. ... If you can use MySQL, I do not see why you cannot use SQL Server Express. ... I'm in desperate need for 64bit MDAC components. ...
    (microsoft.public.dotnet.general)
  • Re: large varchar columns in SQL server
    ... database, querying the database, or storing the values? ... Aaron Bertrand [SQL Server MVP] wrote: ... can't be sure what version of MDAC they were run under. ... As Bob suggests, it's going to be really hard to tell. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Sql Server Agent (2000) erroring out on DTS Packages
    ... DTSRun: Package execution complete. ... and a problem with a missing MDAC dll. ... On Sql Server 7, this was SQLAgentCmdExec. ... Specified driver could not be loaded due to system error 126 (MERANT MSSS ...
    (microsoft.public.sqlserver.dts)