Skip to Content
author's profile photo Former Member
Former Member

Crystal log on issue to SQL 2008

Hi All

I have the prepackaged version of Crystal Reports that came with Visual Studio 2003. I used this previously to create (and use!) reports based on a SQL SERVER 2005 edition.

I have since moved firms and whilst I use the same version of VS SQL server is 2008.

I can create the report, I can browse through the data (in design time) I can view all the other tables/views in my database

I use integrated security on the server which is local to my machine. My log in has the highest permisions you can get (I'm a SYSADMIN); indeed I have even tried to create a 'crystal' log in with a password to connect to the database but EVERY time I try and open the report in run time I get prompted to log onto the database.

Its almost as if the connection detials are 'forgotton' when the app is compiled

Any thoughts as to what caused this weird error?!

Thanks in Advance

Chris

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 03:44 PM

    Hi, Chris;

    Are you passing your logon credentials to the report in your .NET code? Do you have any subreports in the report?

    Have a look at our code samples for logon code.

    https://www.sdn.sap.com/irj/boc/businessobjects-samples?rid=/webcontent/uuid/80774579-b086-2b10-db91-ed58c4dda375

    Regards,

    Jonathan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Don Williams

      Yes thats what I've had to do.

      When I selected OLE DB SQL SERVER as a dataprovider my instance didnt show up; although when I went so far as to type the instance in instead of relying on the 'auto fill' box it worked!

      Proof that been lazy doesnt work!!

      PS I think the web registration for the VS2003 has been disabled ... any ideas on that?!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.