Posted by Erland Sommarskog on 11/08/06 22:58

(Thanks@work.com) writes:
> "Erland Sommarskog" <esquel@sommarskog.se> wrote in message
> news:Xns9874F08E810F0Yazorman@127.0.0.1...
>> Am_I_right (Am_I_right@world.com) writes:
>>> Same system setup as before.
>>> Computer A with SQL 2005
>>> Computer B with SQL Express
>>>
>>> Is it possible to connect the SQL Express in B from the A using the SQL
>>> 2005?
>>>
>>> I tried it, but failed.
>>
>> How did you try? How did it fail?
>
> Computer A and Computer B are linked with network cable through a network
> switch.
> Both using MS Win 2003.

Just because you connect the computers with a network cables does not
mean that the two SQL Servers are connected. You must also set up a
linked server. Although it depends on what you want to do. Linked servers
are needed only if you want to access tables on server from the other.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]