Friday, December 3, 2010

Linked Servers in SQL

http://www.databasejournal.com/features/mssql/article.php/3691721/Setting-up-a-Linked-Server-for-a-Remote-SQL-Server-Instance.htm

Share desktop via Communicator Web Access with any user

If you need to share your desktop using OCS with users outside your company network then you can use Communicator Web Access (CWA) to achieve this.

First, open the OCS Admin console on your OCS server > Global Properties > Meetings > select Default Policy > Edit > Check “Enable Program and Desktop Sharing” and “Allow control of shared programs and desktop”.


Then, go back to the Meeting tab and select “Allow users to invite anonymous participants” from the Anonymous Users dropdown.


Once the server is setup, log in to CWA > Meet Now > Invite (using email) > send the URL to the other party > when link is accessed externally the other party will get the screen below > select Yes > type Name > Join.
Now share your desktop from OCS as you would normally!

Enable logs for RRAS

To help in troubleshooting VPN connection issues, it would be good to have logging enabled on your VPN server. To do so, follow the steps below:
  1. To enable RAS logs run “netsh ras set tracing * enabled” from a command prompt.
  2. Try to connect.
  3. Disable the logs by running “netsh ras set tracing * disabled” from a command prompt.
  4. Check the logs at %windir%\tracing directory.
Don't forget to check the Event Viewer --> System logs too.

Moving/Exporting VHDs in Hyper-V

If you need to move VHDs to a different HDD on the same physical host, this is not ideal but should suffice:
http://blogs.msdn.com/b/virtual_pc_guy/archive/2008/08/26/hyper-v-export-import-part-1.aspx

NOTE: Exporting is usually used to move a VHD to a different physical host.

Thursday, December 2, 2010

Managing XML files in Hyper-V

http://msmvps.com/blogs/virtualreality/archive/2009/03/26/how-to-manipulate-hyper-v-vm-symbolic-links-or-how-to-unregister-and-register-virtual-machines-without-deleting-them.aspx

Log in as Administrator even if it's disabled

If you need to log into a server as a local admin but the account is disabled, then you may have tried to boot in Safe Mode and clear the 'Account is disabled' checkbox for the Administrator account in Server Manager/Local Users and Groups.

Unfortunately, Server Manager does not work in Safe Mode. To get around this, type 'net user administrator /active:yes' at a command prompt then restart.

Service Accounts with non-expiring passwords

http://www.windowsitpro.com/article/security/Service-Accounts-Can-Be-Secure-Yet-Have-Non-Expiring-Passwords.aspx

SQL Server log files

To view log files for SQL Server, the default location is Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.

Wednesday, November 24, 2010

Moving data directories in SQL Server 2005

If you ever need to move the data directories in SQL Server 2005 after the install, here's how:
  1. to set up a new location for new DBs only, open SQL Server Management Studio (SSMS) --> rightclick the instance --> Properties --> Database Settings --> change the default data and log directories.
  2. for any user DBs already created, you can use 'detach and attach' in SSMS - http://msdn.microsoft.com/en-us/library/ms187858(v=SQL.90).aspx
  3. for system databases, it's a bit more tricky but at least it's well documented, try this: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx
Easy!

Monday, November 22, 2010

Connect to Windows server from Mac

If you need to connect to a Windows server from a Mac, open a Finder window --> Go --> Connect to server --> 'smb://servername/servershare'

Presto!

Thursday, November 18, 2010

Supply alternate Windows credentials to SSMS

If you need to log into SQL Server Management Studio with a different set of credentials to the one you are already logged into, it is possible to run SSMS from a CMD prompt with a different username:

>runas /user:DOMAIN\USERNAME “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”

Type in the associated password when it prompts you and voila!

Update Security State Assesment Report for ForeFront

Sometimes you need a PC to update its status to the FFS server so that it can update its status to the report

To do this, go to C:\Program Files\Microsoft Forefront\Client Security\Client\SSA on the local PC and run FcsSasOnDemand.exe. Check taskmgr for the process, it should take around 18MB of RAM while it's running. Give it about 2-3mins then the RAM usage should drop down to about 500KB or so.
Once that is done, refresh the report and it should be updated!



Use this when you have updated any outstanding issues on a PC and need to see/print an updated report.

init.js - library not registered?

