Overview When I install SQL Server 2005 Enterprise on Windows Server 2008 with IIS 7, I was warned that "Microsoft Internet Information Services (IIS) is either not installed or is disabled". Actually this misleading warning means some features of IIS 7 are not installed, and SQL Server 2005 installation needs those features. Reference [...]
Archive for the "SQL Server 2005" category
Overview In my previous post, I discussed about how to setup SharePoint Integrated SQL Server Reporting Services (RS). Now that I have the Integrated RS ready, I can deploy the reports to the SharePoint site. But wait, how can I deploy a Pre-SP2 RS report to SharePoint site? Below shows the steps I used. [...]
Overview This is going to be a long post, in this post I am trying to describe how I setup Integrated SQL Server Reporting Services on a Standalone SharePoint Server. According to my understanding, these steps can be applied to SharePoint Services too. Software Configuration SQL Server 2005 [...]
Overview I came across an issue that the project created from "Report Server Project Wizard" Template in Visual Studio did not deploy successfully and the "permissions granted to user ‘domain\username’ are insufficient for …. (rsAccessDenied)" error was shown. Finally I was able to get it done by restoring the IIS ‘ReportServer’ [...]
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講的是 2005 Express, 不過其實都是大同小異 Steps: Enable SQL Server Authentication, 開一個 SQL Server [...]
Reference: Windows Authentication vs. SQL Server Authentication 有沒有試過設定了新的SQL login account卻不能用它connect 到 SQL server的經驗呢？ 原來SQL server 2005 有一個 "authentication mode" 的 setting, 而default是 "Windows Authentication mode", 即是只接受windows authentication, SQL authentication 是不行的. 要更改這個setting, 需要login 到 "SQL server [...]
Subscribe to this blog