server/VMWare Problem

I have two servers. Server #1 is a VMware virtual server that I
access using a Remote Desktop Connection (RDC). I acesssed Server #1
using RDC and brought in a linked server (Server #2). When I access
Server #2 as a linked server through RDC there's no problem. However,
if I access Server #1 using my local instance of SQL Server Management
Studio, I can't access the linked server. To make matters worse, if I
try to run views that select from one of the linked server's
databases, I get the following error:
SQL Execution Error
Executed SQL statement: SELECT AddressNumber . . .
Error Source: .Net SqlClient Data Provider
Error Message: TCP Provider. An existing connection was forcibly
closed by the remote host. Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.
Has anyone come across this situation before? It would be nice to be
able to access the linked server without being on the virtual machine.imani_technology_spam@.yahoo.com wrote:
> I have two servers. Server #1 is a VMware virtual server that I
> access using a Remote Desktop Connection (RDC). I acesssed Server #1
> using RDC and brought in a linked server (Server #2). When I access
> Server #2 as a linked server through RDC there's no problem. However,
> if I access Server #1 using my local instance of SQL Server Management
> Studio, I can't access the linked server. To make matters worse, if I
> try to run views that select from one of the linked server's
> databases, I get the following error:
> SQL Execution Error
> Executed SQL statement: SELECT AddressNumber . . .
> Error Source: .Net SqlClient Data Provider
> Error Message: TCP Provider. An existing connection was forcibly
> closed by the remote host. Login failed for user '(null)'.
> Reason: Not associated with a trusted SQL Server connection.
> Has anyone come across this situation before? It would be nice to be
> able to access the linked server without being on the virtual machine.
>
Hi,
How have you setup the Linked Servers? From the error message you get,
it sounds like it's a permission issue. Remember that if you want to use
your windows login as authenticated, you need to have the servers and
your account to be trusted for delegation in your AD. In most cases I
use a SQL server account for my linked servers. Then I always knows
which account I'm using for accessing the linked server and I don't need
to do any changes in the AD.
I don't think the problem has anything to do with the fact that the
servers are running on VMWare. I have a number of SQL servers running on
VMWare and they works just fine from a linked server point of view.
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||How can I make this "trusted for delegation" happen?
On Jun 7, 1:12 am, "Steen Schl=FCter Persson (DK)"
<steen@.REMOVE_THIS_asavaenget.dk> wrote:
> imani_technology_s...@.yahoo.com wrote:
>
>
> Hi,
> How have you setup the Linked Servers? From the error message you get,
> it sounds like it's a permission issue. Remember that if you want to use
> your windows login as authenticated, you need to have the servers and
> your account to be trusted for delegation in your AD. In most cases I
> use a SQL server account for my linked servers. Then I always knows
> which account I'm using for accessing the linked server and I don't need
> to do any changes in the AD.
> I don't think the problem has anything to do with the fact that the
> servers are running on VMWare. I have a number of SQL servers running on
> VMWare and they works just fine from a linked server point of view.
> --
> Regards
> Steen Schl=FCter Persson
> Database Administrator / System Administrator- Hide quoted text -
> - Show quoted text -|||Hi,
This is done on the Server and/or User object in your AD. You can read
more about it in Books On Line - look for "Configuring Linked Servers
for Delegation".
Regards
Steen Schlter Persson
Database Administrator / System Administrator
imani_technology_spam@.yahoo.com wrote:
> How can I make this "trusted for delegation" happen?
>
> On Jun 7, 1:12 am, "Steen Schlter Persson (DK)"
> <steen@.REMOVE_THIS_asavaenget.dk> wrote:
>