I had a task today to add a new Code Group to my PC, using mscorcfg.msc. Having recently learned how to use Powershell, I thought, how can I do the same thing using Powershell (everything looks like a nail when you have a new hammer).
Despite doing a number of different web searches, I haven't yet uncovered any means for getting Powershell to look at the Code Access Policy.
Can anyone suggest a way to do so?
Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also makes use of the Reporting Services. I want to be able to failover the primary server to the mirror, and have the reporting component also failover. Has anybody done this? Any gotchas?
I have an SQL Server 2005 mirrored database, with just the primary and secondary servers, no witness. Tonight the primary has gone down and will not be back on-line for some time yet. The secondary server is still running, but is "Mirrored, Disconnected / In Recovery". How can I get the database back up and running? My applications are all using a string that specifies the primary and secondary servers.
We have a number of Win 2003 servers for which we have Remote Desktop enabled. Each user has their profile edited so that they can only connect for 2 hours maximum and have 30 minutes idle time, after which they are disconnected and the session closed. On one server however, the administrator account does not have the maximum session limit working. We can stay connected for days if we want. Originally this was how it was setup, and we later changed the profile for all users so that there are limits. We have rebooted the server a couple of times since, and the Management Console shows the limits. If we are idle for too long we are disconnected.
Other users are having all the limits observed.
Any suggestions?