Showing posts with label Configuration. Show all posts
Showing posts with label Configuration. Show all posts

12/01/2011

Exceeded storage allocation. The server response was …

 

I was trying to send a mail via SSIS using the smtp server of windows server 2008, when I got the following error:

“Exceeded storage allocation. The server response was: 4.3.1 Message size exceeds fixed maximum message size.”

To fix this problem, you have to do the following:

Open IIS 6.0 Manager, expand your computer’s name, scroll down to the SMTP server, right-click it and select “Properties” from the context menu.

image

Click the “Messages” tab and set a maximum message size. Alternatively you could allow any size messages by deselecting the “Limit message size to (KB):” checkbox.

image

SSAS port for named instance

 

Here is what I have learnt today while configuring the firewall to allow remote access to a named instance of SSAS.

You have to allow access through the firewall over port 2382. Subsequently you have to allow access over the specific port used by your named instance of Analysis Services.

But how can you determine on which port SSAS is running?

For that you have to open a command prompt and type in the following:

netstat /ao >>c:\output.txt

In the SQL Server Configuration Manager you have to look up the Process ID of your named instance of SSAS (for example: PID=2236).

Then you have to look for the PID in the output file and find the corresponding TCP IP:port information.

Once you know the port used by your named instance of SSAS, you have to make an inbound rule in the firewall to allow remote access to your named instance of SSAS.

Information about the SSAS ports can be found here. Also see my previous post about the firewall settings.

More information about these ports can also be found in “SQL Server 2008 Books Online” – “Configuring the Windows Firewall to Allow SQL Server Access”.

Ports used by Analysis Services

image_thumb1

image_thumb3[4]

11/01/2011

Configure Database Mail

 

In order to send mail using Database Mail in SQL Server, there are 3 steps that need to be carried out.

  1. Create Profile and Account
  2. Enable DatabaseMail on SQL Server Agent
  3. Restart SQL Server Agent

1) Create Profile and Account

3

4

5

6

7

8

9

10

11

12

2) Enable DatabaseMail on SQL Server Agent

1

2

3) Restart SQL Server Agent