how to preview the crystal reports in asp.net

[Simone]

Hello
I am new to this

I have created a crystal reports and tried using the Crystal Report
Viewer but when I try to preview the report it prompts me for a user
name and password.
I am using a dataset (table adapter) that is linked to a string
connection in my config file that has the user name and password saved
to my sql server.
why is it prompting the login??

I am soo confused. I thought all I had to do is create the crystal
report then use the crystal report viewer to view the report and that
is it?

Your help is greatly appreciated.
Thanks

 

[Mr. Arnold]

Hello
I am new to this

I have created a crystal reports and tried using the Crystal Report
Viewer but when I try to preview the report it prompts me for a user
name and password.
I am using a dataset (table adapter) that is linked to a string
connection in my config file that has the user name and password saved
to my sql server.
why is it prompting the login??

I am soo confused. I thought all I had to do is create the crystal
report then use the crystal report viewer to view the report and that
is it?

Don't hold me to it, but I think it has to do with the SQL Server
Authentication mode you have SQL Server set to.

http://msdn2.microsoft.com/en-us/library/aa176599(SQL.80).aspx

Windows NT Authentication means it will take your user-id and psw that you
logged into the computer with, which I think you would have had to setup the
user account with SQL Server's User Administration.

If SQL Server Authentication is being used, then a user-id and psw must be
setup in Sql Server's UI administration screens.

If Mixed Mode Authentication is being used, then SQL Server will use Windows
Authentication or SQL Server Authentication.

I think you have a SQL Server Authentication issue that is presented when
Crystal Report tries to access the database.

 

[Simone]

Don't hold me to it, but I think it has to do with the SQL Server
Authentication mode you have SQL Server set to.

http://msdn2.microsoft.com/en-us/library/aa176599(SQL.80).aspx

Windows NT Authentication means it will take your user-id and psw that you
logged into the computer with, which I think you would have had to setup the
user account with SQL Server's User Administration.

If SQL Server Authentication is being used, then a user-id and psw must be
setup in Sql Server's UI administration screens.

If Mixed Mode Authentication is being used, then SQL Server will use Windows
Authentication or SQL Server Authentication.

I think you have a SQL Server Authentication issue that is presented when
Crystal Report tries to access the database.

I am using windows authentication in my table adapter. when I run the
query it doesn't ask for user id or pass. However the crystal reports
doesn't see that the password and user id are part windows
authentication. I am wondering if this is something that has to be
done with crystal reports itself.

Thanks.