Crystal Reports webservice vb.net

[Former Member]

I have a crystal report which is running succesfull in windows application. I used the same report to deploy from webservice Print automatically from webserver to a specific printer

In web.config file I am using u201C<identity impersonate="true" userName="DOMAIN\USERNAME" password="PASSWORD"/>u201D

When I call the method PrintToPrinter, getting a error as

u201CError in File C:\DOCUME_{1\VINOTH\ASPNET\LOCALS}1\Temp\Copy of MISys Purchase Query {6E996346-B73A-4A42-8F3C-2818B5C97C88}.rpt: Unable to connect: incorrect log on parameters.u201D

Supplier - UserName, Password, ServerName, DBName are correct, using the same logon info in windows application which wors fine. Can any one help me?

Connection status successes - Connecting database directly using Connection Provider

_Using CrystalDecisions version 10.2.3600.0, Visual Studion 2005 and IBM DB2 _

Dim report As New CrystalDecisions.CrystalReports.Engine.ReportDocument()

report.Load(ReportPath)

report.SetDatabaseLogon(UserName, Password, ServerName, DBName)

Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo

Dim myTable As CrystalDecisions.CrystalReports.Engine.Table

For Each myTable In report.Database.Tables

myLogin = myTable.LogOnInfo

myLogin.ConnectionInfo.ServerName = ServerName

myLogin.ConnectionInfo.DatabaseName = DBName

myLogin.ConnectionInfo.Password = Password

myLogin.ConnectionInfo.UserID = UserName

myLogin.ConnectionInfo.IntegratedSecurity = True

myTable.ApplyLogOnInfo(myLogin)

myTable.TestConnectivity()

Next

report.PrintOptions.PrinterName = PrinterName

report.PrintToPrinter(1, False, 0, 0)

Edited by: vinoth kumar on Sep 11, 2008 9:02 AM

[Adam_Stone · Accepted solution]

You should either be setting the user and password in code, or use Integrated Security, not both.

So you should have either:

myLogin.ConnectionInfo.Password = Password

myLogin.ConnectionInfo.UserID = UserName

OR:

myLogin.ConnectionInfo.IntegratedSecurity = True

[Former Member · Accepted solution]

Thanks for your reply. Now I am using windows service to print.