SMO System.Security.SecurityException


hello everybody

i wrote backup procedure using smo. procedure works great on dev box, once deployed hosting company's web server throws above exception ("system.security.securityexception: assembly not allow partially trusted callers.")

i did research on subject , seems hosting companies give medium trust in config file , hence cannot access smo.

my hosting admin great fellow (www.alsonetworks.com, recommended!) , willing out, told me he:

a. installed smo 2008 in gac

b. added them medium.config file

even so, still receive error. now, i'm pretty sure he'd possible work (sans giving full trust) i'd got tell him do.

so can advise additional steps can done work?

my site built vb asp.net 3.5 against mssql 2008, hosting site uses mssql 2005.

i appreciate , advice

ps. i've read lot allowpartiallytrustedcallers, understand irrelevant here have not written assembly. ms could/should do. correct?

 

heres code :

    public shared sub backup()         dim sqlcon = new sqlconnection(configurationmanager.connectionstrings("main").connectionstring)         dim conn new serverconnection(sqlcon)         dim srv = new server(conn)         dim db database         db = srv.databases(conn.databasename)         dim bk new backup         bk.action = backupactiontype.database         bk.backupsetdescription = "full backup of database"         bk.backupsetname = "my data backup"         bk.database = conn.databasename         dim bdi backupdeviceitem         bdi = new backupdeviceitem         bdi.devicetype = devicetype.file         bdi.name = path.combine(httpcontext.current.server.mappath("~/backups"), "mydatabase.bak")         bk.devices.add(bdi)         bk.sqlbackup(srv)         dim dcx new dataclassesdatacontext         dim c = (from q in dcx.configs q.configid = curconfig.configid).firstordefault         c.lastbackup =         dcx.submitchanges()

error thrown not here,but in procedure calls "backup" sub

thanks alot!

did try run backup t-sql script using executenonquery in same script? might methods in backup method dont meet security need. in same script, can try , create table. can let know if succeeds?


SQL Server  >  SQL Server SMO/DMO



Comments

Post a Comment

Popular posts from this blog

Reindexing

hi     using sql server 2005 ee sp4. our database size 150 gb. weekly once schedule reindex job. ran 4 5 hours maximum. but recent days getting more 13 hours. the possibilities there? ragu thangavel how perform reindex? maint plan? or check fragmentation first , reorganize fragmented? if later, quite more data nowadays fragmented before. if not, consider doing "smart" defrag (ola.hallengren.com). tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine
Read more

Users List

hello everyone, i"m builing tool tfs , want user list form tfs "assigned to" field. if 1 can post code review i"ll gled.   thanks hello, to imports users tfs, can try this: using microsoft.teamfoundation.server; using microsoft.teamfoundation.client; using microsoft.teamfoundation.workitemtracking.client; icredentialsprovider provider = new uicredentialsprovider (); teamfoundationserver tfs = teamfoundationserverfactory .getserver(“your_server_name”, provider); tfs.authenticate(); igroupsecurityservice gss = ( igroupsecurityservice )tfs.getservice( typeof ( igroupsecurityservice )); identity idsid = gss.readidentity( searchfactor .accountname, "team foundation valid users" , querymembership .expanded); identity [] idusername = gss.readidentities( searchfactor .sid, idsid.members, querymembership .none); foreach ( identity id in idusername) {       if (id != null && id.type == identitytype .windowsuser) ...
Read more

List of charts

Image
i'm trying build report show activity for reservations placed and satisfied month branch. the report has parameter the item category and dataset has fields month category branch reservations placed reservations satisfied on front sheet i've created system wide figures 2 columns per month and a matrix broken down category (e.g. child fiction, child non fiction, adult fiction, adult non fiction) has row , column totals. i want have page each branch in system. what's best way of approaching this?  add parent group based on branch field in row groups  and add page breaks repeat matrix report every branch. please mark answer if post solved problem. milan das SQL Server  >  SQL Server Reporting Services, Power View ...
Read more