Trouble connecting to SQL Server express over Peer to Peer network

Hello,

I have a program that accesses an SQL Server Express database. I access
this database remotely on a Windows domain and it works fine. The server
machine is set up with TCP/IP and Name Pipes enabled using Surface Area
Configuration and I connect using Windows Authentication.

WHen I move this to a Peer to Peer network using a workgroup on machines
that have never been connected to the domain, I have an issue connecting.
The server is set up the same (I used the same install on both domain and
peer to peer machines), and I have tried both Windows Authentication and
Mixed Mode using even the sa account to try and connect (sa account has been
enabled) but I'm still having trouble connecting with both the program and
Mangement Studio. I can connect to this machine and it's file system via
Windows Explorer, and I can connect to the database on the local machine
itself, but trying to access it remotely is the problem. I've tried BOL and
google searches, but all the hits I've seen so far have to do with either
enabling TCP/IP or resolving someone's broken connection string.

Any help would be greatly appreciated.

Thansk!
Rick


.

Relevant Pages

  • Re: help with 2000i on win2k server (sp3 on database)
    ... See Leonard's post for the config options. ... If the server is mangling itself, then ANYTHING running on the server ... that I work with will support the database AND the application. ... As for Windows vs. Linux/NetWare, I can agree, but I also see MANY ...
    (comp.databases.btrieve)
  • Re: nt4.5 to w2003
    ... keep in mind that there basically is two different things you can do to move from an NT 4 (SAM Database) domain to an Active Directory Domain. ... You can choose to upgrade the domain from NT 4 to Windows 200x Active Directory. ... The thing to keep in mind here is that you have to Upgrade an NT 4 PDC to Windows 200x. ... You could download and install Virtual Server 2005 if you needed to upgrade an NT 4 machine to Windows 200x and your real hardware either does not support NT 4, or the NT 4 hardware you have does not really support Windows 200x. ...
    (microsoft.public.windows.server.migration)
  • Re: Setting up Linked server to MsAccess
    ... At the server level I have added my windows user group ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Printer Driver / Port Options
    ... My client uses Windows 2003 Server and Window 2003 Pro on the desktops. ... grab their printer when connected as admin to the Server via RDP and adjust ... them through changing the setting by connecting to a RDP session w/o starting ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Enabling Remote Access
    ... you must create a sql-server login and use it when connecting ... through the VPN and the authentification mode of SQL-Server must be set to ... the mixed mode (Windows + SQL-Server). ... I am able to VPN into the server using Remote ...
    (microsoft.public.access.adp.sqlserver)