阿俊戰記

因為愛上左Windows Live Writer 既關係, 我決定將blog搬到 blogger啦, yeeeeeeah~~

大家得閒就黎睇下我個靚靚blog 啦, 不過果邊仍然十成九都係睇唔明既post.
http://acarieslee.blogspot.com/

呢排都係同Microsoft  Office SharePoint Server (MOSS) 2007 苦戰中... 其中設定SSO可以話係戰鬥中既表表者.

之前果d sql server既 blog post, 其實最終目的都係一個︰想係 moss 裡面用 Business Data Catalog (BDC) 黎 access (第一步係display) database既資料. 而要完成呢個任務, 就非要動用 moss 既 sso 不可(其實仲有一個方法係 RevertToSelf).

Reference:

Using the Business Data Catalog with Single Sign-On Link
SharePoint 2007 Single Sign-On Setup Link

Overview: SQL Server 2005 default 是不可以做 remote connection 的 (有點難以理解...), 而要設定SQL Server 為可以remote connection 也不是這麼容易的事. 經過一返google以及試驗後, 終於成功以 SQL Server Authentication login 入 remote 既 DataBase.

Reference:  Enable remote connection to SQL Server 2005 Express Link

這個link講的是 2005 Express, 不過其實都是大同小異.

Steps:

1.    enable SQL Server Authentication, 開一個 SQL Server Authentication Login Account (請參照上一個post)

2.    去 "All Programs" => "SQL Server 2005" => "Configuration Tools" => "SQL Server Surface Area Configuration"

3.    揀 "Surface Area Configuration for Services and Connections"

4.    Expand "Server name" => "Database Engine" => "Remote Connections"

5.    揀 "Local and remote connections", 揀埋 "Using both TCP/IP and named pipes"

6.    0向左面 "SQL Server Browser", Expand 開揀 "Services", "Start type" 揀 Automatic, apply then start service.

7.    其實以上步驟已經configure好remote connection, 不過有可能SQL Server 無 enable到 named pipes 同 TCP/IP. 咁就要跟以下步驟黎enable 返

8.    去 "All Programs" => "SQL Server 2005" => "Configuration Tools" => "SQL Server Configuration Manager"

9.    Expand "SQL Server 2005 Network Configuration", 揀 "Protocols for xxxxx", xxxxx 係你 Server Instance 個名

10.    0向右邊enable 返Named Pipes 同埋 TCP/IP, 跟住 restart service

Reference:

Windows Authentication vs. SQL Server Authentication: Link

有沒有試過設定了新的SQL login account卻不能用它connect 到 sql server的經驗呢？
原來sql server 2005 有一個 "authentication mode" 的 setting, 而default是 "Windows Authentication mode", 即是只接受windows authentication, sql authenication 是不行的.

要更改這個setting, 需要login 到 "SQL server Management Studio", 在 object explorer 中right click server 名字, 選 "properties" => "security", 就會見到可以選擇 "SQL Server and Windows Authentication mode" 啦~

如果要新增一個 SQL Authenication Login Account, 則在上面提到的 "properties" => "security" 再選 "Logins", 在右邉 "summary" 空白地方 right-click "New Login..." 就可以了, 記得選 "SQL Server Authenication"...

提多一點, 這裡create出來的account是沒有權限的, 連table也看不到, 要在各database處再添加permission給這個account才可以工作 (例如︰最簡單的觀看 table 內容就只要 "connect" 以及 "select" permission 就ok 了)

Reference:

How to Build a SharePoint Development Machine: Link

Deployment Environment:

Hardware: Virtual PC 1GB Ram
OS: Windows Server 2003 R2 SP2

Steps:

1.   Install .Net framework 3.0

2.   Install and Setup Internet Information Server (IIS)

    2.1    Install IIS

    2.2    Add "Application server" role in "Configure Your Server Wizard (Administrative Tools => Configure Your Server Wizard)

    2.3    In "IIS Manager" => "Web Sites" folder => "Web Sites Properties" => "Service" => "Isolation mode", clear the "Run WWW services in IIS 5.0 isolation mode" check box

3.    Enable ASP.NET 2.0

    3.1    In "IIS Manager" => "Web Service Extensions" folder, Allow "ASP.NET v2.0.50727"

4.    Install SQL Server 2005

5.    Install SharePoint Server 2007

    5.1    Start Setup, enter Product Key

    5.2    Press "Next" until ask to "Choose the installation you want", select "Bacis"

    5.3    When finished, make sure that "Run the SharePoint Products and Technologies Configuration Wizard now" check box is selected

6.    Run "Products and Technologies Configuration Wizard"

7.    Add the SharePoint site to the list of trusted site

8.    Configure proxy server settings to bypass proxy for local address (For Internet Explore Only)

    8.1    In IE "Tools" => "Internet Options" => "Connections" => "LAN settings", select "Bypass proxy server for local address"

9.    Done! Type the IP address of your server in IE to see the result.