Brainlitter - Inside the mind of Sean Wallbridge

Dad. Husband. Drummer. Learner of Things.

Latest Posts

IP Addresses bound to hidden NIC (usually in a VM Guest)

Getting this error? The IP address XXX.XXX.XXX.XXX you have entered for this network adapter is already assigned to another adapter Name of adapter. Name of adapter is hidden from the network and Dial-up Connections folder because it is not physically in the computer or is a legacy adapter that is not working. If the same …

Read on

Vista ticking you off, particulary with TCP/IP Network problems?

Windows Vista ‘TCP Scaling’ is on by default in Windows Vista (along with an IPV6 stack) and is causing difficult to diagnose problems with routers, etc. that do not support or work well with this feature. To turn it off:Run a Command Prompt as Administratornetsh interface tcp set global autotuninglevel=disabled To turn it on:netsh interface …

Read on

SQL 2005 Error

Ok, maybe I missed something but this seems like a long winding error that was easily resolved (and not in the manner the popup suggested) by simply starting the SQL Agent Service (made sense to me, I was trying to create a database maintenance plan, whether standard or with the wizard). ‘Agent XPs’ component is …

Read on

Sharepoint SSO – Error when enabling

Ok, ran across this one tonight when trying to enable the SSO account on MOSS 2007: SSO Error: You do not have the rights to perform this operation. In the end, I did two things (I think correctly) to fix this: 1. logged into the console using the account I wanted used for sharepoint SSO …

Read on

Rename a SQL 2000 or 2005 Server

I’ve had to do this on occasion and it was worth bookmarking. As well, there is more to considering renaming a SQL Server than just SQL or Windows. If you just rename a SQL Server, SQL will bitch … so here are the basics to be done … (as well as checking logs, modifying backups, …

Read on

SQL Database Shrink/Truncating

Seems everytime I have to do this, I need to find the bloody syntax. So, here it is, so I can find it again fast next time 🙂 DBCC SHRINKFILE(DATABASE_NAME_log, 2) https://support.microsoft.com/kb/272318/en-us Powered by www.itgroove.net DBCC SHRINKDATABASE (DATABASE_NAME, 10);GO http://msdn2.microsoft.com/en-us/library/ms190488.aspx You may need to backup the transaction logs (and the database of course) in order …

Read on