"Simone" <oi****@hotmail.comwrote in message
news:11**********************@y5g2000hsa.googlegro ups.com...
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/lib...9(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.