Exchange Server or NS filtering email addresses?

My Notification Services (NS 2.0 SP1) application works fine, except one big problem:

I am using a built-in SMTP provider, and notifications are delivered ONLY to those subscribers who have email addresses within our company's domain.

That is, all subscribers with addresses like someone@.ourcompany.com always get their notifications, whereas any other email addresses do not work. I tried my gmail.com, aim.com, and optonline.net email addresses, and none of them ever received a notification, not even once.

As soon as I change a particular subscriber's email address from whatever to anybody@.ourcompany.com (whether I do it via SMI or directly in the NS subscribers table, does not matter), it works again.

So, something is filtering emails based on the recipients' addresses.
I do not know for sure whether it's done by NS or by the SMTP server, but the situation is the same regardless of whether I use my local machine's SMTP server or our company's MS Exchange Server 5.5 (I specify it only in the InstanceConfiguration.xml file).

Could someone point me in the right direction as to where to look for what's causing this kind of filtering, please?

Thank you very much!Answering my own question...
Here's what the Exchange Server 5.5 returns in an exception message:
The server rejected one or more recipient addresses. The server response was: 550 Relaying is prohibited.
It's a spam-filtering -related feature.

excessive network traffic

Hi all,
I have a Win2000 server with Exchange2003 and SQL
server2000 SP1.
The system seems to work OK, but after about 1 hour after
startup, the SQL server starts to generate networktraffic
that completely floods the network. It is now impossible
to log into the server, get on the network or access the
internet from any workstation that is connected to the
network. In about one hour more than 50.000.000 network
packets are sent into space. When I disconnect the
internet connection, it just continues to do so. When I
stop the SQL service in the service manager, traffic stops
and everything works again.
Any thoughts?
Piet Koenekoop
"Piet Koenekoop" <pietkoenekoop@.hotmail.com> wrote in message
news:1baf501c42130$42cc0430$a501280a@.phx.gbl...
> Hi all,
> I have a Win2000 server with Exchange2003 and SQL
> server2000 SP1.
> The system seems to work OK, but after about 1 hour after
> startup, the SQL server starts to generate networktraffic
> that completely floods the network. It is now impossible
> to log into the server, get on the network or access the
> internet from any workstation that is connected to the
> network. In about one hour more than 50.000.000 network
> packets are sent into space. When I disconnect the
> internet connection, it just continues to do so. When I
> stop the SQL service in the service manager, traffic stops
> and everything works again.
> Any thoughts?
I'm no expert, but the symtoms looks like Slammer virus.
Steven Ung
"The source of all greatness lies within you" - Anonymous
|||Yep, looks like the slammer virus to me as well...
Update your SQL Server to SP3a, and reboot... and life gets good again...
"Piet Koenekoop" <pietkoenekoop@.hotmail.com> wrote in message
news:1baf501c42130$42cc0430$a501280a@.phx.gbl...
> Hi all,
> I have a Win2000 server with Exchange2003 and SQL
> server2000 SP1.
> The system seems to work OK, but after about 1 hour after
> startup, the SQL server starts to generate networktraffic
> that completely floods the network. It is now impossible
> to log into the server, get on the network or access the
> internet from any workstation that is connected to the
> network. In about one hour more than 50.000.000 network
> packets are sent into space. When I disconnect the
> internet connection, it just continues to do so. When I
> stop the SQL service in the service manager, traffic stops
> and everything works again.
> Any thoughts?
> Piet Koenekoop
|||Thanks a lot for the two suggestions. The Slammer virus was not detected by the AV software, but the installation of SP3 has solved my problem.
Piet Koenekoop

excessive network traffic

