473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

crystal report asking login for access db

228 100+
u uI have worked with crystal reports and sql server 2008 before. Connection was modified at run time with no problem.

Now I got an app with access back end which is headache. I cant open any report in other pc after i install app. It keeps on asking for log in. Whats server,username and password for even a insecure db please?
Nov 1 '14 #1
4 12898
Frinavale
9,735 Expert Mod 8TB
You need to create a user in your SQL database so that the application can use that username/password to access the database.

Using the local machine account will be more of a headache in the long run.

-Frinny
Nov 3 '14 #2
how will i create username and password
Nov 5 '14 #3
Frinavale
9,735 Expert Mod 8TB
This is done through SQL Server management tools.
It is a question that is better asked in the MS SQL forum.

Or you could use your current application on running on the local machine to execute a script one time that creates the database user...then remove that code after executing it that one time and change around your connection string to use that newly created database user.


Here is documentation on the Create User command.



-Frinny
Nov 6 '14 #4
samvb
228 100+
my question is access db not sql server which works like a charm always
Nov 20 '14 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: xtanto | last post by:
Hi All, We need to develope application & report that run on windows accessing Oracle on Linux. and we use Crystal Report as reporting tool. Can Crystal Report on windows access...
1
by: Marius Rus | last post by:
Could anyone tell me please how to write from the c# code in an parameter? For example I have an report that it is asking for a client code as the parameter. Now it is showing the interface from...
2
by: aruvel123 | last post by:
i have Created one Crystal report file with MS Accesss. i have working with my system(created System) its work prefectly. but going install my clinet system connection problem is occured. i am not...
0
by: ShakirNSK | last post by:
I am facing a problem when i use to connect crystal report with MS.Access datafile i want to edit in Select query for desire results but on right clicking on command for editing is not enabled while...
1
by: geetharamanan | last post by:
i have upgraded our database from microsoft access 97 to microsoft access 2000. While executing i face problem (Unknown database found) in crystal report 7.0. How to solve this problem. the platform...
0
by: geetharamanan | last post by:
i have upgraded our database from microsoft access 97 to microsoft access 2000. While executing i face problem (Unknown database found) in crystal report 7.0. How to solve this problem. the platform...
5
by: ElTipo | last post by:
Hello People, I made a data base with secure wizard to provide to users a PID and Passwords. I need to extract data from Crystal Reports 7 in this data base but Crystal Reports send me a message...
0
by: Aussie Rules | last post by:
Hi, I am using vb.net 2008, with a crystal report. I created a report in an empty project and was able to run it OK in that project. In my normal vb.net project, I have included the .rpt...
2
by: KMEscherich | last post by:
Hi there, am wondering if there is a way to do the following: I developed a Crystal report that runs against a Clarity table envrionment. The report runs fine. I have been asked to run my...
1
by: patiencer | last post by:
Hi! Good Day to each and everone can you teach me how to make a crystal report in Vb.net using ms access as your back.end i search it already but i can't understand the flow So help me i really...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.