Standard Security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Standard Security alternative syntax
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

Trusted Connection
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Trusted Connection alternative syntax
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connecting to an SQL Server instance
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;

Trusted Connection from a CE device
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;

We have experienced problem how to add MimeType that has two extensions, such as .exe.config

You can not do this using IIS7 GUI manager.

Instead of this use IIS7 console programme:

"C:\Windows\System32\inetsrv\appcmd.exe" set config "Default Web Site/sicer08" -section:system.webServer/staticContent /+"[fileExtension='.exe.config',mimeType='application/octet-stream']"

One more problem we expirienced on Windows 2008 Server 64-bit is that you can not see configuration files. They should be in C:\Windows\System32\inetsrv\Config\ but you can not see them using Windows Explorer, 32-bit application on 64-bit system so you need to find and install Microsoft IIS Admin Tool in order to manage these files (you will get one new icon in IIS7 Management Studio when you click on you IIS webserver and its name is Configuration Editor – you can edit then in Notepad – oh no…).

PROBLEM: Enabling RPC over HTTP on a 64-bit Internet Information Services 7.0 webserver results in application pool failures.

Just run these 4 command and restart IIS and application pools:

1) %windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/globalModules -[name='PasswordExpiryModule'].preCondition:bitness64

2) %windir%\system32\inetsrv\appcmd.exe add apppool -name:RpcAppPool -enable32BitAppOnWin64:false

3) %windir%\system32\inetsrv\appcmd.exe set app “Default Web Site/Rpc” -applicationPool:RpcAppPool

4) %windir%\system32\inetsrv\appcmd.exe set app “Default Web Site/RpcWithCert” -applicationPool:RpcAppPool

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

Just put this command with name of your process:

taskkill /F /IM MyProgram.exe

http://www.shahed.net/post/Hosting-Silverlight-20-in-IIS.aspx

If you host Silverlight 2.0 application in IIS you might find that the silverlight object is not loading. If that’s the case, first thing you should check is the MIME type list. By default, the Silverlight package extension *.xap is not included.

To resolve that, go to IIS Manager, properties of your web site and check the “Http Headers” tab.

Then click the MIME Types button. You should see a list as bellow.

If the .xap extension is not in the list then click New… and add the following entry:

Extension: .xap
MIME type: application/x-silverlight-app

Now, check your site. You should get the silverlight objects properly.

http://weblogs.asp.net/mschwarz/archive/2008/03/07/silverlight-2-not-working-on-production-web-server.aspx

Silverlight 2 not working on Production Web Server

http://learn.iis.net/page.aspx/262/silverlight/

Featured IIS 7.0 Web Hosting

Windows 2008/IIS 7.0 Hosting is Here!

• Starting at $10/mo
• Windows 2008 Servers w/ IIS7
• Access to Microsoft IIS7 Manager
• Trust Level Control
• Pipeline Mode Selector Tool
• ASP.NET 3.5/2.0
• LINQ, AJAX, PHP5

Get 3 Months Free of IIS 7 Hosting Now

advertise here

Introduction

Microsoft® Silverlight^TM is a cross-browser, cross-platform plug-in for delivering the next generation of .NET based media experiences and rich interactive applications for the Web. Silverlight offers a flexible programming model that supports AJAX, VB, C#, Python, and Ruby, and integrates with existing Web applications. Silverlight supports fast, cost-effective delivery of high-quality video to all major browsers running on the Mac OS or Windows.

In most cases, hosters do not need to perform particular deployments to support Silverlight. However, check for the following basic items that could prevent Silverlight from functioning correctly.

MIME Types

In Windows Server 2008 IIS 7.0

All MIME types needed to support Silverlight are implemented by default in Windows Server 2008 IIS 7.0 and Windows Vista SP1.  Windows Vista RTM customers can add mime types by running “IIS Manager”, clicking on “Mime Types”, then clicking “add” and adding the following mime types:

• .xap     application/x-silverlight-app
• .xaml    application/xaml+xml
• .xbap    application/x-ms-xbap

Alternatively, you can add the following mime types to your %windir%\system32\inetsrv\config\applicationHost.config file in the <staticContent> section.

<mimeMap fileExtension=”.xaml” mimeType=”application/xaml+xml” />
<mimeMap fileExtension=”.xap” mimeType=”application/x-silverlight-app” />
<mimeMap fileExtension=”.xbap” mimeType=”application/x-ms-xbap” />

In Windows Server 2003 IIS 6.0

To enable IIS 6.0 in Windows Server 2003 or IIS7 in Windows Vista RTM with the appropriate MIME Types, add:

• .xap     application/x-silverlight-app
• .xaml    application/xaml+xml
• .xbap    application/x-ms-xbap

Here is a VBS script you could run to enable each of these types:

Const ADS_PROPERTY_UPDATE = 2
‘
if WScript.Arguments.Count < 2 then
WScript.Echo “Usage: ” + WScript.ScriptName + ” extension mimetype”
WScript.Quit
end if
‘
‘Get the mimemap object.
Set MimeMapObj = GetObject(“IIS://LocalHost/MimeMap”)
‘
‘Get the mappings from the MimeMap property.
aMimeMap = MimeMapObj.GetEx(“MimeMap”)
‘
‘ Add a new mapping.
i = UBound(aMimeMap) + 1
Redim Preserve aMimeMap(i)
Set aMimeMap(i) = CreateObject(“MimeMap”)
aMimeMap(i).Extension = WScript.Arguments(0)
aMimeMap(i).MimeType = WScript.Arguments(1)
MimeMapObj.PutEx ADS_PROPERTY_UPDATE, “MimeMap”, aMimeMap
MimeMapObj.SetInfo
‘
WScript.Echo “MimeMap successfully added: ”
WScript.Echo “    Extension: ” + WScript.Arguments(0)
WScript.Echo “    Type:      ” + WScript.Arguments(1)

If you copy and paste the code above into a VBS file and save it as ADDMIMETYPE.VBS the syntax to add each type would be:

ADDMIMETYPE.VBS  .xap  application/x-silverlight-app ADDMIMETYPE.VBS  .xaml application/xaml+xmlADDMIMETYPE.VBS  .xbap application/x-ms-xbap

Using the IIS Manager User Interface in Windows Server 2003 IIS 6.0

1. Go to Start\Administrative Tools and run IIS Manager, see figure below:

2. Right click on the server name and select “Properties”, see figure below:

3. In the Properties Dialog, click on the “MIME Types” button, see figure below:

4. In the “MIME Types” Dialog, click the “New” button, see figure below:

5. In the “MIME Type” Dialog enter one MIME Type at the time: