Board index » delphi » Login information for MS SQL Server

Login information for MS SQL Server

Hi,
I want to use the current Windows user information (username, password) to
log into SQL Server.
How can I do this?
I hope someone can help me.

Jrgen Buschle

 

Re:Login information for MS SQL Server


Look up help on authentication in BOL. There are two types - Windows only,
Windows and SQL Server. Looks like what you are looking for is 'Windows
Only'.

This is a SQL Server setting and you should not have to code for it. Also,
there is a problem using 'Windows Authentication' with SQL2000 clients if
you use BDE.

HTH, DK.

Quote
"Jrgen Buschle" <jbusc...@gis-consulting.de> wrote in message

news:9jk1da$1fl$04$1@news.t-online.com...
Quote
> Hi,
> I want to use the current Windows user information (username, password) to
> log into SQL Server.
> How can I do this?
> I hope someone can help me.

> Jrgen Buschle

Re:Login information for MS SQL Server


Jrgen,

You need to make sure that the USER NAME paramter is blank in
BOTH the MSSQL driver and your alias.

Also make sure that Named Pipes is the first protocol listed in the
MSSQL Client Network Utility.

HTH,
Jim

Quote
"Jrgen Buschle" <jbusc...@gis-consulting.de> wrote in message

news:9jk1da$1fl$04$1@news.t-online.com...
Quote
> Hi,
> I want to use the current Windows user information (username, password) to
> log into SQL Server.
> How can I do this?
> I hope someone can help me.

> Jrgen Buschle

Other Threads