Enable Remote Desktop Remotely

Enable Remote Desktop

wmic /node:”computername.domain.local” /USER:”DOMAINuser” RDTOGGLE WHERE ServerName=”computername” CALL SetAllowTSConnections 1

Disable Remote Desktop

wmic /node:”computername.domain.local” /USER:”DOMAINuser” RDTOGGLE WHERE ServerName=”computername” CALL SetAllowTSConnections 0

Source

http://msgoodies.blogspot.com/2005/02/enable-remote-desktop-connections_08.html

Problems login in to Microsoft CRM

When you start Microsoft CRM you get the following error:

An error occurred loading Microsoft CRM functionality 
Try restarting Microsoft Outlook
Contact your system administrator if errors persist
 
CRM Menu is present but greyed out.

You get the following errors in the event viewer:

Event Type: Error 
Event Source: MSCRMAddin
Event Category: None
Event ID: 5990
Date:  4/30/2006
Time:  4:03:53 PM
User:  N/A
Computer: TIGER
Description:
An error occurred retrieving Microsoft CRM synchronization settings from the
server.  Restart Microsoft Outlook and try again. HR=0x80040220. Context=.
Function=CAddin::HrActivateAddin. Line=595.
Event Type: None 
Event Source: MSCRMTracing
Event Category: None
Event ID: 17157
Date:  4/30/2006
Time:  4:03:54 PM
User:  N/A
Computer: TIGER
Description:
CrmTrace was successfully loaded; Tracing Enabled:False, Reporting
Process:OUTLOOK, AppDomain:C:Program FilesMicrosoft OfficeOFFICE11.

The problem is that the user has been set for “Restricted user access
mode”. To fix this log into Microsoft CRM as a system admin, goto the users and edit the user that has the problem. Uncheck the checkbox “Restricted user access
mode” at the bottom of the screen.

Source:

http://groups.google.co.uk/group/microsoft.public.crm/browse_thread/thread/d71f5341b573e25b/73969e734fc35bc5?hl=en&lnk=st&q=crmaddin+5990#73969e734fc35bc5

Changing Cisco VPN Client .pcf files on client computers

I have a customer that uses Cisco VPN Client. They are going to change ISP which means that they are going to change IP adresses. The VPN profiles today are set up using the IP so I found a VB script to edit the pcf file and a login script sample to execute it.

VB Script:

Const ForReading = 1
Const ForWriting = 2




strFileName = Wscript.Arguments(0)

strOldText = "Host=Old Address"
strNewText = "Host=New Address"

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile(strFileName, ForReading)

strText = objFile.ReadAll
objFile.Close
strNewText = Replace(strText, strOldText, strNewText)

Set objFile = objFSO.OpenTextFile(strFileName, ForWriting)
objFile.WriteLine strNewText
objFile.Close

Login Script:

if NOT EXIST("\serverlogs$VPNfixed_" + @wksta + ".txt")
  AT (16,21) "Fixing VPN Files...                "
   
  ; Defining Logfile
  
  $VpnLogfile="\serverlogs$VPNfixed_" + @wksta + ".txt" 

 ; Fixing the files
   
  IF EXIST("C:Program FilesCisco SystemsVPN ClientProfilesFILE.pcf")
   Shell '%comspec% /c \servernetlogonfixvpn.vbs "C:Program FilesCisco SystemsVPN ClientProfilesFILE.pcf"'
  Endif
  IF EXIST("C:ProgramCisco SystemsVPN ClientProfilesFILE.pcf")
   Shell '%comspec% /c \servernetlogonfixvpn.vbs "C:ProgramCisco SystemsVPN ClientProfilesFILE.pcf"'
  Endif

  ; Writing loglines

  Open(1,$VpnLogfile,5)
  $Logline=@Date + "," + @time + "," + @Userid + "," + @wksta + @CRLF
  writeline(1,$LogLine)
  Close(1)
Endif

The login script has some logic checking if the update has been done before in which case it will be skipped. It will also create a logfile for checking which computers has been updated.

Offline Files tab missing

I had a problem today… at a customers laptop the Offline Files tab was missing…

The solution vas a registry setting:

