Re: Connecting to SQL Server

From: Aaron N. Cutshall (acutshall@elsallc.com)
Date: 03/28/03 

From: "Aaron N. Cutshall" <acutshall@elsallc.com>
Date: Fri, 28 Mar 2003 12:00:50 -0500

Shawn,

I'm actually the one that James is working on this for. I can answer a few
of your questions (embedded below).

Aaron

""Shawn Shepherd [MSFT]"" <shawnsh@microsoft.com> wrote in message
news:S#Kt74L9CHA.2536@cpmsftngxa06...
> James,
>
> I researched this and I am not finding anything that would seem to explain
> this behavior, could you tell more about how you are connecting to the SQL
> Database, the Domain Model etc...
James will have to get you more info on this one.

> Are you getting any Event Viewer messages?
Whenever an attempt is made to connect, I get the following DCOM event
#10006: DCOM got error "Server execution failed " from the computer
10.10.1.54 when attempting to activate the server.

The IP address is the one for the SQL Server itself. James has had me
modify DCOM settings on the server to no avail. Again, it works only if the
user is in the Domain Admin group.

> Did this ever work?
This works without any issues on Win9x, WinNT, and Win2K -- just not on
WinXP.

> Are you seeing any other types of authentication issues with the XP
client?
I have other VB apps that access SQL Server and they are not having these
issues. However, since I don't know how the application in questions
connects to the database, it may be using a different method. In my app, I
use a direct SQL connection to the server.

> Please let me know.
>
> Thank you for using Microsoft Partner Support.
>
> Shawn Shepherd[MSFT]
> MCSE2000/MCSA
> Online Support Professional
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Get Secure! - www.microsoft.com/security
>
>

Relevant Pages

  • Re: sp_OACreate
    ... you have choices - either DCOM or COM+ ... with the "Remote Server Files" option ticked under the Component Tab of the ... Remember that SQL Server has no idea that your VB6 COM server is actually ...
    (microsoft.public.sqlserver.programming)
  • RE: DCOM, COM+, COM, MTS; what are they?
    ... COM+ and DCOM are different beasts. ... > server, a SQL server, or physically go to the other machine and hit the ...
    (microsoft.public.dotnet.languages.vb)
  • RE: DCOM, COM+, COM, MTS; what are they?
    ... COM+ and DCOM are different beasts. ... > server, a SQL server, or physically go to the other machine and hit the ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
Quantcast