Hi all,
I have a Win2000 server with Exchange2003 and SQL
server2000 SP1.
The system seems to work OK, but after about 1 hour after
startup, the SQL server starts to generate networktraffic
that completely floods the network. It is now impossible
to log into the server, get on the network or access the
internet from any workstation that is connected to the
network. In about one hour more than 50.000.000 network
packets are sent into space. When I disconnect the
internet connection, it just continues to do so. When I
stop the SQL service in the service manager, traffic stops
and everything works again.
Any thoughts'
Piet Koenekoop"Piet Koenekoop" <pietkoenekoop@.hotmail.com> wrote in message
news:1baf501c42130$42cc0430$a501280a@.phx
.gbl...
> Hi all,
> I have a Win2000 server with Exchange2003 and SQL
> server2000 SP1.
> The system seems to work OK, but after about 1 hour after
> startup, the SQL server starts to generate networktraffic
> that completely floods the network. It is now impossible
> to log into the server, get on the network or access the
> internet from any workstation that is connected to the
> network. In about one hour more than 50.000.000 network
> packets are sent into space. When I disconnect the
> internet connection, it just continues to do so. When I
> stop the SQL service in the service manager, traffic stops
> and everything works again.
> Any thoughts'
I'm no expert, but the symtoms looks like Slammer virus.
--
Steven Ung
"The source of all greatness lies within you" - Anonymous|||Yep, looks like the slammer virus to me as well...
Update your SQL Server to SP3a, and reboot... and life gets good again...
"Piet Koenekoop" <pietkoenekoop@.hotmail.com> wrote in message
news:1baf501c42130$42cc0430$a501280a@.phx
.gbl...
> Hi all,
> I have a Win2000 server with Exchange2003 and SQL
> server2000 SP1.
> The system seems to work OK, but after about 1 hour after
> startup, the SQL server starts to generate networktraffic
> that completely floods the network. It is now impossible
> to log into the server, get on the network or access the
> internet from any workstation that is connected to the
> network. In about one hour more than 50.000.000 network
> packets are sent into space. When I disconnect the
> internet connection, it just continues to do so. When I
> stop the SQL service in the service manager, traffic stops
> and everything works again.
> Any thoughts'
> Piet Koenekoop|||Thanks a lot for the two suggestions. The Slammer virus was not detected by
the AV software, but the installation of SP3 has solved my problem.
Piet Koenekoop

excessive network traffic

Hi all,
I have a Win2000 server with Exchange2003 and SQL
server2000 SP1.
The system seems to work OK, but after about 1 hour after
startup, the SQL server starts to generate networktraffic
that completely floods the network. It is now impossible
to log into the server, get on the network or access the
internet from any workstation that is connected to the
network. In about one hour more than 50.000.000 network
packets are sent into space. When I disconnect the
internet connection, it just continues to do so. When I
stop the SQL service in the service manager, traffic stops
and everything works again.
Any thoughts'
Piet Koenekoop"Piet Koenekoop" <pietkoenekoop@.hotmail.com> wrote in message
news:1baf501c42130$42cc0430$a501280a@.phx.gbl...
> Hi all,
> I have a Win2000 server with Exchange2003 and SQL
> server2000 SP1.
> The system seems to work OK, but after about 1 hour after
> startup, the SQL server starts to generate networktraffic
> that completely floods the network. It is now impossible
> to log into the server, get on the network or access the
> internet from any workstation that is connected to the
> network. In about one hour more than 50.000.000 network
> packets are sent into space. When I disconnect the
> internet connection, it just continues to do so. When I
> stop the SQL service in the service manager, traffic stops
> and everything works again.
> Any thoughts'
I'm no expert, but the symtoms looks like Slammer virus.
--
Steven Ung
"The source of all greatness lies within you" - Anonymous|||Yep, looks like the slammer virus to me as well...
Update your SQL Server to SP3a, and reboot... and life gets good again...
"Piet Koenekoop" <pietkoenekoop@.hotmail.com> wrote in message
news:1baf501c42130$42cc0430$a501280a@.phx.gbl...
> Hi all,
> I have a Win2000 server with Exchange2003 and SQL
> server2000 SP1.
> The system seems to work OK, but after about 1 hour after
> startup, the SQL server starts to generate networktraffic
> that completely floods the network. It is now impossible
> to log into the server, get on the network or access the
> internet from any workstation that is connected to the
> network. In about one hour more than 50.000.000 network
> packets are sent into space. When I disconnect the
> internet connection, it just continues to do so. When I
> stop the SQL service in the service manager, traffic stops
> and everything works again.
> Any thoughts'
> Piet Koenekoop|||Thanks a lot for the two suggestions. The Slammer virus was not detected by the AV software, but the installation of SP3 has solved my problem
Piet Koenekoop

EXCEPTION_ACCESS_VIOLATION when installing June CTP

