little_girl

Hi,
I am new to crystal report. I am using Visual studio .net 2005 with crystal report.

This is the scenario:
I want to connect to sql server 2005. so i tried the OLEDB Provider for SQL server, then i am prompt to enter the server name, user id, pwd, database,etc. After entering, i select 'Finish' but an error msg pop up,"Login failed for user <my username>. The user is not associated with a trusted SQL Server connection." Can anyone advise me on how to resolve this problem





Re: Crystal Reports for Visual Studio Crystal Report connection to SQL server 2005

ShEi

check the configuration of your SQL Server....




Re: Crystal Reports for Visual Studio Crystal Report connection to SQL server 2005

mobasha

hi

check the sql server authentication mode,and if u cant log on then u may trying using ODBC