Re: Help! Set up Windows Group to access application



Sandy (Sandy@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Thanks again for replying, Sue!

I don't know exactly where to look for that. Could you point me in the
right direction?

Again, any help you can give me is greatly appreciated!

If you have troubles with finding your ways in Crystal Reports, you are
probably better of in a forum for Crystal Reports. While we use it in our
shop, I try to stay away from it as much as possible. (And we never connect
directly from Crystal to the database anyway. We pass it recordssets from
VB.)

Another strange thing -- another developer was able to access the
reports via the application without a problem.

A regular user cannot and receives the error previously posted.

That certainly is a little funny, since it seems from your posts that
you are using integrated security in both Crystal and the VB app. But
that is only seems. It would really help if you posted the connection
strings that you use, both in the VB6 app and in Crystal.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.



Relevant Pages

  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: Does PUBLIC override user-defined roles?
    ... I haven't used crystal reports myself, but one thing you'd hace to check is ... there's a fixed database role (it's on every user database by ... SQL Server MVP ... By not being a member of the PUBLIC group, ...
    (microsoft.public.sqlserver.security)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: Subqueries with parameters
    ... > Crystal Reports. ... I am using SQL Server so I can do it with a stored ... > clauses or to put parameters on both the subquery and the main query. ... > Data Management Solutions LLC ...
    (microsoft.public.vb.crystal)