Print Page | Close Window

can't connect to SQL

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8163
Printed Date: 01 May 2024 at 4:54pm


Topic: can't connect to SQL
Posted By: AdamField
Subject: can't connect to SQL
Date Posted: 29 Oct 2009 at 8:54am
Hey guys / girls
 
We got here @ the company a SQL server running and i maybe myself a new DB there (newDB_R25)
 
now when in crystal report i connect to that db and i mayde the report (already working for other db's.
 
when using my own windows login i can connect and the report works great
when using other windows logins i get the following error
fout in databaseconnector:4200 [microsoft][ODBC SQL server Driver][SQL SERVER] SELECT permission deniet on object 'receptie', database 'newDB_R25', owner 'dbo' [leverancierscode database:229]
 
any idees ?
 
Greets Adam
 


Replies:
Posted By: hilfy
Date Posted: 29 Oct 2009 at 11:40am
This looks like it's an access rights issue to the database.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window