May 13, 2009 at 7:37 am
I am not that familiar with SQL Database structures. However, here's what we want to do: We have a SQL Database (SQL 2005) which stores our ERP test data. This is stored on a server running Windows 2003. We have an employee running Crystal Reports on their desktop. We would like to figure out a way for the employee to connect their Crystal Reports to the database running in SQL on the server.
For some reason, the database is not visible from the users desktop. When I load the SQL viewer on the server, it is pointing to: servername\database\erptest
How can I map (??) Crystal reports on the users desktop to that database??
Thanks!!
Mike
May 13, 2009 at 10:46 am
Depending on your sql security strategy ...
1. they should be able to connect directly with windows authentication setting up the connection right within Crystal.
Setup the user in Security for the database with the appropriate roles / permissions.
2. assuming the machines can see each other you can create a DSN that references that database,
and then have Crystal use the DSN. (Control Panel > administrative tools > Data Sources (ODBC) )
The user you use to connect should also be setup on the database under security with the appropriate role / permissions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply