Security Question....

From: skc (skc_at_skc.com)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 00:49:04 -0700

I have SQL2000 sitting on a a local machine. I have
imported a database into SQL2000 from dBasev. I am using
Crystal Reports 8.5 to interact with the Database through
ODBC.

In Crystal I can check a "Trusted Connection" tick box
which automatically logs me into the database. However,
when I use the sa account or another account I have
created with full permisions I cannot get into my database.

I urgently need help with setting up a user in SQL2000 so
that I can use the appropriate login account to access the
database. I beleive that my System DSN created in Windows
2000 Pro is incorrect because of this.

Please help!

Skc

Relevant Pages

  • Interesting problem with Crystal Reports- Database Login
    ... I just had my first interaction with Crystal Reports. ... pointing to a MS Access database. ... Option-1: I used udl files, ... the report gave "Query Engine Error". ...
    (microsoft.public.vb.crystal)
  • Re: why>?
    ... If we believe you're a database expert, ... starting the db design-- and then you can call in the heavy programmer ... within the body text of the e-mail or as Word, Excel, PDF or plain text ... it's not as powerful as Crystal Reports ...
    (microsoft.public.excel)
  • Got data in Dataset, but CR Rpt is Blank - vsInvPFD.zip [0/1]
    ... Crystal Reports Dilemma ... I have an ACCESS Database that has 3 tables in it. ... My goal is create a pdf of a single invoice from an imported text ...
    (microsoft.public.vb.crystal)
  • Re: Export a table daily
    ... Be sure to compact-and-repair the database regularly. ... "Lavatress" wrote: ... the information will be imported to Crystal Reports. ... this information will go into our Sustain system which is the backend for the ...
    (microsoft.public.access.externaldata)
  • Re: HOW TO CONNECT DATABASE IN A CRYSTAL REPORT
    ... I made a simple VB.NET program using an acces database and crytal ... Obviously I used the crystal reports to view the data saved in the ... (eg. the original connection path of Crystal Reports to the .mdb file was ... connecting the report to a database even when I install it in a different ...
    (microsoft.public.dotnet.framework.adonet)