da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: MS SQL + Windows Authentication

Forum List » AnyDAC » v 1.x General English

bootsector
User

Expert Boarder

Posts: 45

Karma: 2

MS SQL + Windows Authentication

Posted: 2007/05/29 12:58

Folks,

How can I use anyDAC and get a connection with a MS SQL Server that uses only Windows Authentication?

Furthermore, how can I setup the TCP server port (instead of the default 1433)?

Thanks,

Bruno

Diman

Admin

Posts: 1496

Karma: 19

Re:MS SQL + Windows Authentication

Posted: 2007/05/29 18:06

Hello Bruno

How can I use anyDAC and get a connection with a MS SQL Server that uses only Windows Authentication?
OSAuthent=Yes

Furthermore, how can I setup the TCP server port (instead of the default 1433)?
Use Client Network Utility to create alias. In alias you can specify port number. Then use this alias as the value of Server connection definition parameter.

Regards,
Dmitry

bootsector
User

Expert Boarder

Posts: 45

Karma: 2

Re:MS SQL + Windows Authentication

Posted: 2007/05/30 04:13

Thanks Diman!

Anyway, is it possible to use Windows Authentication and manually specify the domain username and password? Its because my application is running under a user account outside the windows domain, so I can't login by Windows Authentication.

The SQL Server has only Windows Authentication mode enabled. I can't login by SQL authentication

Thanks,

Bruno

Diman

Admin

Posts: 1496

Karma: 19

Re:MS SQL + Windows Authentication

Posted: 2007/05/30 04:16

Hello

No, you cannot.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English