• Thanks but I told the junior network admin (jna) that I'm not asking for domain admin, just local admin. I need to be able to set up SSRS, transactional replication, and to maintain uptime of transactional replication.

    I came from a position where the network admin was very knowledgeable yet, when it came to the database boxes, he gave me local admin access and had me apply updates and be responsible for DB uptime. It was a 24/7 operation and we were audited annually for SOX and HIPAA compliance. My new place isn't 24/7, at least not yet. The jna wants to set up replication (because she heard me talk about it), despite never having done it before. She is somewhat of a megalomaniac in that she won't admit that she shouldn't do everything. The bosses are clueless about who should be doing what.

    The jna says she hates to code so she wants me to do all coding yet she thinks setting up and maintaining replication wouldn't involve any code. I suppose she or her husband could set it up by using the GUI but it's silly to have her and hubbie do it when I am DBA. This place makes my head hurt. I'm also doing web development here so I've just been developing that on my own box with my own SQL Server, IIS, Apache, Tomcat, etc. so that I have enough privileges to get everything set up. That way I can avoid the restrictions until I have enough traction to get the privilege situation changed.