Java error?
Trying to open a Sharepoint 2007 site?
Running IE?
Have Office 2010 64-bit installed?
If you're getting a init.js - library not registered error, try this:

Open a CMD prompt, and navigate to C:\Program Files (x86)\Microsoft Office\Office14.

Type regsvr32 name.dll--> Enter.

Restart IE.

Done!

Tuesday, November 16, 2010

Need to know which host a VM is on?

Check this registry key, couldn't be easier, the host does need to be running Hyper-V though:
[HKLM\SOFTWARE\Microsoft\Virtual Machine\Guest\Parameters]

More info, including Powershell script here:
http://social.technet.microsoft.com/wiki/contents/articles/hyper-v-how-to-find-the-host-of-a-vm.aspx

Friday, November 12, 2010

Good article on Windows Server Backup on Server 2008 R2

http://searchsystemschannel.techtarget.com/generic/0,295582,sid99_gci1514371,00.html

IPv6 > IPv4

http://www.metro.co.uk/tech/847019-internet-will-soon-run-out-of-addresses

While this has been known for quite a while by most IT Professionals, it's not really something you would expect to be in a circular like the Metro whose core audience is not technical. Maybe a move to finally get things moving over to IPv6, but by who? Government, IT industry, or tech companies who can hope to gain by the sudden interest in IPv6? Who knows...

Wednesday, November 10, 2010

The future of Windows

http://www.windowsitpro.com/article/windows-7/Windows-7-Deployment-Trends.aspx

Sounds about right.. especially with Exchange, SharePoint, Lync (aka OCS) flying in the cloud plus InTune and App-V/VDI getting more traction with IT staff.

Getting input from user in VBS script

If you need to get some input from a user (from a CMD prompt) to store in a variable, use:

Wscript.StdOut.Write "Enter text: "
strVariable = Wscript.StdIn.ReadLine

Easy!

Find an email address in Active Directory

If you have ever needed to find an email address being used by a user/contact/distribution list/etc in AD, then read on:
  1. Open your ADUC MMC, rightclick Saved Queries --> New --> Query --> type a name and description (if you want) --> Define Query
  2. In the Find dropdown box, select Custom Search --> Advanced --> type '(proxyAddresses=smtp:email@domain.com)' (substituting the email address you are looking for) --> OK --> OK
  3. Create as many as you need, or just create one and edit the query as you need it.

SQL Server install and File & Folder Compression

If you need to install SQL Server on a volume and have enabled File & Folder compression on it, the installer will not allow you to continue as a 'compressed volume does not guarantee sector-aligned writes which is needed to guarantee transactional recovery in some circumstances.' Got that? Good.

http://support.microsoft.com/kb/231347

Tuesday, November 9, 2010

Great resource for the 70-642 exam

http://kissdeath.wordpress.com/2009/06/16/70-642-resources/

Re-Installing Daemon Tools Lite (and SPTD) on Windows 7

Steps to re-install SPTD on Windows 7:

1.) Open regedit. And find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\sptd.
2.) Delete that folder "sptd" in the registry. If you can't, just right-click the folder, and click Permissions. Ask for "Full Control". Do this also to a sub-folder of "sptd" namely "cfg" (i actually already deleted it so i forgot). Just find ways to delete the "sptd" folder in the registry.
3.) Now rename or delete the 'sptd.sys' file found on Windows\system32\drivers.
4.) Download the newest SPTD Layer version "http://www.duplexsecure.com/en/downloads". Install and wait for confirmation to reboot.
5.) After reboot. Try opening the SPTD layer installer again and see if it tells you that SPTD layer is already installed. If it says so, continue on installing your Alcohol 120 or Daemon Tools.

64-bit?

Open regedit and look for this key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\Root\LEGACY_SPTD, try to delete it. If you can’t, try this: go folder by folder (0000 and control), open the permissions dialog, go to advanced, Owner and take ownership of the folder. Don’t try to apply the owner recursively, you have to set it on each individual folder. Then, in the security tab grant full control to “everyone” (again, folder by folder). Now you should be able to delete it. I also deleted the same entry in ControlSet001 and ControlSet002.

Finally, just in case, delete this entry too: HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\eventlog\System\sptd

Now run SPTD setup again, you should be able to install it and after a reboot install Daemon Tools.