01-25-2008, 11:36 AM
|
#14 (permalink)
|
| Crystal Reports Guru Join Date: May 2006 Location: Philadelphia, PA
Posts: 1,182
Rep Power: 4 
| Quote: Originally Posted by fborchert  - Under the ODBC folder do I select "RE_1"?
- What is the correct username/password to use?
- This access is read-only correct? So no worries of overriding data?
Yes, you select RE_1 unless you have multiple databases. RE_50 is the sample database.
As I mentioned earlier. Quote: Originally Posted by DrewAllen you will need an SQL Server userid. SQL Server does not recognize your RE userid, unless you are using Windows only authentication, which is not typical, because the default is mixed mode authentication. Your DBA should be able to set you up with an SQL userid. Mine are set up with Windows Authentication, so that I can just click on the "Trusted Connection" and log in.
The rights that you have depend on how this SQL userid is set up. Mine is set up as dbo, but anyone else I set up as just data_reader.
Drew
__________________
J. Drew Allen
Children's Hospital of Philadelphia
Crystal Reports and SQL Server Consultant
It is better to live your destiny imperfectly than to live an imitation of somebody else's life with perfection. |