November 12, 2011 at 2:37 am
Hi.
i create a application with c# and sql server .
my application should be implement on the network .so i set up that on the network .but i have a problem that it is make me crazy.in my application i have a reporting system that i designed that with crystal report .but on the network if my clients want to report something my application shows a log in form and it needs user and password of sa.
how can i disable that ????
thanks a lot !!!
---------------------------------------------------
baaaaaaaaaaaaaleh!!! (Ehs_Akb)
November 12, 2011 at 3:43 am
It means User Credentials are not supplied by (& saved in) Crystal Reports while connecting it to SQL Server. Check for Crystal Report forums for more.
November 12, 2011 at 5:17 am
bijarcity (11/12/2011)
but on the network if my clients want to report something my application shows a log in form and it needs user and password of sa.
I do hope you haven't used the sa account for your app. That's a violation of every security practice and is just asking for the app and DB to be hacked. Apps should use an account with minimal permissions, just what they need to do their work, nothing more.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply