Hello there
I have two computers who connected on the same workgroup. on each one of
them sql server database is installed
I would like to connect them together so i can transfare data between them.
What i need to do so they will recognize each other?Hi,
-Connection via a network protocol (e.g. tcp/ip)
-Authorisation between these two (in workgroups usally SQL Server
authentication)
HTH, Jens Suessmeyer.|||Whell Jens
I've change on second computer to SQL Server Authentication.
But when i'm trying to access from first computer to second computer using
query analyser with this code:
select *
FROM Printer.Diseace.dbo.Client
I got the error:
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'PRINTER\Guest'.
The User Gest on the printer is not configured, and i would like to access
as dbo.
what i need to do now?
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1133619339.336140.15280@.g49g2000cwa.googlegroups.com...
> Hi,
> -Connection via a network protocol (e.g. tcp/ip)
> -Authorisation between these two (in workgroups usally SQL Server
> authentication)
> HTH, Jens Suessmeyer.
>|||So you are using a linked server. With this technique and without
authorisation through a windows domain, you have to set up the linked
server with a SQL Server login (usally if you want to have dbo right,
with a user whohas dbo rights on the remote server) to access the
database, otherwise it will try to use the guest account from your
Computer "Printer" which is unknown on the remote one.
HTH, Jens Suessmeyer.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment