SQL DataSource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bad Beagle - 24 Aug 2006 20:38 GMT

I am trying to get a SQL Data Source working with my ColdFusion MX7. I am
trying to connect to a remote SQL server. I have created to identical user
ids on each server so that they can do pass-through authentication. Do I
have to give these users any ntfs rights or are all the rights done through
SQL?

Reply to this Message

Vincent Xu [MSFT] - 25 Aug 2006 02:59 GMT

Hello,

NTFS is not necessary but you have to grant to login enough SQL permission
on objects which you have to use in coldfusion like: Databases, tables,
stored procedures, etc.

Check following article:

http://msdn2.microsoft.com/en-us/library/ms188371.aspx

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================

--------------------

>>From: "Bad Beagle" <maxwelli@nospam.postalias>
>>Subject: SQL DataSource
[quoted text clipped - 17 lines]
>>have to give these users any ntfs rights or are all the rights done through
>>SQL?

Reply to this Message