Re: Help! Set up Windows Group to access application

Those errors aren't from permissions issues. That's a
problem in passing credentials to the server. If it's only
in Crystal then look at how the connection to SQL Server is
setup for crystal reports.

-Sue

On Tue, 15 May 2007 17:44:00 -0700, Sandy
<Sandy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks so much for responding!

Now I'm having real problems. I was not able to set up Sql Server 2005
successfully, so I resorted to Sql Server 2000. I am able to get the users
connected and they are able to insert and update stuff BUT they are getting
the following message when they access Crystal Reports:

ADO Error Code 0X80004005
Login failed for user '(null)'. Reason: Not associated with a trusted Sql
Server connection
SQL State: 42000
Native Error 18452.

I don't understand how they can access the database through the VB6 UI and
not be able to access the reports that use other stored procedures in the
database. (The VB6 code for selecting and inserting, etc. contains stored
procedures also and I gave rights to execute.)

Any clues will be greatly appreciated!

.

Relevant Pages

  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: How to Direct connect with ActiveSync
    ... That won't work because you have a connection string that can't be correct. ... You're saying that the database is, but it's not; ... Server 2000, Visual Studio 2008. ... Again sorry if this should be in another form but you say that SQL Server ...
    (microsoft.public.sqlserver.ce)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)
  • .Net Scalability problem
    ... I finished a Great project using .Net and SQL Server and .Net Mobile ... Million concurrent users ... So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.sqlserver.connect)
  • Re: Communication Link Failure Error
    ... On disconnection from the network, in my code I changed the connection ... string to use SQLOLEDB and sent a SQL query to SQL server which failed as ... unplug the network cable from the client machine and put the cable ...
    (microsoft.public.data.ado)