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.