SQl connection string UID and PW

[EESP]

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?

 

[Alex Dybenko]

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

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