WBCOOP is coming!

I have registered to play in the PokerStars World Blogger Championship of Online Poker! The WBCOOP is a free online Poker tournament open to all Bloggers, so register on WBCOOP to play.

Registration code: XXXXXX 781754

SQL 2008 Jobs, Proxy, and Credentials

This is some what confusing...

SQL 2008 seems to be allow you to specify a proxy account to each STEP of a SQL Agent job as well as different proxies for different KINDS of job tasks, ie. SSIS, EXE, ActiveX, etc...

For example, the "owner" of a job has a step that runs a SSIS package. In order to do this, you will need to use or setup a SQL local account or domain account that has permissions to execute SSIS, then create a CREDENTIAL associated with that account on SQL server.

Next, you create a SSIS Proxy account and assign the credential to it. You also associate the "owner" to that Proxy.

Finally, in Properties of the job STEP, you assign the Proxy as the "Run as:" for the step that involves SSIS, in this example.

References:
http://support.microsoft.com/kb/918760
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/10/13/who-owns-my-job-and-who-runs-it.aspx

Access denied to remote DCOM on Win 2003

If you're trying to remotely connect to SSIS on SQL server 2005/2008 and get "access is denied", check the Event Viewer (should be in the System log) on the server, and you should see DCOM errors showing the user trying to do "Remote Activation" and an ANONYMOUS LOGON trying to do a "Remote Access".

• If you do, you'll need to go into Component Services and edit properties on the computer node.
• On the COM Security tab,
• Click the Edit Limits buttons to make the updates.

Reference:
http://msdn.microsoft.com/en-us/library/aa337083.aspx
http://support.microsoft.com/?kbid=892500

NetApp Filer At-A-Glance

What do the colors mean?

The color-coded bar graph for 'Usage by Volume%' has three colors: green, yellow, and red.

- Green: 85% to 100% available disk space on volume
- Yellow: 10% to 15% available disk space on volume
- Red: less than 10% available disk space on volume

The color-coded bar graph for 'Network file Ops/sec' might show up:

- Blue: represents NFS ops
- Red: represents CIFS and/or HTTP ops
- Green: represents HTTP ops/sec
- Yellow: represents iSCSI ops/sec
- Magenta: represents FCP ops/sec


Reference: https://kb.netapp.com/support/index?page=content&id=3010503&pmv=print&impressions=false

Configuring the Integration Services Service

The Integration Services service relies on a configuration file for its settings. By default, the name for this configuration file is MsDtsSrvr.ini.xml, and the file is located in the folder, %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn.

Typically, you do not have to make any changes to this configuration file, nor do you have to change the file's default location. However, you will have to modify the configuration file if your packages are stored in a named instance or a remote instance of Database Engine, or in multiple instances of the Database Engine. Also, if you move the configuration file to a location other than the default location, you will have to modify the registry key that specifies the file location.

Reference:
http://msdn.microsoft.com/en-us/library/ms137789.aspx

More Windows Event Log Info

Logon/Logoff Events

• 528 - Successful logon
• 538 - Logoff
• Logon Types: 2 - interactive; 3 - network; 4 - batch job; 5 - service; 7 - lock/unlock

Object Access

• 560 - Successful object access
• 562 - Object handle closed
• 564 - Object deleted
• 567 - Permission associated with a handle was used.

References:
http://technet.microsoft.com/en-us/library/cc751315.aspx
http://technet.microsoft.com/en-us/library/cc163121.aspx

Windows Event ID List

Reference: http://support.microsoft.com/default.aspx?scid=kb;en-us;174074&sd=tech