Hi Perri,

Server logins folder have the next information:

##MS_PolicyEventProcessingLogin##

##MS_PolicyTsqlExecutionLogin#

distributor_admin

DOMAIN\GROUP

DOMAIN\USER

NT AUTHORITY\SYSTEM

NT SERVICE\MSSQLSERVER

NT SERVICE\SQLSERVERAGENT

sa

SERVER\administrator

where SERVER is the servername who SQL server databas is running.

I create a windows account with a 'DOMAIN\GROUP'.

The error message is:

Login failed for user 'DOMAIN\USER'. (Microsoft SQL Server, Error: 18456).

I try to connect to SQL Server database with 'DOMAIN\USER'...

I resolve the problem editing on publication server (SRV2) the hosts file to resolve the remoter hostname to the remote ip (Host file location is C:\WINDOWS\system32\drivers\etc\)

Many thanks.

Hi all,

Finally created the DB-LINK from SRV3 putting the all domain information as server name (SRV3.SUBDOMAIN.DOMAIN).

Thank you very much.

There are information that i considered important:

SRV2: SQL Server 2008 is in CLUSTER.

Also if we connected from SRV2 via SQL Server Management Studio using SRV3 IP number we can open...

Hi,

Thanks for you reply.

I have been doing many test during the last week and i detect that the problem probably is the 'Parameter sniffing'.

In this URL are a general...

Hi,

Thanks for you reply Greg. It is very interesting script.

But it does not allow me to obtain the full structure info of the database, that is, i can't...