Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Aamir
Starting Member
14 Posts |
 Posted - 2004-07-01 : 03:37:51
|
| I am facing a problem with SQL Server and Crystal Reports 9.2. I have created a report based upon a view. When i run program from VB it show following message.Logon FailedDetail: ADO Error Code 0x80040e4DSource: Microsoft OLE DB Provider for SQL ServerDescription: Logon Failed for user saSQL State: 42000Native Error: 18456When i run the same report made in crystal 8 it works without any error. I will be appreciated for the solution.SoftGuru |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-07-01 : 03:55:15
|
| For a start you shouldn't be using sa really...Sounds to me like you have a permissions issue, would be when you set up the OLEDB driver in Crystal.. If possible, try using integrated security... |
 |
|
|
Aamir
Starting Member
14 Posts |
Posted - 2004-07-01 : 07:00:21
|
| Hi, i have already tried it but still the problem is same. But when i omit the sql server password sa. The report run with no error. But for me password is necessary for security reasons. what is ur opinion in this case. greatelly appreciated....SoftGuru |
|
|
|
|
|
|
Problem between SQL Server and Crystal 9.2