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.googlegro ups.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.
Showing posts with label computers. Show all posts
Showing posts with label computers. Show all posts
Tuesday, February 14, 2012
Connecting two computers
Connecting two computers
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.
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.
Connecting to sqlexpress from another machine.
I have developed an application in vs.net and have an sql express version on
one of my computers (Actually both computers).
How do I connect to this database from the other machine (workgroup, not
dedicated server)
When I try to connect through the Add Connection I get the message
'An error has occured while establishing a connection to the server. When
connecting to SQL Server 2005,
this failure may be caused by the fact under the default settings SQL Server
does not allow remote connections.
(Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
Specified)'
reidarTHi
Can you connect using SQLCMD? It could be that you have not enable remote
connections with SqlSAC.exe! When you connect you should be able to specify
the machine name\Instance or the IP address\Instance in your connection
string. If you can connect using the IP address and not the hostname you may
need to add it to your hosts file.
John
"reidarT" wrote:
> I have developed an application in vs.net and have an sql express version on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Server
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
> Specified)'
> reidarT
>
>|||reidarT wrote:
> I have developed an application in vs.net and have an sql express version on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Server
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
> Specified)'
> reidarT
>
Use the Surface Area Configuration tool to enable remote connections...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
one of my computers (Actually both computers).
How do I connect to this database from the other machine (workgroup, not
dedicated server)
When I try to connect through the Add Connection I get the message
'An error has occured while establishing a connection to the server. When
connecting to SQL Server 2005,
this failure may be caused by the fact under the default settings SQL Server
does not allow remote connections.
(Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
Specified)'
reidarTHi
Can you connect using SQLCMD? It could be that you have not enable remote
connections with SqlSAC.exe! When you connect you should be able to specify
the machine name\Instance or the IP address\Instance in your connection
string. If you can connect using the IP address and not the hostname you may
need to add it to your hosts file.
John
"reidarT" wrote:
> I have developed an application in vs.net and have an sql express version on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Server
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
> Specified)'
> reidarT
>
>|||reidarT wrote:
> I have developed an application in vs.net and have an sql express version on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Server
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
> Specified)'
> reidarT
>
Use the Surface Area Configuration tool to enable remote connections...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Connecting to sqlexpress from another machine.
I have developed an application in vs.net and have an sql express version on
one of my computers (Actually both computers).
How do I connect to this database from the other machine (workgroup, not
dedicated server)
When I try to connect through the Add Connection I get the message
'An error has occured while establishing a connection to the server. When
connecting to SQL Server 2005,
this failure may be caused by the fact under the default settings SQL Server
does not allow remote connections.
(Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
Specified)'
reidarTHi
Can you connect using SQLCMD? It could be that you have not enable remote
connections with SqlSAC.exe! When you connect you should be able to specify
the machine name\Instance or the IP address\Instance in your connection
string. If you can connect using the IP address and not the hostname you may
need to add it to your hosts file.
John
"reidarT" wrote:
> I have developed an application in vs.net and have an sql express version
on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Serv
er
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instanc
e
> Specified)'
> reidarT
>
>|||reidarT wrote:
> I have developed an application in vs.net and have an sql express version
on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Serv
er
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instanc
e
> Specified)'
> reidarT
>
Use the Surface Area Configuration tool to enable remote connections...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
one of my computers (Actually both computers).
How do I connect to this database from the other machine (workgroup, not
dedicated server)
When I try to connect through the Add Connection I get the message
'An error has occured while establishing a connection to the server. When
connecting to SQL Server 2005,
this failure may be caused by the fact under the default settings SQL Server
does not allow remote connections.
(Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
Specified)'
reidarTHi
Can you connect using SQLCMD? It could be that you have not enable remote
connections with SqlSAC.exe! When you connect you should be able to specify
the machine name\Instance or the IP address\Instance in your connection
string. If you can connect using the IP address and not the hostname you may
need to add it to your hosts file.
John
"reidarT" wrote:
> I have developed an application in vs.net and have an sql express version
on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Serv
er
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instanc
e
> Specified)'
> reidarT
>
>|||reidarT wrote:
> I have developed an application in vs.net and have an sql express version
on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Serv
er
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instanc
e
> Specified)'
> reidarT
>
Use the Surface Area Configuration tool to enable remote connections...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Subscribe to:
Posts (Atom)