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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-30 : 08:10:06
|
| Manikandan writes "I created a report using Crystal report, which pulls data from two SQL Server with the user "rpt", so i created a Linked Server and Created a View on the main server, which was working fine with out a sa password on the linked server.When i changed the password for the linked server password and again refreshed the linked server by providing the password in the lnked server connection.then, when i tried to run the report it gave me an error Failed to open a rowset.Details: ADO Error Code: 0X80040e14Source: Microsoft OLE DB Provider for SQL ServerDescription: Login failed for user 'sa'SQL State: 42000Native Error : 18456If any body aware of this problem please help.take careHave a nice day.Manikandan" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-30 : 09:39:51
|
| Open the Report and Do verify DatabaseMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Problem While uisg a Liked server on Crystal Report