RE: SQL DataSource

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@xxxxxxxxxxxxxxxx>
Subject: SQL DataSource
Date: Thu, 24 Aug 2006 13:38:47 -0600
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
Message-ID: <OqjqTT7xGHA.3500@xxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.security
NNTP-Posting-Host: 199.213.91.1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:28380
X-Tomcat-NG: microsoft.public.sqlserver.security

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?




.

Relevant Pages

  • Re: Understanding SQL and Microsoft GP
    ... You shouldn't even need DBO rights. ... DBA and having him profile a session where the Excel reports are being run. ... SQL Server MVP ... access to SQL server because I have no database knowledge. ...
    (microsoft.public.sqlserver.security)
  • Dynamic SQL handling, and edit-grids?
    ... I am generally new to dot.net, coming from "scriptish" web languages ... in ColdFusion one can do something like: ... SQL string at run-time. ... spreadsheet-like grid interface that can accept new data. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL/User Account
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... "RAJ" wrote in message ... SQL Server Service Manager indicated SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Vista hosting XPe tools/db
    ... SQL Express isn't installing that should be there. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Yes - I'm running the script on a machine that has SQL 2005 Express SP1 ... Although I managed to install the SP1 database with no errors, ...
    (microsoft.public.windowsxp.embedded)
  • Re: Cant create DB on remote server
    ... rights in SQL as indicated in the WSS Admin Guide. ... > Also assume that you are installing in Web Farm Mode vs Single Server ...
    (microsoft.public.sharepoint.windowsservices)