Re: Trouble connecting to SQL Server express over Peer to Peer network

Oops! Sorry I thought I had select the SQL Programming group. Thanks for
your help Stefan.

Rick
"Stefan Berglund" <sorry.no.koolaid@xxxxxx> wrote in message
news:n5ktu3h65bbbru8g5jqvi40jq4db8974rk@xxxxxxxxxx
On Sat, 29 Mar 2008 22:49:39 GMT, "Rico" <me@xxxxxxx> wrote:
in <7IzHj.10247$_v3.7489@edtnps90>

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


This really belongs in the microsoft.public.sqlserver.programming group
but are you certain that the SQL Server is configured for both Windows
Authentication and Mixed Mode access? I don't use the product you
mention but I do use SQL Server 2000 and MSDE and you might see if the
following applies:

http://support.microsoft.com/kb/325022

Read the section under Turn on Mixed Mode Authentication after you
install MSDE.

The other thing of course is that the two connection strings differ.

Windows Authentication:
Provider=sqloledb;Integrated Security=SSPI;Network
Library=DBMSSOCN;Server=Server;

Mixed Mode:
Provider=sqloledb;User Id=username;Password=password;Server=Server;

---
Stefan Berglund


.

Relevant Pages

  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Cant connect via ODBC DSN file to SQL server 2005 if not considered a default database
    ... ODBC, just the original database. ... you connect to a SQL Server ... connecting to SQL Server. ... connecting to allows you to install a training or release version of the ...
    (microsoft.public.sqlserver.odbc)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Replication Problem
    ... > context on connecting to the distributor database. ... and could not access my SQL Server - when I tried ... > Another thing to try is to create a subscription database via Enterprise ... > Manager and see if you get the error about connecting to the Distributor. ...
    (microsoft.public.pocketpc.developer)
  • Re: Replication Problem
    ... > context on connecting to the distributor database. ... and could not access my SQL Server - when I tried ... > Another thing to try is to create a subscription database via Enterprise ... > Manager and see if you get the error about connecting to the Distributor. ...
    (microsoft.public.sqlserver.ce)