July 5, 2009 03:39pm pdt

1. angelIII 706,858
2. chapmandew 595,744
3. rrjegan17 577,797
4. BrandonG... 519,540
5. reb73 463,796
6. aneeshatti... 414,235
7. mark_wills 409,505
8. RiteshShah 365,946
9. Sharath_... 239,007
10. CGLuttrell 226,160
11. acperkins 225,199
12. matthews... 209,331
13. mwvisa1 203,456
14. udayakum... 184,736
15. EugeneZ 143,330
16. momi_sa... 142,893
17. ralmada 137,409
18. DanielWilson 134,329
19. St3veMax 117,531
20. tigin44 115,875
21. brejk 112,813
22. JestersGrind 109,465
23. PedroCGD 105,309
24. pssandhu 105,208
25. appari 97,445

1. angelIII 4,294,623
2. chapmandew 3,396,265
3. aneeshatti... 1,560,941
4. mark_wills 1,239,771
5. BrandonG... 1,220,389
6. mwvisa1 650,912
7. momi_sa... 629,862
8. acperkins 621,166
9. rrjegan17 577,797
10. ptjcb 545,683
11. dtodd 540,776
12. Yveau 539,545
13. appari 531,819
14. dqmq 529,804
15. matthews... 509,879
16. DanielWilson 464,828
17. reb73 463,796
18. EugeneZ 442,624
19. PFrog 404,802
20. brejk 380,807
21. RiteshShah 365,946
22. PedroCGD 359,056
23. imitchie 350,938
24. ScottPletc... 338,349
25. ee_rlee 324,111

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

07/14/2008 at 01:28PM PDT, ID: 23564098

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

Problems using "Integrated Security" w/Crystal Reports 11 and SQL Server 2005

Asked by BlakeMcKenna in SQL Server 2005, Crystal Reports Software, Microsoft Visual Basic.Net

My shop has had problems using "Integrated Security" with Crystal Reports 11 ever since we installed CR 11. Our users logon to our network using an "Active Directory" logon. We use SQL Server 2005 as our backend DB and VB.Net 2005 as our development tool. Everything works fine from a Development machine or a stand-alone PC, but when installed on a Terminal Server....it craps out. For some reason, everytime a user goes to print a CR from within a VB.Net app, we get the "Database Logon" screen. See below.

Here is a code snippet of a typical call to a CR report. Currently, the "UserID/Password" parameters are commented out. It works on a stand-alone PC but still not on a Terminal Server.
View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:

           
           
             Public Sub PrintStatusCodesListing()
        Try
            dErr.clsModule = "modReports"
 
            Dim crDoc As New rptStatusCodes
 
            With crConnectionInfo
                .ServerName = "HERCULES"
                .DatabaseName = "Drip"
                '.UserID = "testUser"
                '.Password = "password"                
                .IntegratedSecurity = True
            End With
 
            strFormula = "{tblStatusCodes.statusID} > 0"
 
            crDoc.RecordSelectionFormula = strFormula
            frmReports.crViewer.ReportSource = crDoc
            frmReports.crViewer.DisplayGroupTree = False
            frmReports.ShowDialog()
 
        Catch ex As Exception
            dErr.clsProcedure = "PrintStatusCodesListing()"
            dErr.clsMsg = ex.Message
            dErr.OnlineErrorHandler(dErr.clsModule, dErr.clsProgram, dErr.clsProcedure, dErr.clsMsg)
        End Try
    End Sub

           
         

Attachments:

DBLogon.JPG (14 KB) (File Type Details)

Scree Shot

20090429-EE-VQP-58 / EE_QW_2_20070628

Problems using "Integrated Security" w/Crystal Reports 11 and SQL Server 2005

Asked by BlakeMcKenna in SQL Server 2005, Crystal Reports Software, Microsoft Visual Basic.Net

About this solution