SQl connection string UID and PW

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EESP - 30 May 2006 19:50 GMT

When creating a connection string to SQL Server, are the User ID and
Password parameters mandatory? Does it depend on the server or a
property in VBA?

Reply to this Message

Alex Dybenko - 31 May 2006 07:05 GMT

Hi,
if you connect using SQL Server authentication - then you have to specify
User ID and Password in connection string. But if you are using windows
authentication - then no. Last one is preferred these days

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> When creating a connection string to SQL Server, are the User ID and
> Password parameters mandatory? Does it depend on the server or a
> property in VBA?

Reply to this Message