May 26, 2003 at 12:06 pm
quote:
The error that I get is a crystal reports error. Its "CrystaL Reports Error 533: Unable to open Database"
I would suggest you to check Crystal error meesage 533 in Crystal to see what is missing.
May 26, 2003 at 12:11 pm
I already have, I have even talked to them about this, they were not sure of how to deal with MSDE as they were not familiar with it.
They did try everything they could to resolve the issue but no use. That is why I have turned to forums, just to see if someone has a solution to it.
Thanks
May 26, 2003 at 12:30 pm
Which version Crystal Report do you use? We don't have problem to run Crystal 8.5 against SQL Server 2000. I don't know why it doesn't work with MSDE 1.0. Can you upgrade MSDE 1.0 to MSDE 2000? Or try install MDAC 2.7SP1 and reinstall Crystal Report.
Edited by - Allen_Cui on 05/26/2003 12:30:16 PM
May 26, 2003 at 1:26 pm
We are using crystal 8.5.
I am sorry, I forgot to mention that the same reports also work fine with SQL Server 2000/7.0. But not with MSDE 1.0.
I have not tried it with MSDE 2000. I can do that but I have another question in this regard:
MSDE 2000 is installed with NT Authenticaton and even though I changed it to use mixed authentication, if I try to logon with sa and blank password It still says :"not associaated with a trusted SQL Server Connection". How can I fix that, will I have to install MSDE 2000 with some specific parameters that will give a password to sa?
Thanks for your help, it will solve a big hurdle in my project.
May 26, 2003 at 1:46 pm
Register MSDE 2000 instance with EM and change from there. If you don't have EM, you then have to change the registry.
Change key \\hkey_local_machine\software\microsoft\mssqlserver\mssqlserver\loginmode to 2.
May 26, 2003 at 1:49 pm
Thanks,
I will try that right now.
Viewing 6 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply