Board index » delphi » Connecting to MS SQL server using NT security

J

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Connecting to MS SQL server using NT security

I have Delphi 5 running with a SQL Server on Windows NT and I want to let my
application connect using NT security so I made the necessary accounts on th
SQL server, which is running locally.

If I specify no account or password it still doesn't use NT security but
still logs on as dbo/sa. What should I do to make it work? I have removed
all usernames in the BDE, in the driver section as well as in the alias.

Jack

Reply by e-mail is appreciated, the address is valid.

 
J

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Connecting to MS SQL server using NT security


Found some of the problem: When I check SYSTEM_USER it gives me the NT login
name that is passed but when I check USER or CURRENT_USER it always gives me
"dbo". The account I use is a admin account.

Am I still missing something, why is this?

Quote
"J" <nos...@umbra.demon.nl> wrote in message

news:944415638.22642.0.pluto.d4ee332d@news.demon.nl...
Quote
> I have Delphi 5 running with a SQL Server on Windows NT and I want to let
my
> application connect using NT security so I made the necessary accounts on
th
> SQL server, which is running locally.

> If I specify no account or password it still doesn't use NT security but
> still logs on as dbo/sa. What should I do to make it work? I have removed
> all usernames in the BDE, in the driver section as well as in the alias.

> Jack

> Reply by e-mail is appreciated, the address is valid.

BPMargoli

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Connecting to MS SQL server using NT security


Jack,

By default, when your are using NT authentication, and you have logged in
using an NT Administrator account, MS SQL Server maps the logon to the sa
account.

Quote
J <nos...@umbra.demon.nl> wrote in message

news:944434215.4251.0.pluto.d4ee332d@news.demon.nl...
Quote
> Found some of the problem: When I check SYSTEM_USER it gives me the NT
login
> name that is passed but when I check USER or CURRENT_USER it always gives
me
> "dbo". The account I use is a admin account.

> Am I still missing something, why is this?

> "J" <nos...@umbra.demon.nl> wrote in message
> news:944415638.22642.0.pluto.d4ee332d@news.demon.nl...
> > I have Delphi 5 running with a SQL Server on Windows NT and I want to
let
> my
> > application connect using NT security so I made the necessary accounts
on
> th
> > SQL server, which is running locally.

> > If I specify no account or password it still doesn't use NT security but
> > still logs on as dbo/sa. What should I do to make it work? I have
removed
> > all usernames in the BDE, in the driver section as well as in the alias.

> > Jack

> > Reply by e-mail is appreciated, the address is valid.

Other Threads

1. Can't connect to SQL Server 7 using NT Security using the BDE

2. MS SQL Server / mixed security / Connecting

3. Connecting to MS SQL Server 7.0 with NT authentication

4. Problems connecting to MS SQL Server using 32 bit BDE

5. Problem connecting to MS SQL Server 6.5 using the BDE/ODBC

6. SQL Server NT Security and BDE

7. Help: Connecting 95 Client to NT Server using DCOM

8. Connecting BDE to SQL Server 7.0 via Windows NT Authentication

9. Creating MS SQL Server database in the specific path Using SQL-DMO

10. DE problem with connection on SQL Server 7.0 without connect to the NT Lan