Hi - I'm trying to install June CTP on Win2k3 SP1.
Setup failed when trying to start services for configuration.
In log files I found the following
Computer type is AT/AT COMPATIBLE.
Bios Version is INSYDE - 1
Insyde Software MobilePRO BIOS Version 4.00.01
Current time is 11:26:54 08/30/05.
1 Intel x86 level 15, 3 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 1.

Memory
MemoryLoad = 57%
Total Physical = 959 MB
Available Physical = 408 MB
Total Page File = 2329 MB
Available Page File = 1812 MB
Total Virtual = 2047 MB
Available Virtual = 1014 MB
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\log\SQLDump0001.txt
SqlDumpExceptionHandler: Process 5180 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server i
s terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/30/05 11:26:54 spid 0
*
*
* Exception Address = 77BD8944 (strncmp + 00000014)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00330072
*
* MODULE BASE END SIZE
* sqlservr 00400000 01DDEFFF 019df000
* Invalid Address 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* ADVAPI32 77F50000 77FEBFFF 0009c000
* RPCRT4 77C50000 77CEEFFF 0009f000
* CRYPT32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* msvcrt 77BA0000 77BF9FFF 0005a000
* USER32 77380000 77411FFF 00092000
* GDI32 77C00000 77C47FFF 00048000
* MSVCP80 7C420000 7C4A4FFF 00085000
* MSVCR80 7C370000 7C408FFF 00099000
* MSWSOCK 71B20000 71B60FFF 00041000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* NETAPI32 71C40000 71C97FFF 00058000
* opends60 41060000 41065FFF 00006000
* Secur32 76F50000 76F62FFF 00013000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* USERENV 76920000 769E3FFF 000c4000
* psapi 76B70000 76B7AFFF 0000b000
* instapi 02310000 02318FFF 00009000
* sqlevn70 41070000 411ECFFF 0017d000
* SQLOS 02350000 02354FFF 00005000
* rsaenh 68000000 6802EFFF 0002f000
* AUTHZ 76C40000 76C53FFF 00014000
* MSCOREE 78800000 7883FFFF 00040000
* ole32 77670000 777A3FFF 00134000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* kerberos 71CA0000 71CF7FFF 00058000
* cryptdll 766E0000 766EBFFF 0000c000
* schannel 76750000 76776FFF 00027000
* security 71F60000 71F63FFF 00004000
* VERSION 77B90000 77B97FFF 00008000
* dssenh 68100000 68123FFF 00024000
* hnetcfg 5F270000 5F2C8FFF 00059000
* wshtcpip 71AE0000 71AE7FFF 00008000
* DNSAPI 76ED0000 76EF8FFF 00029000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 76F80000 76F84FFF 00005000
* ntdsapi 766F0000 76704FFF 00015000
* dbghelp 3FA40000 3FB49FFF 0010a000
*
* Edi: 00330072:
* Esi: 00330072:
* Eax: 00000000:
* Ebx: 00000008:
* Ecx: 00000008:
* Edx: 01020001: EC83EC8B 78816608 53008002 820F5756 000000A3 8510508D
* Eip: 77BD8944: D9F7AEF2 FE8BCB03 F30C758B FF468AA6 473AC933 740577FF
* Ebp: 3F6EF3A8: 3F6EF3E4 766F4FF6 00330072 766F4F84 00000008 0194A7FC
* SegCs: 0000001B:
* EFlags: 00010246: 00730075 00650074 005C0072 006C0063 00730075 00650074
* Esp: 3F6EF39C: 3F6EF410 77BD8930 766F4F84 3F6EF3E4 766F4FF6 00330072
* SegSs: 00000023:
* *******************************************************************************
* -
* Short Stack Dump
Any help will be appreciated.The AV is happening in the SQL Server engine. I've moved your post to the SQL DB Engine forum. Maybe someone here can help you.

Dan|||Alexandr,

Are you still getting this error? Can you start the service manually?

From the fragment of the output you have provided there is no way to tell what is wrong.

We either need a full dump file (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\log\SQLDump0001.txt) or paste Short Stack Dump.

Regards,
Boris.|||Thanks for reply Boris.
I have reinstalled SQL Server on a brand new OS and it works fine now.

