crystal report asking login for access db

[samvb]

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?

[Frinavale]

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

[paulodiol]

how will i create username and password

[Frinavale]

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

[samvb]

my question is access db not sql server which works like a charm always