官术网_书友最值得收藏!

Modifying the logon account for the Intelligence Server

As said before, the SQL Server LocalDB engine runs as a user application, hence it is only accessible from the currently logged on user. We will now modify the credentials of the MicroStrategy Intelligence Server so that it can connect to the database instance that is running in the user context.

I'm hearing the screams of the security-wise system administrators: of course, you wouldn't want to do this in a production environment as it can pose serious security risks, but here we are in a training environment.

Getting ready

If the current user has no password, create one before proceeding.

How to do it...

Follow these steps to modify the startup account for the Intelligence Server:

  1. In Start | Run dialog, type services.msc.
  2. This will open the Services console; scroll down to find MicroStrategy Intelligence Server, it is now executing with Local System credentials, double-click on the service.
  3. Select the Log On tab and click on the This account radio button.
  4. Then type your current username and password in the corresponding text fields below.
  5. Now click on OK to close the dialog box.
  6. A message will warn you that the user has been granted the right to log on as a service. Click on OK and then on OK again at the second warning telling you that you should restart the service. We'll do it in a moment.
  7. Right-click on the MicroStrategy Intelligence Server service and select Restart from the context menu that appears.

How it works...

Most of the services in Windows run with a special account called Local System. In our case, the Intelligence Server service must be able to connect to a SQL Server instance that is running under the currently connected user context. This is why we need to run the Intelligence Server as "ourselves", so that it can see the database instance.

There's more...

Restarting the Intelligence Server service will take some time, in case of any error the service won't restart; you probably mistyped the password or the username; double check and retry. Please keep in mind that Windows will not allow blank-password users to log on as a service.

Note

You can watch a screencast of this operation at:

主站蜘蛛池模板: 满城县| 鄂温| 宜君县| 常熟市| 东宁县| 锦州市| 葫芦岛市| 泰来县| 盘山县| 山阳县| 济宁市| 梅河口市| 临城县| 延川县| 通许县| 东乌珠穆沁旗| 兴国县| 哈密市| 平潭县| 乌兰浩特市| 疏附县| 克山县| 阳东县| 开江县| 锡林郭勒盟| 远安县| 尼木县| 巴彦淖尔市| 镇原县| 安新县| 安阳县| 宣汉县| 炉霍县| 谷城县| 台前县| 松溪县| 古丈县| 临泉县| 宜州市| 富民县| 揭阳市|