Trouble connecting to SQL Server express over Peer to Peer network

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rico - 29 Mar 2008 23:49 GMT

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

Reply to this Message

Stefan Berglund - 30 Mar 2008 00:37 GMT

in <7IzHj.10247$_v3.7489@edtnps90>

>Hello,
>
[quoted text clipped - 19 lines]
>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

Reply to this Message

Rico - 30 Mar 2008 07:33 GMT

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

Rick

> in <7IzHj.10247$_v3.7489@edtnps90>
>
[quoted text clipped - 46 lines]
> ---
> Stefan Berglund

Reply to this Message

VB Forum / General / March 2008

Trouble connecting to SQL Server express over Peer to Peer network