Next, navigate to these Registry keys:
=====
HKEY_Local_MachineSoftwarePoliciesMicrosoftWin dowsNetCache

If the entry for “NoConfigCache” is set to 1 (that’s one), it disables the
tab from appearing. Changing it to 0 (zero) should make it appear. Make
sure to save your changes.

I found the solution here after some googling.

Source:

http://www.tabletquestions.com/windows-xp-tablet-pc-newsgroup/2852-synchronization-offline-files-tab-missing-2.html

GrundläggandeMaintenance Tasks på SQL Server för icke-DB-Admins

Basic install

– Database Components
– Integration Service
– Management tools

Maintenance Plans

Maintenance plan (Kräver Integration Services)

Skapa Backupjobb (Scheduleras dagligen innan så att den är klar innan bandbackup)

Dra in ett Database backup block

  • Välj Databaser
  • Välj Typ
  • Välj Destination

Dra in ett Maintenance Cleanup Task block

  • Välj Backup Files
  • Välj mapp
  • Ställ in “Delete files based on…” till 3 dagar

Dra in ett “History Cleanup Task” block

  • Välj “Local Server Connection”
  • Välj “Backup and Restore history”
  • Välj “SQL Server Agent job history”
  • Välj “Maintenance Plan History”
  • Ställ in tid (ex 4 veckor)

Koppla ihop blocken enligt: Backup – Maintenance Cleanup – History Cleanup

Skapa Indexering och Verifiering (Scheduleras en gång i veckan)

Dra in “Rebuild Index Task” block

  • Välj Databaser
  • Välj “Reorganize pages…”

Dra in “Update Statistics Task” block

  • Välj Databaser
  • Välj “All existing statistics”

Dra in “History Cleanup Task” block

  • Välj “Backup and restore history”
  • Välj “SQL Server Agent job history”
  • Välj “Maintenance plan history”
  • Ställ in tid (ex 4 weeks)

Koppla ihop blocken enligt: Rebuild – Update Stats – History Cleanup

Check Database Integrity (Scheduleras en gång i veckan efter Indexering och verifiering)

Dra in “Check Database Integrity task” block

  • Välj databaser
  • Välj Include indexes

Dra in “History Cleanup Task”

  • Välj “Backup and restore history”
  • Välj “SQL Server Agent job history”
  • Välj “Maintenance plan history”
  • Ställ in tid (ex 4 weeks)

Problems with Managemnet Studio on x64 SQL 2005 server

I had a problem today with editing maintenance plans in Management Studio 2005 on a server with Windows Server 2003 x64.

The error I get is:

Cannot show the editor for this task.
Additional information:
Exception from HRESULT:  0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

The solution I found was this:

%windir%syswow64regsvr32 “%ProgramFiles(x86)%Microsoft SQL Server90dtsbinndts.dll” 

Source:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=609326&SiteID=1

Redirecting OWA

<html>
<head>
<title>HTML Redirection to https:</title>
<META HTTP-EQUIV="Refresh"
CONTENT="1; URL=https://<servername>/exchange">
</head>
<body>
This page is attempting to redirect you to <a href="https:// <servername>/exchange/">https:// <servername>/exchange</a><br>
If you are not redirected within a few seconds, please click the link above to access Outlook Web Access.
</body></html>

Source

http://technet.microsoft.com/en-us/library/aa998359.aspx

Wonderful Error running the Microsoft CRM Registration Wizard

When running the Microsoft CRM Registration Wizard you might bump into the following error:

“The wizard requires an Internet connection to complete registration. Activate your Internet connection if it is disabled. If you do not have an Internet connection, contact Microsoft Business Solutions Support at 1-800-456-0025 to complete registration.”

This happens even if you have internet connection.

There are 2 reasons for this:

  1. There may be incorrect information in the Registration wizard. A valid state/province must be provided in the State/Provice field on the Partner Company Information screen.
  2. Microsoft .NET 1.1 is not able to successfully autodetect proxies. You have to make sure a valid proxy client is installed and/or the settings in Microsoft IE indicates a valid proxy server.

Source

http://blogs.msdn.com/crm/archive/2006/09/19/762184.aspx