Cannot connect to SQL Server

From: Guian Smith (gsmith14@nyc.rr.com)
Date: 07/05/02 

From: "Guian Smith" <gsmith14@nyc.rr.com>
Date: Fri, 5 Jul 2002 00:54:20 -0400

Help!

I had no problems with SQL Server 7.0, but after installing SQL Server 2000 (Personal Edition), I cannot connect to SQL Server thru an ODBC (or DB-lib) connection using ANY login userid, including sa. For example I can use odbcping with the default user as follows('VAIO' is my machine name), and it works:

C:\>odbcping -S VAIO (This works fine...)

CONNECTED TO SQL SERVER

ODBC SQL Server Driver Version: 03.81.9001

SQL Server Version: Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
        Aug 6 2000 00:57:48
        Copyright (c) 1988-2000 Microsoft Corporation
        Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

BUT when I try to use a login user & password, the connection is rejected even though I know I have the correct userid and password, and the user has admin priviledges. For example, ('sa' has not been assigned a password):

C:\>odbcping -S VAIO -U sa (This does not work)

COULD NOT CONNECT TO SQL SERVER

SQLState: 28000 Native Error: 18452
Info. Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

Does this have something to do with the Personal Edition? Everything else works fine (Enterprise Manager, etc).

Any help or suggestions will be greatly appreciated!

Thanks
Guian

Relevant Pages

  • MSSQL Server ODBC driver crash
    ... If the SQL Server driver's option "Use ANSI nulls, paddings and warnings" ... is not set and the length of char is over 623, MS SQL Server driver will ...
    (microsoft.public.data.odbc)
  • MS SQL Server 2000 ODBC driver crash
    ... If the SQL Server driver's option "Use ANSI nulls, paddings and warnings" ... is not set and the length of char is over 623, MS SQL Server driver will ...
    (microsoft.public.data.odbc)
  • Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
    ... I am unsure why the code does not insert CR\LF as I am 100% sure the file itself contains CR\LF. ... At 24000 chrs it works and at 48000 chrs you lose each \ followed by a. ... It is of no consolation to you but I have duplicated it with the MS SQL Server driver and also demonstrated it works fine with our sql server driver. ...
    (perl.dbi.users)
  • Re: Old SQL ODBC driver on 2003 Server
    ... Try installing the latest MDAC ... > I have a Windows 2003 Server which has a very old sql Server ODBC Driver ... If I go into Data Sources and view the SQL Server driver it is ...
    (microsoft.public.sqlserver.odbc)
  • Re: Creating Primary key with ODBC
    ... > (Sorry for line confusion, ... Have you checked which version of the ODBC SQL Server driver you have? ...
    (comp.databases.ms-sqlserver)