ODBC Login

From: Dennis (Dennis_at_discussions.microsoft.com)
Date: 08/22/04 

Date: Sat, 21 Aug 2004 19:41:01 -0700

I am using an ODBC connection to a SQL Server 2000 database to retrieve
information for a Crystal Report. When I am logged onto the network as
domain admin and create an ODBC DSN using SQL Server authentication and my
database admin logon everything works fine. If I use another SQL Server
logon (like the username of the supervisor who needs to view the report) to
create the DSN I get an ODBC (RDO) Login prompt for userid and password. No
matter what database userid and password I use I get an error message that
the password is invalid. I know the database userid and passwords I'm using
are valid because they are used daily by users who login through business
applications that use this database. The database is on a Windows Server
2000 computer. The domain controller is an NT4 SP6 machine. The
workstations are Windows XP Pro. Can anyone offer suggestions on
troubleshooting this problem? 

-- 
Dennis

Relevant Pages

  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Need ODBCDirect-ion
    ... Just as a side note, ODBC, or so called "jet" direct is simply a way to ... You need experience with sql server. ... "Upsizing to Microsoft SQL Server" White Paper Available in Download ... Choosing Database Tools White Paper Available in Download Cente ...
    (microsoft.public.access.modulesdaovba)
  • Re: Supporting a variety of database types in an app?
    ... Ralph, thank you for your insightful response. ... To get experience with MS SQL Server and client/server development. ... My rationale for using a file-based database location/selection method: ... ODBC API, but modified it to enhance performance). ...
    (microsoft.public.vb.database)
  • Re: Trusted Connection
    ... HOWEVER, for one of my users, I will create an ODBC DSN ... for my test database ON THEIR COMPUTER, ... So, when I set up the ODBC DSN connection for this user, ... >> Our SQL Server was set up NOT by me, ...
    (microsoft.public.sqlserver.security)
Loading