How to connect to the shared Database Server

  • Thread starter Thread starter RichardV
  • Start date Start date
R

RichardV

Hi,

We have several development workstations in a domain but the Database server
in located
on a PC which is not in this domain. There is no problem to remotly access
the SQL server
from one the workstation, using any Database Manager.
Visual studio tools can not, error is "cannot connect to the database at
'servername'.

We think it's an identification problem, looks like the Component Database
Manager
uses only the "Windows" authentication and not the SQL Server
"authentication".
Is this correct ?

If yes, is there a way to bypass this problem, allowing the developpers to
access
this "out of domain" SQL server ?

Thanks,

Richard.
 
RichardV,
Hi,
...
We think it's an identification problem, looks like the Component Database
Manager
uses only the "Windows" authentication and not the SQL Server
"authentication".
Is this correct ?
Click to expand...

Yes, it is. Windows XP Embedded requires Windows authentication.
If yes, is there a way to bypass this problem, allowing the developpers to access
this "out of domain" SQL server ?
Click to expand...

I don't know a good work around. Evem Mixed mode does not seem to help you conceptually.

Try posting the question to microsoft.public.sqlserver.security. You may get a quick better answer there.
 
Back
Top