how to preview the crystal reports in asp.net

  • Thread starter Thread starter Simone
  • Start date Start date
S

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
 
Simone said:
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?
Click to expand...

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.
 
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.
Click to expand...

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.
 
Back
Top