With the previous installation - i cannot start service manually - it gives the same error. I've tried to install SQL Express - and it gives the same error again.
I tried to start SQL Server even not as a service but as a console app - and it gives that error.
That may be happend because I already has installed SQL 2000 and MSDE on my PC.

Regards,
Alexandr.|||Alexandr,

An instance of SQL Server 2005 should coexist just fine with SQL Server 2000. I don't think that is the reason for the AV you were getting, although this is just a guess.

Since you have reinstalled the OS, I wonder if you have kept the dump file(s) that were created when the server generated the AV.

If yes, could you paste short stack dump here and we can take a further look.

Thank you,
Boris.|||Boris,

SQLServer 2005 works fine with SQL 2000 installed on the same box.
I haven't kept the stack dump or log files.

Thanks,
Alexandr.

Excel Rendering Problem w/ SP1

Since installing SP1, RS does not render color information to Excel
correctly. The report in question renders to all other formats correctly. The
error occurs on a variance report where individual cells of a table have
color dynamically assigned based on the variance values (green = good, red = bad). Instead of formatting the individual cell based on the logic embedded
in the report, the entire column retains the color code of the first column.
Any help?Hi,
I had a problem while rendering to Excel before the SP1.
After SP1 is installed Excel rendering works fine.
Eralper
http://www.kodyaz.com
"SD Sills" wrote:
> Since installing SP1, RS does not render color information to Excel
> correctly. The report in question renders to all other formats correctly. The
> error occurs on a variance report where individual cells of a table have
> color dynamically assigned based on the variance values (green = good, red => bad). Instead of formatting the individual cell based on the logic embedded
> in the report, the entire column retains the color code of the first column.
> Any help?|||Same problem here .
Did you find a solution ?
"SD Sills" <SDSills@.discussions.microsoft.com> wrote in message
news:D74E38BA-08AC-4D7F-B54F-E4F5F9E7DE7B@.microsoft.com...
> Since installing SP1, RS does not render color information to Excel
> correctly. The report in question renders to all other formats correctly.
> The
> error occurs on a variance report where individual cells of a table have
> color dynamically assigned based on the variance values (green = good, red
> => bad). Instead of formatting the individual cell based on the logic
> embedded
> in the report, the entire column retains the color code of the first
> column.
> Any help?|||I'm using the below expression for background information of Active column
in my report. I want to see background green if the record is active, red
otherwise
so my expression for BackgroundColor is :
=iif(Fields!Active.Value="True","Green","Red")
Active field has a boolean type in SQl server.
I'm using MS Excel version 2003 SP1, 11.6355.6360 and colors of the exported
excel document is correct.
Excel version may cause rendering problems. I was having one with version 9.
Eralper
http://www.kodyaz.com
"Tudor VAsile" wrote:
> Same problem here .
> Did you find a solution ?
> "SD Sills" <SDSills@.discussions.microsoft.com> wrote in message
> news:D74E38BA-08AC-4D7F-B54F-E4F5F9E7DE7B@.microsoft.com...
> > Since installing SP1, RS does not render color information to Excel
> > correctly. The report in question renders to all other formats correctly.
> > The
> > error occurs on a variance report where individual cells of a table have
> > color dynamically assigned based on the variance values (green = good, red
> > => > bad). Instead of formatting the individual cell based on the logic
> > embedded
> > in the report, the entire column retains the color code of the first
> > column.
> >
> > Any help?
>
>

Excel Pivot Table and Time Dimension

I’m using the OLEDB Provider for Analysis Services 9.0 in Excel 2003 to get to my OLAP cubes in SQL Server 2005 Standard SP1.When I use Time as a Page filter in an Excel Pivot table, the dropdown looks like this (May_2006 is the default period):

-2006
-Qtr2_2006

+May_2006

+Apr_2006

+Jun_2006

+Qtr1_2006

+Qtr3_2006

+Qtr4_2006

+2004

+2005

I checked the field settings in Excel and it is using the data source order option.When I browse the dimension, the Time members are shown in chronological order.I’ve concluded that this behavior is a result of setting the default month in the Time dimension.Anyone know if this is simply the way it is when working with a defaulted Time dimension in Excel?

Moving to SQL Server Analysis Services forum.