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 |
|
ponnurajs
Starting Member
6 Posts |
 Posted - 2006-11-03 : 06:41:41
|
| Hello, we have created one application, using vb.net and sql server 2005. We have deployed that database with our app. We created some crystal reports with this application. The reports datasource is in the form of ADO.NET(XSD) in design time. To run this app. in another client machine, app. is running smoothly. But when i run the crystal reports i am getting the error such as "Login Failed for user 'Administrator'. The user is not associated with a trusted sql server connection" my code for running the crystall report is sRptCon = "Provider=SQLOLEDB;Server=.\SQLEXPRESS;Database=" & Application.StartupPath & "\Database\KmsDb.mdf;User Id=Administrator;Password=;" oOledbCon = New OleDbConnection(sRptCon) sQuery = "Select * From KeyHolders" oOledbDa = New OleDbDataAdapter(sQuery, sRptCon) oOledbDa.Fill(oDs, "KeyStatus") oRpt.Database.Tables(0).SetDataSource(oDs) CrystalReportViewer1.ReportSource = oRpt CrystalReportViewer1.Refresh() I am new to this concept. So pl. guide me if it is possible.Regards,Raju. |
|
|
|
|
|
trusted connection error - reg.