Ok, this might be the problem. If I take away the where clause I get this:

Endpoint NameStateGrantorPermissionGrantee

TSQL Local MachineGsaCO public

TSQL Named PipesGsaCO public

TSQL Default TCPGsaCO public

TSQL Default...

Is there a good way to see if the user doesn't have these rights?

Because I did issue a grant permission on the endpoint to this particular domain user that I...

Yes when I am positioned on the server and telnet to mirror site on port 5023, that works.

And I can also telnet from mirror site to the primary site on...

http://msdn.microsoft.com/en-us/library/cc646023.aspx

According to this article there is no default port for database mirroring. Mirroring has worked before, and then I've been using 5022 and 5023.

I just...

PRIMARY: 5100

MIRROR: 5101

tried to telnet from both sites and telnet works. (so, on primary i can telnet to mirror site through port 5101)

I've also tried to telnet from primary site to mirror site, and that works. That's why I'm completely baffled about this error :/

No, firewall is disabled on mirror site.

Are there anywhere instructions on how to do that ?

Ok, so it requires that Windows Failover cluster feature is installed.

Thanks for the info, and btw awesome Article on AlwaysON 🙂

Thanks, I think that did the trick 🙂

I might add that the IP address and DNS will be exactly the same after the migration of DB2. That´s why I thought I didn´t need any additional reconfiguration.

No I don´t have a witness. It´s just plain db1<--->db2

Are you sure there is already a SP1 fro Sqlserver2008 R2 ? I thought there was only CU#7....

I don´t think they charge for GreenSQL Express, which should be enough for most security issues...

Could there be something that is missing?

I issued your updated statements and also this one:

exec sp_addrolemember 'ReallyReadOnly', 'testari'

Then I log on as 'testari', and select from the table Log, and...