Database remote access: password

Discussion in 'ASP .Net' started by =?Utf-8?B?ZGF2aWQ=?=, Nov 2, 2006.

  1. I want to write program to remotely accesss to the database in SQL Server
    under Windows 2000 server.

    Which password should I use? password for database or password for Windows
    2000 server? or something else?

    When I use the password for my account in 2000 server (it allow me to access
    to database locally), it doesn't work.

    Thank you for any help.

    David
     
    =?Utf-8?B?ZGF2aWQ=?=, Nov 2, 2006
    #1
    1. Advertising

  2. David,

    Although it is possible to setup Windows authentication for remote database
    access, it is much easier to use SQL one.

    Find details here:
    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp

    --
    Eliyahu Goldin,
    Software Developer & Consultant
    Microsoft MVP [ASP.NET]


    "david" <> wrote in message
    news:...
    >I want to write program to remotely accesss to the database in SQL Server
    > under Windows 2000 server.
    >
    > Which password should I use? password for database or password for Windows
    > 2000 server? or something else?
    >
    > When I use the password for my account in 2000 server (it allow me to
    > access
    > to database locally), it doesn't work.
    >
    > Thank you for any help.
    >
    > David
    >
    >
     
    Eliyahu Goldin, Nov 2, 2006
    #2
    1. Advertising

  3. Thank you

    David

    "Eliyahu Goldin" wrote:

    > David,
    >
    > Although it is possible to setup Windows authentication for remote database
    > access, it is much easier to use SQL one.
    >
    > Find details here:
    > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetch12.asp
    >
    > --
    > Eliyahu Goldin,
    > Software Developer & Consultant
    > Microsoft MVP [ASP.NET]
    >
    >
    > "david" <> wrote in message
    > news:...
    > >I want to write program to remotely accesss to the database in SQL Server
    > > under Windows 2000 server.
    > >
    > > Which password should I use? password for database or password for Windows
    > > 2000 server? or something else?
    > >
    > > When I use the password for my account in 2000 server (it allow me to
    > > access
    > > to database locally), it doesn't work.
    > >
    > > Thank you for any help.
    > >
    > > David
    > >
    > >

    >
    >
    >
     
    =?Utf-8?B?ZGF2aWQ=?=, Nov 2, 2006
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. AAaron123
    Replies:
    2
    Views:
    2,316
    AAaron123
    Jan 16, 2009
  2. AAaron123
    Replies:
    1
    Views:
    1,385
    Oriane
    Jan 16, 2009
  3. Kenneth McDonald
    Replies:
    0
    Views:
    485
    Kenneth McDonald
    Feb 7, 2009
  4. Ken McDonald
    Replies:
    2
    Views:
    864
    Kenneth McDonald
    Feb 11, 2009
  5. william

    Access remote access database from ASP

    william, Feb 10, 2004, in forum: ASP General
    Replies:
    5
    Views:
    147
    william
    Feb 13, 2004
Loading...

Share This Page