Change in SQL Connection String?

[KevinBarnett]

Thanks Nathan, it worked!

Next question:

The windows app exe successfully connects to SQL. But the DLL running inside AutoCAD fails to connect. I havent changed the connection string, are there additional parameters needed to run within Acad?

My string contains these parameters:

Initial Catalog
Data Source
Packet Size
User Id
Password

The error message I get is:

Request for permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Any ideas?

Thx a stack,
Kevin.

[KevinBarnett]

Thanks Nathan, it worked!

Request for permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.



Connection error resolved!! The problem was in the permissions.
Find mscorcfg.msc and run it. Then set the permissions as required.

Good Luck!

Kevin.