Multiple Versions of SQL Server on a Single Machine - Part 4 on Analysis Services

Problem:

When I try to connect to SSAS from SSMS, I get an error as below:


When I check the application event log, I see:


Solution:

Give the SSAS account Modify permission on the file.



It appear that the SSAS account needs a write/read permission on the file in the beginning. After that, the SSAS database seems to be initialized and synchronized, the explicit permission for the SSAS account is not required anymore. In some cases, I even have to explicitly remove the account from the Security list.

For more information related to this file, see:

http://sqlserver.questionfor.info/q_sql-server_197559.html

Multiple Versions of SQL Server on a Single Machine - Part 2 (on Reporting Services)

I have SQL Server 2005, 2008, 2008R2, and 2012 installed on a Windows 8.1 Prof machine. When connecting to reporting services using SSMS, I have faced a couple of issues.

1. Not like SSMS for database engine, you cannot connect to SQL Server 2008R2 reporting service using SSMS 2012. You will get an error: Report Server WMI Provider error: Invalid namespce (Microsoft.Sqlserver.Management.UI.RSClient). But it is fine to use SSMS 2008R2 to connect to the 2008R2 reporting services.

2. I cannot make SQL Server 2005 Reporting Services working, along with the other three higher versions. Although I am able to install reporting services for SQL Server 2005 (even start/stop the reporting services using SQL Server Configuration Manager), the Reporting Service Configuration Manager CANNOT be properly configured as shown below, despite it is theoretically possible according to http://msdn.microsoft.com/en-us/library/ms143736.aspx.



Multiple Versions of SQL Server on a Single Machine - Part 1 (on Database Engine)

I have SQL Server 2005, 2008, 2008R2, and 2012 on a Windows 8.1 Pro machine.

(1) No problem to open a lower version of SQL Server from a higher version SSM such as opening the SQL Server 2005 Database Engine from SSMS 2012.

(2) SSMS 2008 and SSMS 2008R2 uses the same SSMS interface.

(3) When you open a higher version database engine from a lower version SSMS such as opening SQL Server 2012 database engine from SSMS 2005, you may receive an error message as below: 

Index was outside the bounds of the array. (Microsoft.SqlServer.Smo).

Per Microsoft, this error will not be fixed. Instead, it is recommended to open the database engine with its compatible client tool - SSMS. For more information on this issue, see:

https://connect.microsoft.com/SQLServer/feedback/details/666386/index-was-outside-the-bounds-of-the-array-microsoft-sqlserver-smo-while-connecting-from-ssms-2005-2008

Where is the NET SEND in Windows 8.1?

What is the Net Send Command? 

(from http://pcsupport.about.com/od/commandlinereference/p/net-send-command.htm)

The net send command is a Command Prompt command used to send messages to users, computers, and messaging aliases on the network.
Windows XP was the last version of Windows to include the net send command. The Messenger Service in Windows XP needs to be started to send a net message  The msg command replaces the net send command in Windows 8, Windows 7 and Windows Vista.
The net send command is one of many net commands.

Net Send Command Syntax:

net send {name | * | /domain[:domainname] |/usersmessage [/help] [/?]
e,g, NET SEND AnAccountName "Hello, World"

What is the Msg Command?

(http://pcsupport.about.com/od/commandlinereference/p/msg-command.htm)
The msg command is a Command Prompt command that's used to send a message to one or more users on the network.
The msg command functions similarly to the net send command that was popular in Windows XP but it is not a true replacement for it. See Using the Msg Command to Replace Net Send further down the page.

Msg Command Syntax:

msg {username | sessionname | sessionid |@filename | *} [/server:servername] [/time:seconds] [/v] [/w] [message]
e.g.,: msg Charlie "Hello, World" or msg Charlie Hello World





Where is the IIS Manager in Windows 8.1?

Problem Scenario:

1. I entered inetmgr in the Search box on Windows 8.1, it does not return IIS manager.
2. I entered inetmgr.exe under Run, it returns an error.
3. I went to Control Panel||System and Security||Administrative Tools, IIS manager is not in the list.

Reason: 

I haven't installed the IIS Management Console yet.

Solution:

Control Panel||Programs||Programs and Features||Turn Windows Features On or Off(Left Panel)||Internet Information Services||Web Management Tools||IIS Management Console

After the IIS Management Console is installed, I can get access to the IIS manager in any of the three ways.