Board index MS SQL Server

Connecting SQL Server's Across A Workgroup

Connecting SQL Server's Across A Workgroup

Post by Simon Humphrie » Sat, 03 Mar 2001 02:04:03



Hi,

We currently have 2 web servers, each running MSDE, placed in a workgroup. I
am having problems getting one of the webservers to read the others database
using SQL Authentication.The problem is that although the other machine can
see the other one, it will not allow it to connect to the others database, I
have tried using the "SA" login. It says "Not Associated With A Trusted
Connection" when I try to use access to connect to the other server.
The Machines are connected via there own internal network card and have
another network card with load balancing connected to the outside world.

Does anyone have any idea how to connect 2 sql servers across a workgroup?

Any help would be very much appreciated.

Many Thanks

Simon

True Systems LTD

 
 
 
Top

Connecting SQL Server's Across A Workgroup

Post by Alla » Sun, 04 Mar 2001 20:53:53


Try these

Is the authentication level set to NT only
Are you using Named Pipes.  If so move to TCP/IP

Allan

On Thu, 1 Mar 2001 17:04:03 -0000, "Simon Humphries"


>Hi,

>We currently have 2 web servers, each running MSDE, placed in a workgroup. I
>am having problems getting one of the webservers to read the others database
>using SQL Authentication.The problem is that although the other machine can
>see the other one, it will not allow it to connect to the others database, I
>have tried using the "SA" login. It says "Not Associated With A Trusted
>Connection" when I try to use access to connect to the other server.
>The Machines are connected via there own internal network card and have
>another network card with load balancing connected to the outside world.

>Does anyone have any idea how to connect 2 sql servers across a workgroup?

>Any help would be very much appreciated.

>Many Thanks

>Simon

>True Systems LTD


 
 
 
Top

1. Can't connect to server across WAN

There problem
I have few servers and WAN between them.
Where placed first server I have small LAN.
When my laptop in the LAN I can easy access SQL Server, but when I try
connect from home (through WAN) nothing happenend. What's the trouble?

I was use SQL authentication and try use NTLM, but nothing in both.

Any suggestions?

PS: In few machines Server Network Utility and Client Network Utility use
TCP/IP as primary protocol.

2. mailing labels

3. Can't connect to SQL across internet

4. Problem installing a VB4 application

5. MS SQL Server - join across two db's same server

6. postgresql.conf ignored

7. Problem connecting to a server when connecting to a workgroup

8. SQL Server 7.0 Beta 3 Download?

9. How to connect to a SQL Server in different workgroup

10. SQL connection across NT workgroups

11. SQL Agent Job Error: Unable to connect to SQL Server '(local)':

12. Using ADO To Connect To ACCESS/SQL Server Across Internet

13. SQL connect across different servers.


All times are UTC
Board index