Thursday, August 22, 2013

Compiler Error Message: CS1009: Unrecognized escape sequence

Compiler Error Message: CS1009: Unrecognized escape sequence
Source Error:
 
Line 16:  { 
Line 17: 
Line 18:    SqlConnection dbConnection = new SqlConnection("server=(Server\Instance); 
Line 19:                                 uid=;pwd=;database=DBname;"); 
Line 20: 


Solution:

SqlConnection dbConnection = new SqlConnection("server=server\\Instance;uid=sa;pwd=;database=DBname;");
Or
SqlConnection dbConnection = new SqlConnection("Server=(local);Integrated Security=true;Initial Catalog=DBname;");

AppStore - Account not in this store. Your account is not valid for use in the US

Upon downloading apps from App Store, the following error message is displayed:Account not in this store. Your account is not valid for use in the US ... 

Solution

Follow these steps:
  • Go to Settings> iTunes Store and App Store> Apple ID
  • In the window that opens, click Logout
  • Reconnect to the AppStore and you will see a message telling you that you'll be directed to the store in your country.
  • Make your selection and try downloading an application from App Store.

Sunday, August 11, 2013

Log Shipping: access is denied to network path

Scenario:
1. Set your SQL Server Logon ID to Domain_a\User_A on Server_A.
   1. Go to services.msc
   2. Click on MSSQLSERVER
   3. Go to Logon Tab
   4. Select the Second Option ("This Account") and select the user Domain_A\User_a
2. Go to Server_B and share the folder. While Sharing, click on permission and Add Domian_a\User_A to the List of Users and Select Full Permission Checkbox.
3. Try running the job Again

Wednesday, June 19, 2013

Windows update cannot currently check for updates, because the service is not running.You may need to restart your computer

  1. Start an elevated command prompt.
  2. Run the following commands hitting enter after each line:

    net stop wuauserv

    cd %systemroot%

    ren SoftwareDistribution SoftwareDistribution.old

    net start wuauserv
  3. Reboot
  4. Run windows updates again


Friday, June 14, 2013

How to Turn Off the Outlook 2007 Sync Log

Microsoft Outlook 2007 maintains a set of logs that help when troubleshooting in the case of errors or emergencies. This is unnecessary for the average user, and it consumes memory and disk space. You can disable all types of logs from within Outlook 2007.

Instructions

    • 1
      Open Microsoft Outlook 2007.
    • 2
      Click "Tools" and "Options."
    • 3
      Click the "Other" tab, and then "Advanced Options."
    • 4
      Uncheck the "Enable logging (troubleshooting)" box.
    • 5
      Click "OK" and then "OK" again. Close Outlook. When you next open it, logging will be disabled.

View e-mail message headers

E-mail message headers provide a list of technical details about the message, such as who sent it, the software used to compose it, and the e-mail servers that it passed through on its way to the recipient.

View message headers

  1. Open a message.
  2. On the Message tab, in the Options group, click the Dialog Box Laucher Icon image.
In the Message Options dialog box, the headers appear in the Internet headers box.


Newly Created Named Instance in SQL Server 2008 R2 cannot be accessed by "Servername\instancename"


This SQL instance can be accessed by port number but not with named instance


To view the instance port
1. Launch SQL Server Configuration Manager
2. Expand SQL Server network Configuration
3. Select one of the instances (e.g) Protocols for CMIS
4. Under 'Protocol Name' right click TCP/IP and select properties
5. Go to I P Addresses tab and find the port number


Configure it to open a port for inbound traffic:

To access the firewall: Press Start -> Type in "Firewall" -> Click on "Windows Firewall With Advanced Security"

You need to configure an inbound traffic rule, like so:

1. Right click "Inbound Rules" on the left pane
2. Choose "New Rule"
3.  Choose "Program"
4. Under "This program path" enter "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe"
5. Action "Allow Connection" continue with Next
6. Profile --> check "Domain" continue with Next
7. Enter the Name "SQL Browser"

Check if your port is now accessible - you might need to restart the Windows Firewall service (under "Services").