Password Prompt

[fmrock]

Hey everyone, I am having a problem with a new crystal report that I loaded on our enterprise server. The report runs fine on my local PC.

I am using CR9.

Once the report is uploaded to the Enterprise whenever you try to run it, it just keeps prompting for the database username/password and will not run the report at all from enterprise.

This is the first report to be pulled from a database on this particualar SQL server.

I have never had this issue with any of my reports here. I tried different database users and even the "SA" account.

The Enterprise server is located 1000 miles away at our parent company.

Any ideas on what needs to be checked to get this to work.

Also the report is very simple and just displays the columns in a small table. 200 rows, 40 columns.

 

[synapsevampire]

You probably just need to set up another ODBC connection on the server for it.

Note that you should set the database/user/pw on the server rather than have it prompt for such things.

-k

 

[fmrock]

We are not using an ODBC connection. We are using the OLE DB (ADO) connection

 

[synapsevampire]

Yeah, it's certainly more problematic, and proves slower in many cases.

Is the OLE DB based on an ODBC connection?

In either case, I'd switch to ODBC and watch the problem go away...

-k

 

[fmrock]

I setup the OLE DB connection just by going though the wizard and selecting SQL Server >> my Servername and database.

I have tried it with intergrated security and using the sa un/password.

Both run on my local PC in crystal and not on the enterprise.

 

[Turkbear]

Hi,
Check that the account that the Pageserver and others are running as has sufficient rights to the fiole system location and database used in the report.

Also be sure the same OLE DB provider exists on the Enterprise server ( if using a DSN-less OLE connection) or
that the same DSN in on the server and is configured as a SYSTEM dsn ( if using an ODBC Ole connection type)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[fmrock]

Also, of the 4 sql servers that reports from the enterprise hit are all sql server 2000 databases, and this new one is sql2005.

All runs fine on my crystal here, but not on enterprise.

Where do you check what account the pageserver and others are running?

 

[Turkbear]

Hi,
In the CCM, right-click the pageserver entry and under properties you will see that info..





To Paraphrase:"The Help you get is proportional to the Help you give.."