By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

crystal report asking login for access db

100+
P: 228
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
Share this Question
Share on Google+
4 Replies


Frinavale
Expert Mod 5K+
P: 9,731
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

P: 5
how will i create username and password
Nov 5 '14 #3

Frinavale
Expert Mod 5K+
P: 9,731
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

100+
P: 228
my question is access db not sql server which works like a charm always
Nov 20 '14 #5

Post your reply

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