Integrated Security automatic login to SQL Server 2005 / Crystal Report 2008

Last post 07-16-2008 1:53 AM by sinjinchan. 2 replies.

Sort Posts:

  • Integrated Security automatic login to SQL Server 2005 / Crystal Report 2008

    07-15-2008, 8:06 PM
    • Member
      1 point Member
    • sinjinchan
    • Member since 07-10-2008, 9:20 AM
    • Posts 4

    hi   I want to use integrated security to auto login to Crystal Report / SQL Server 2008:

    myconnectioninfo.integratedsecurity = true

    the problem is the screen prompted for userid / password.

    Is there a way to bypass this ?   In other words, are there ways

    to represent users' login credentials in code ?

    Many thanks. 

     

     

                            

  • Re: Integrated Security automatic login to SQL Server 2005 / Crystal Report 2008

    07-16-2008, 12:44 AM
    • Member
      419 point Member
    • abipeter1983
    • Member since 08-04-2007, 9:56 AM
    • Trivandrum
    • Posts 78

     

       Dim oCRTable As CrystalDecisions.CrystalReports.Engine.Table

     Dim oCRTableLogonInfo As CrystalDecisions.Shared.TableLogOnInfo
     

     Dim oCRConnectionInfo As New CrystalDecisions.Shared.ConnectionInfo()
            oCRConnectionInfo.DatabaseName = _dbName
            oCRConnectionInfo.ServerName = _serverName
            oCRConnectionInfo.UserID = _userID
            oCRConnectionInfo.Password = _passWord
            oCRConnectionInfo.IntegratedSecurity = True
            oCRConnectionInfo.Type = CrystalDecisions.Shared.ConnectionInfoType.SQL

                 oCRTableLogonInfo.ConnectionInfo = oCRConnectionInfo
                oCRTable.ApplyLogOnInfo(oCRTableLogonInfo)
     

    Abipeter
  • Re: Integrated Security automatic login to SQL Server 2005 / Crystal Report 2008

    07-16-2008, 1:53 AM
    • Member
      1 point Member
    • sinjinchan
    • Member since 07-10-2008, 9:20 AM
    • Posts 4

    thank you for the response. Can you clarify

    CRConnectionInfo.UserID = _userID
    CRConnectionInfo.Password = _passWord

    I use these 2 lines for Server authentication 

    How do I represent any domain users and access the DB

    using their own login credentials? 

     


     

Page 1 of 1 (3 items)