Report Connection to SQL Server

[techie2]

Hi,

Using CR 8.5, CE 8.5, SQL Server 2000.

Designed a report using "Trusted Connection" instead of adding specific user id and pasword. Report runs fine.

Then I publish the report in CE. In database tab, I enter "corp\xyz" as userid and "xyz" as password. This user is a network account which has execute permissions for the Stored Procedure report is pointing to.

It is failing all the time in CE.

Questiion is, "Can I use network account or not", Usually how to have information set when report is pointing to SP in SQL Server and using Trusted Connection.

Any thoughts ??

V

 

[synapsevampire]

When you run it in CE, what error does it give? Reuqesting assistance should always include error numbers/text.

Does the CE server have the ODBC (assumed) connection on it?

I tend to manage security on the CE level, not the database level, so I will hardcode in the user/pw and limit who has access to it based no their CE group.

-k

 

[techie2]

Instance says "failed" and Error is "Can not open SQL Server".

On Designer, I have tried with OLE, SQL Server straight and ODBC connection. In designed I can create and run report using trusted connection.

I CE when I try to use domain account which has "Execute" right, reports fails with above error.

Thanks,

V

 

[synapsevampire]

This looks like what you want:

http://www.dmgrpt.com/Tips_CEDesc.htm

-k