Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajarajan
Starting Member
48 Posts |
 Posted - 2012-02-07 : 08:50:04
|
| Hi i have developed the custom DLL in .net and Deployed in the SSRS 2008 R2 server, in the Report location “C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin. .” When I deployed the DLL in private assembly and test my report , report execute with no error Same DLL is deployed in the above mentioned location,I get error when the report get executed Can any one help us to solve the issue or can u provide the any link to guide the security settings to be done in the 2008 server to solve the issue (any idea plz share rajarajansudar@gmail.com)Sample which i try Method 1Test case – 1 DLL executed in both local(private assembly) and Server and report show in the text box “ Test Pass”Public static string Test(){Return “ Test pass”}Method 2Test case – 2 DLL executed in local(private assembly)but in the Server got failed and in the report text box “ #error”public static string Returnstring() { SqlClientPermission permission = new SqlClientPermission(PermissionState.Unrestricted); permission.Assert(); string sqlstm = ""; string connectionString = "Data Source=XXX \\XX;Initial Catalog=XXX;User Id=XX;Password=XXXX"; SqlConnection conn = new SqlConnection(connectionString); SqlCommand Command = conn.CreateCommand(); if (conn.State != ConnectionState.Open) conn.Open(); sqlstm = "select getdate() as A "; Command.CommandText = sqlstm; string reader = Command.ExecuteScalar().ToString(); if (conn.State == ConnectionState.Open) conn.Close(); //string reader1 = "Testing DLL for Reporting"; return reader; } any idea plz share rajarajansudar@gmail.com |
|
|
|
|
|
SSRS 2008 R2 custom DLLSecurityPermission error