chaoticsoul

I thought this would be pretty straight forward. I needed to move the system databases for my SQL SharePoint named instance to another drive. Seemed simple enough, I found very detailed instructions on http://msdn.microsoft.com/en-us/library/ms345408.aspx. Everything worked until I tried to move the master database. On step three, I couldn’t connect to the DAC in SQL […]

Put the new Apphosting Runbook in production

New Features include: Export to Excel, Sort by Any Column

Migrated MOSS 2007 to SQL instance on non-default port

Install SQL 2005 Management Studio and SQL Connectivity tools on all MOSS 2007 servers

Install the latest service pack on all servers

Edit the registry on each MOSS 2007 server with the following (Reference […]

netstat -an |find /i “<<SearchTerm>>”

Examples:

Find all connections to/from TCP port 25

netstat -an |find /i “25″

Find all ESTABLISHED connections

Netstat –an |find /i “ESTABLISHED”

Find all ports the computer is listening on

Netstat –an |find /i “LISTENING”

Find all failed outgoing connections

Netstat –an |find /i “SYN_SENT”

Find all connections to/from IP 192.168.1.1

netstat -an |find /i “192.168.1.1″

Search using NETSTAT and return the […]

Installing MOSS 2007 on SQL 2005 Instance on a non-default port:
In order to use an alias for SQL you must have the following installed on your MOSS 2007 servers:
1. Connectivity Tools
2. SQL Management Studio
On each MOSS 2007 server:
1. All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration […]

Move Runbook to Altiris

I created an import rule to automatically import rack and vtag information from NOC database into Altiris

I created an import rule to automatically import server information from current Runbook into Altiris

Created a ASP.NET web page to query Altiris and return server name, OS, OS Service Pack, Tier Level, Service Status, Primary Admin, […]

I completed 70-291 and I now am an MCSE w/Security. Yay!

 
Things I figured out in SharePoint

Connect to a WebDav SharePoint folder on a non-standard SSL port:

\\FQDN@SSL:PORTNUMBER\DavWWWRoot or \\server.test.com@SSL:9566\DavWWWRoot

Map a drive to a SharePoint WebDav folder on a non-standard SSL port:

Net use DRIVELETTER: \\FQDN@SSL:PORTNUMBER\DavWWWRoot or net use S: \\server.test.com@SSL:9566\DavWWWRoot\

How to create a UDC: http://dotnetbuzz.spaces.live.com/blog/cns!F3599E60D988EEB0!249.entry

Submitting InfoPath 2007 […]

Building a test SQL cluster on Dell PowerEdge 2650 and PERC 3/DC Raid Controller
Here is a list of the issues I had while building the SQL 2005 test cluster and the fixes for those issues:
Configure Raid Controller: http://support.microsoft.com/kb/296594
Silence the alarm during configuration: http://www.dellcommunity.com/supportforums/board/message?board.id=pes_hardrive&thread.id=26879&jump=true&c=us&l=en&cs=&s=gen
You receive error messages when you try to set up a clustered instance […]

EMS SCALA export - Created an SSIS package to run a tsql query and export the results to an XML file. I got a start from someone’s blog, but I don’t have the link right now.
Nagios Replacement - Went through each Windows host in the new nagios configuration and made sure they had at least […]

All month long I worked on the PerTrac implementation. Nuff SAID!