Yes.

or, client already end the session without rollback or commit transaction

k. but what will be that trancation state. rollback or commit.

The server configuration is windows server 2003 with sql server 2005 32 bit

and RAM 12 GB.

AWE is enabled and sql is using near 10 GB of RAM resoures.

i thing first...

i agreed. but as a DBA we should know the problem.

i m a consultant 😀

how to give permission to endpoint....

there are two servers. and both server using same user to start.

and both server's engine and agent service are running on this account.

1st time doing this activity on this server.

please help me for this problem

i stuck with it.

i had tested. i created two system DSN pointing to the mirror and witness server it is working fine.

and i have also checked in primary server to connect mirror and...

i mean to say, enable filestream for t-sql access in sql server configuration manager for sql server services.

tomorrow i'll do it and get back to u for the same.

i have not enable filestream. is any type of relation of both?.

windows firewall is disable on both servers.

there r two server

1st one is primary server and

2nd server are two instances (Mirror and Witness)

both are running on two different ports, and both server in one domain...