i use correct account and password , sa and its password in odbc, and i find a sample said give all connection info to all tables , but i find that there are many temp table # in stored procedure, so i just add non # temp tables.
What account should i use? or will i need to add connectioninfo to all temp tables?
If you're using an ODBC connection, you should just use the connection account. Is the database set for SQL Authentication and is SA the dbOwner? Have you looked at the SQL logs?
checked sa, have db_owner right on the database with name dbo, in deployment machine and client machine ie can open crystal report without odbc connection and only show text object.
but with odbc with account sa cause error in web. so far, i still can not find the reason
Server mapping for sa is that user dbo, scheme dbo
SQL Log only show
Date 4/7/2011 10:17:50
Log SQL Server (Current - 4/7/2011 10:17:00)
Source Logon
Message
Login failed for user 'dbo'. [CLIENT: 10.1.99.58]
Fitmation
12 Posts
deploy crystal report web application show logon failed to database
Jun 29, 2011 07:41 AM|LINK
deployment server windows 7 installed crystal report 2008 and visual studio 2008
deploy crystal report web application show logon failed to database
however, it can show normally with visual studio 2008 in the same machine windows 7
deployment
jeff@zina.co...
3379 Posts
MVP
Moderator
Re: deploy crystal report web application show logon failed to database
Jun 29, 2011 05:56 PM|LINK
Permissions and the account are different between IIS and Visual Studio. Use the correct account and ensure it has permissions to the database.
Jeff
Fitmation
12 Posts
Re: deploy crystal report web application show logon failed to database
Jun 30, 2011 09:15 AM|LINK
i use correct account and password , sa and its password in odbc, and i find a sample said give all connection info to all tables , but i find that there are many temp table # in stored procedure, so i just add non # temp tables.
What account should i use? or will i need to add connectioninfo to all temp tables?
jeff@zina.co...
3379 Posts
MVP
Moderator
Re: deploy crystal report web application show logon failed to database
Jul 01, 2011 12:57 PM|LINK
If you're using an ODBC connection, you should just use the connection account. Is the database set for SQL Authentication and is SA the dbOwner? Have you looked at the SQL logs?
Jeff
Fitmation
12 Posts
Re: deploy crystal report web application show logon failed to database
Jul 04, 2011 02:32 AM|LINK
checked sa, have db_owner right on the database with name dbo, in deployment machine and client machine ie can open crystal report without odbc connection and only show text object.
but with odbc with account sa cause error in web. so far, i still can not find the reason
Server mapping for sa is that user dbo, scheme dbo
SQL Log only show
Date 4/7/2011 10:17:50
Log SQL Server (Current - 4/7/2011 10:17:00)
Source Logon
Message
Login failed for user 'dbo'. [CLIENT: 10.1.99.58]
dotnetnerd
136 Posts
Re: deploy crystal report web application show logon failed to database
Jul 04, 2011 02:54 AM|LINK
Hi,
If you got this error
Message
Login failed for user 'dbo'. [CLIENT: 10.1.99.58]
It means that the user dont have the permission to access the database. Please make sure you have tick/granted the db_owner for the username. :)
Windows ASP.NET Hosting | Reseller Hosting | Cloud Hosting
HCamper
8048 Posts
Re: deploy crystal report web application show logon failed to database
Jul 04, 2011 03:28 AM|LINK
Hello @ Fitmation,
A small break in to this thread.
Have you considered using the ASP.NET account?
I think it might make sense for Visual Studio 2008 Crytstal Reports and Projects or Web Sites?
You can add a Login for ASP.NET to SQL Server and use the ASP.NET limited account
for the connections.
Then add the ASP.NET with general permissions level execute,read,list,modify to the Web Site
followed by permissions of execute,read,list,modify,write in the App_Data locations ( Database).
Just a thought.
Martin
Community Member Award 2011
Fitmation
12 Posts
Re: deploy crystal report web application show logon failed to database
Jul 04, 2011 10:52 AM|LINK
checked db_owner has right, got the same error
dotnetnerd
136 Posts
Re: deploy crystal report web application show logon failed to database
Jul 05, 2011 12:51 AM|LINK
Hi,
Also have you check db_denydatawriter and db_denydatareader? Please make sure you dont tick them. Only db_owner.
Please try and let me know. :)
Windows ASP.NET Hosting | Reseller Hosting | Cloud Hosting
Fitmation
12 Posts
Re: deploy crystal report web application show logon failed to database
Jul 05, 2011 05:49 AM|LINK
not tick them originally