Re: Trouble connecting to SQL Server express over Peer to Peer network
- From: Stefan Berglund <sorry.no.koolaid@xxxxxx>
- Date: Sat, 29 Mar 2008 16:37:02 -0700
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
.
- Follow-Ups:
- References:
- Prev by Date: Re: Feedback/ Change request
- Next by Date: Re: Callbacks in VB6 - Callbacks in VB6.txt (0/1)
- Previous by thread: Trouble connecting to SQL Server express over Peer to Peer network
- Next by thread: Re: Trouble connecting to SQL Server express over Peer to Peer network
- Index(es):
Relevant Pages
|
