Re: Accessing a SQL DB from the web - ID's - more info

From: Pete Ruby (pete.ruby@carris.net)
Date: 04/04/03

  • Next message: Mike M: "Setup UID to only execute jobs" 
    From: "Pete Ruby" <pete.ruby@carris.net>
Date: Fri, 4 Apr 2003 11:23:51 -0500

    We are going to give the users a login screen to access the pages in CF.
    Can these usernames be used as the same in SQL?

    Pete

    "Pete Ruby" <pete.ruby@carris.net> wrote in message
    news:uPQTkWs#CHA.3332@TK2MSFTNGP11.phx.gbl...
    > I am creating a SQL DB for use w/ ColdFusion MX for the web. How do I go
    > about setting up a user in the SQL DB to access the DB over the web.
    > Currently, for all our SQL DB's we are using Windows Authenication. In
    CF,
    > I should be able to create an ODBC connection, and specify the
    > username/password, but it doesn't seem to work. If I look at an ODBC DSN
    > pointing to the SQL DB, it is using Windows Authentication. If I change
    it
    > to SQL, and put in a username password, that I have assigned to the DB, it
    > fails. So I am thinking I don't have SQL setup correctly in this area.
    >
    > Thanx,
    > Pete
    >
    >

  • Next message: Mike M: "Setup UID to only execute jobs"

    Relevant Pages

    • Re: SMS 2.0 - Remote tools being denied
      ... SQL query "SELECT * FROM SecurityObjUsers" against your SMS DB. ... of the case used on the usernames and compare to that found in the ... > that I am working on or the client workstation I am trying to access? ...
      (microsoft.public.sms.admin)
    • Microsoft SQL Server password cracking
      ... lists in order to halt some worries. ... The password cracker relies on getting access to the hashes that SQL ... It CANNOT work by simply pointing it at an MS SQL server. ... NT usernames and passwords. ...
      (NT-Bugtraq)
    • Checking the uniqueness of data
      ... I wish to use SQL to interrogate this table to find out how many non-unique ... userNames there are for each accountName. ... I've no idea how to achieve this in SQL. ...
      (microsoft.public.sqlserver.programming)
    • Accessing a SQL DB from the web - IDs
      ... I am creating a SQL DB for use w/ ColdFusion MX for the web. ... for all our SQL DB's we are using Windows Authenication. ... I should be able to create an ODBC connection, ... to SQL, and put in a username password, that I have assigned to the DB, it ...
      (microsoft.public.sqlserver.security)
    • Re: AS400 to Access
      ... I have a vb program that opens an painfully slow ODBC connection to the 400 ... simply do an Insert for each record into our SQL server, ... > and internal employees I think some of the data will be able to be handled ... > adapter then update the Access OLEDB data adapter using the same dataset. ...
      (microsoft.public.dotnet.languages.vb)
    • Quantcast