I am trying to specify some custom database constraints like:

- a database connection string should not include a username & password (but only Windows integrated authentication)

- a dabase connection string should not include a Network library setting or a port number in the data source

-

I thought it would be quite simple, but I've been struggling for several hours with no result. Any help is appreciated.

Hello
Could you please explain where and how you are trying to configure this constraint.

Thanks
Brian [MSFT]
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.

Well, that's my problem, I don't know where or how to define it in the Logical Datacenter Diagram. I tried the logical host, the server endpoint, the client endpoint, but none of these shapes seem to have any properties that will allow me to express the constraints I want to express.

Ideally, I'd like to be able to define it on the Database logical host, because it is a constraint imposed by the SQL Server infrastructure (i.e. authenticate via Windows Integrated and not via SQL Server security).

Thanks,

Rossen

Hello
Did some checking and it looks like there is no way to create a ConnectionStrings constraint. If you have policies that state how an application should connect to a database and what information can be stored in the connection string I would suggest that this be part of your product specs and that you use code review to validate that developers are following this policy.

The other thing you can try is create a unit test that will check config file for connectionStrings section and then verify that the connectionString meets your policies.

Thanks
Brian [MSFT]
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.

Does this answer your question, Rosen? If not, please unmark Brian's answer. Thanks!

Yes, this answers my question. Thank you. (Apologies for the delay.)

Regards,

Rossen