Different User Problem, Please Help

[Sai]

Hi

I have installed/setup SQL Server 2005 using an admin profile user (lets call him AdminUser) of Windows.
I have also installed/setup Crystal Report 10 which is working correctly. I have also saved a report so that it can be used for everyone in the C:\.

When I log in as a non admin profile user (lets call him NormalUser) of Windows and I open Crystal Reports, I can open the file and when I run the report it asks me for a user id and password!!!

The screen title is ODBC (RDO).
'Connection Information
Provide necessary information to log on to the choosen data source

Server:AlarmLogger
User ID:
Password:'

The Server is the name of my table from the Database.

It does not ask me for anything when running the report as the AdminUser.

When I log in as AdminUser and create a new report, for the same screen I can just click Finish and no problems.
However as NormalUser I get a log in error.

As far as I know, I have not set up a username/password onto the database, apart from logging into SQL Server 2005.

Any help will be gladly appreciated.

Thanks

Sai

 

[Kempes]

Hi,

you need to create a datasource for the normal user, otherwise crystal doesn't know what data to access.

Go Start/settings/Control Panel/Admin Tools/datasources.

Configure the relavant source type (under system DSN) for your database.

Now when the user runs the report, select your newly created datasource, and it should run fine.

 

[Sai]

Hi

Thank you for your help.

When I log in as the NormalUser and go the DataSources, under the System DSN tab I can see the datasource I have been using when I was the AdminUser.

I edited so that it no longer checks using windows authenication, but to use a SQL Server authenication instead. (I think this is where I have been going wrong).

Now when I run the report, it still prompts me for a user id and password. I used the user id of 'sa' and the relevant password and it does run the report correctly. However I rather not let the users know the password to the sa user for the database.

Is there any way I can stop it prompting me for the user id and password?
or should I had followed your advice and created a new datasource, but wouldnt that have an affect on the crystal report file?

Thanks

Sai

 

[Kempes]

I think you can just tick the check box for use trusted connection (in crystal when it prompts).

try that! Then no password is needed.

 

[Sai]

Hi

When I tick the check box for trusted connection, I get...

Crystal Reports

Logon failed.
Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open database "Database name here" requested by the login. The login failed.

It works if I dont tick the check box.

Sorry, but do you have any more suggestions?