More weirdness.
in the Admin group. And if I check the protocols on the Server and Client
Network Utilities, TCP/IP is the only one enabled. The connection string
machine, but nothing worked. It only works if Data Source is . and Network
Library is not specified, and the COM+ user is an Administrator. MDAC 2.8
"Slava Gurevich" <vyach@hotmail.com> wrote in message
news:3atopvovn0i1cevl6bmji31pihlc581crp@4ax.com...
> > (SQL Server is set for mixed-mode security, and I am
> >using a SQL username/password to connect rather than Windows
> >authentication.)
>
> In your scenario, SQL connection defaults to using Win32 Named Pipes
> and Windows authentication even if you provide SQL username/password
> pair in the connection string. You could do the following to change
> that:
>
> 1. Install SQL client tools, and use it to change the default ( per
> machine)
> 2. Change the registry manually to change the default ( per machine)
> 3. Add "Network Library=dbmssocn" to the connection string to override
> the default
>
> IMHO, the 3rd choice is superior. Try this out with the non-.NET
> client first. Here is a few links to read about this:
>
> PRB: Error "Client Unable to Establish Connection" When You Open ADO
> Connection from Within MTS/COM+ Component
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;300357 >
> HOWTO: Change SQL Server Default Network Library Without Using Client
> Network Utility
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;250550 >
> HOWTO: Set the SQL Server Network Library in an ADO Connection String
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;238949 >
>
> Slava Gurevich
>
>
> On Fri, 24 Oct 2003 15:47:28 -0600, "DJ Miller"
> <qzvyyre@n-1erybpngvba.pbz.ROT13> wrote:
>
> >Thanks for the feedback. The user has "Logon as Batch" granted already,
and
> >there is a password supplied.
> >
> >I don't know if this provides any clue, but if I try running a non-.Net
> >application (same setup as the .Net application, with a series of COM
> >objects that gets called to get to the database), I get a "SQL Server
does
> >not exist or access denied" or "no default provider specified" error.
The
> >last COM object to be called goes to the registry to get the connection
> >string and then creates an ADO connection with that string. The error
> >changes depending on how I play with permissions, whether I have the COM
> >user in the Users group or take him out and grant the user permissions to
> >read the registry key. It only completely works if the user is in the
> >Administrators group. (SQL Server is set for mixed-mode security, and I
am
> >using a SQL username/password to connect rather than Windows
> >authentication.)
> >
> >"Girish Bharadwaj" <girishb@nowhere> wrote in message
> >news:ea9B4UamDHA.1072@TK2MSFTNGP09.phx.gbl...
> >> DJ Miller wrote:
> >> > Does nobody have any suggestions for me? I've asked this question in
> >this
> >> > and the FAQs newsgroups, and neither have received any responses. Is
> >there
> >> > more information that is needed? I am completely stuck on this and
> >would
> >> > appreciate any help.
> >> </snip>
> >> Since, you are seeing this issue only in win2k3 and not in win2k, it
> >> seems like the privileges for a regular "user" is less then what it
used
> >> to be in win2k. One of the things to try is to find the different
> >> account privileges that are provided to that user.When a user is
> >> assigned to a package, you needed that user to have at least "Logon as
a
> >> Batch" privilege. I dont think this has changes. May be, you r user
does
> >> not have that privilege in Win2k3..
> >> Also, make sure that the user has a "non-blank" password. One of the
> >> account policies blocks using the a blank passworded user on packages
> >> etc. It only allows them on console logon only.
> >>
> >>
> >> Can that be the problem?
> >> Some things to check..
> >>
> >> --
> >> Girish Bharadwaj
> >>
> >
>