HELP: SSEE problems

I've a Windows 2003 Server Web Edition server. I've installed SSEE on
the same server. I've 5 domains (and 5 different web applications).
Every app needs to connect to 1 different db.
Both, with native securiy or Windows security, I obtain that only 1 app
work correctly while with the others I obtain "Application Server
Unavailable". If I connect all the apps to the same db then all works right.
Can someone hel me to solve this problem?
Thanks in advance,
FrancoHi Fransis
"Fransis il Mulo" wrote:

> I've a Windows 2003 Server Web Edition server. I've installed SSEE on
> the same server. I've 5 domains (and 5 different web applications).
> Every app needs to connect to 1 different db.
> Both, with native securiy or Windows security, I obtain that only 1 app
> work correctly while with the others I obtain "Application Server
> Unavailable". If I connect all the apps to the same db then all works righ
t.
> Can someone hel me to solve this problem?
> Thanks in advance,
> Franco
Have you enabled network protocols for SQL Express? By default they will be
disabled, but that can be overridden when you install SQL Express or later
using SQL Server Configuration Manager see
http://msdn2.microsoft.com/en-us/library/ms165718.aspx
John

Help: Replication stops with no error or warnings!

hi all,
I have sql server 2005 sp2 running transactional replication between 2
production servers on different domains. Every once in a while
transaction stop being delivered to the target with no warnings or
errors being generated by any of the servers involved. Using
replication monitor on the the publisher and viewing the tab "
Publisher to Distributor" shows transactions being delivered
successfully ("n transaction(s) with n command(s) were delivered
successfully") but the transactions do not show up on the target
server?
Any thoughts much appreciated as the only resolution i've found is to
wait until off hours and reinitialize the subscriptions. i'm going to
have to put a custom alert system in place to check table counts but i
really need to find the cause of this.
-Thanks! DF
Difficult to tell exactly what is getting replicated in repl monitor. Best
tool to troubleshoot is to run profiler on subscriber and see if you can find
anything. Best to do after hours if you can repeat problem w/ just you as
user.
What is your distribution agent profile? How did you initialize subscriber -
snapshot agent or backup/restore? If backup init - make sure you disable
triggers or set to NFR and drop FK's at subscriber. Perhaps your agent is
ignoring errors caused by FK constraints and not delivering rows changes...
ChrisB MCDBA
MSSQLConsulting.com
"dfateman@.yahoo.com" wrote:

> hi all,
> I have sql server 2005 sp2 running transactional replication between 2
> production servers on different domains. Every once in a while
> transaction stop being delivered to the target with no warnings or
> errors being generated by any of the servers involved. Using
> replication monitor on the the publisher and viewing the tab "
> Publisher to Distributor" shows transactions being delivered
> successfully ("n transaction(s) with n command(s) were delivered
> successfully") but the transactions do not show up on the target
> server?
> Any thoughts much appreciated as the only resolution i've found is to
> wait until off hours and reinitialize the subscriptions. i'm going to
> have to put a custom alert system in place to check table counts but i
> really need to find the cause of this.
> -Thanks! DF
>