SQL Server: Can’t access sys.dm_tran_current_transaction

SQL Server: Can’t access sys.dm_tran_current_transaction

Problem:

User doesn’t have access to sql server management views

select transaction_id from sys.dm_tran_current_transaction

Msg 297, Level 16, State 1, Line 1

The user does not have permission to perform this action.

Solution: 

Run the following script. Must be run as a server admin. 

USE master;
GRANT VIEW SERVER STATE TO <User>;

More Reading:

Grant Server Permissions: http://msdn.microsoft.com/en-us/library/ms186717.aspx

sys.dm_tran_current_transaction: http://msdn.microsoft.com/en-us/library/ms186327.aspx

Your current security settings do not allow you to download files from this location.

Problem: I was trying to download something from an ftp server to a windows server 2008 box. and received the following error "Your current security settings do not allow you to download files from this location."

Solution: You need to a an exception in the security section of your Internet Explorer Internet Options.

1. Open IE

2. Open Tools > Internet Options > Security

3. Click on Trusted Sites then the sites button below

4. Enter the URL of the site you're downloading from and click add

5. Done. Retry your download.