Re: DIFFICULT PROBLEM! SSL for SQL 2000 Server. MS Fix bulletin does not help at all.
From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 11/04/04
- Next message: John Kane: "Re: Performance problems -- need guidance on scaling"
- Previous message: Phil Sherrod: "Re: Performance problems -- need guidance on scaling"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 4 Nov 2004 17:23:54 -0500
Jason
Can you contact me offline? Your email address seems to be invalid.
Hilary
"Jason Robertson" <jason6869@msn.com> wrote in message
news:idSdnfrfHoUjxBjcRVn-jw@comcast.com...
> Hi Hillary,
>
> I've found that you are famous SQL Server bookwriter! What an honor. My
> problem may be a good subchapter for your book. I looked at many books in
> Barnes n Noble to find a solution, and none of them addressed this issue
in
> detail. I am sure that there are many more people like me who are looking
> for solution into this problem. Make it a chapter in your SQL book. It
will
> sell well!
>
> Jason
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:OOaBXRhvEHA.3916@TK2MSFTNGP10.phx.gbl...
> > I'm sorry you feel this way.
> >
> > The question is
> >
> > 1) is the problem with their product, ie is it a bug
> > 2) is it perhaps a problem with trying to use the product in ways which
it
> > was not intended.
> > 3) is it perhaps a problem with trying to use the product as documented
> but
> > the documentation is faulty
> >
> > I can raise a support incident for you if I am able to repro your
problem
> at
> > no charge. I'll post back here with the status.
> >
> > My only question at this time is, are you running SQL Server,
Certificate
> > Server, and AD on the same server?
> >
> > Can you also post the select @@version for me here?
> >
> > Hilary
> >
> > "Jason Robertson" <jason6869@msn.com> wrote in message
> > news:O9idnZ4lw-WqXh_cRVn-1Q@comcast.com...
> > >I am not going to pay hundreds of dollars for answers to their faulty
> > > product!!!
> > >
> > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> > > news:ODl883avEHA.2200@TK2MSFTNGP11.phx.gbl...
> > >> This question should be posted perhaps in
> > >> microsoft.public.sqlserver.security.
> > >>
> > >> As you have been unable to resolve this problem in some time, and are
> > >> repeatedly posting here, I suggest you contact PSS for immediate
> > > assistance.
> > >>
> > >> As from your posting host it looks like you are in America, I suggest
> you
> > >> contact them at
> > >>
> > >>
> > >
>
http://support.microsoft.com/oas/default.aspx?ln=en-us&prid=2654&gprid=36503
> > >>
> > >> "Jason Robertson" <jason6869@msn.com> wrote in message
> > >> news:QbSdnaNiabfxYhzcRVn-pw@comcast.com...
> > >> > Hi,
> > >> >
> > >> > I have set up an Active Directory, Certificate Services on Windows
> 2003
> > >> > Server. I am running SQL 2000 Server. AD and Certificate Services
> were
> > >> > installed correctly.
> > >> >
> > >> > My goal is to be able to use SSL when connecting to SQL Server via
> > >> > Query
> > >> > Analyzer. I also want to keep the SQL Server installation under a
> > > "Domain
> > >> > User" account with as little privileges as possible.
> > >> >
> > >> > My problem is that SQL Server will not start when "Domain User" is
> only
> > > a
> > >> > "member of" "Users" group. It starts when I make "Domain User" a
> > >> > "member
> > >> > of"
> > >> > "Administrators". It seems that the SSL "forced encryption" will
only
> > > work
> > >> > with "Administrator" privileges which is the total access to
control
> > >> > the
> > >> > server, and this is not safe.
> > >> >
> > >> > Does it mean that SSL "forced encryption" will only work under a
> > >> > "Domain
> > >> > User" that is a "member" of "Administrators"? Is there another
> "Group"
> > >> > with
> > >> > limited privileges that I could assign the "Domain User" to?
> > >> >
> > >> > How else could I have the SSL work and SQL server installation in a
> > >> > "Domain
> > >> > User" account?
> > >> >
> > >> > I have tried so many different things. Wasted one week already.
> Nothing
> > >> > works. There was some MS bug bulletin saying that this problem was
> > >> > fixed
> > >> > with SQL 2000 service pack 2. I have service pack 3a installed. It
> > >> > still
> > >> > does not work. The log shows the same errors as on the MS fix
buletin
> > > that
> > >> > was supposed to be fixed by that sevice pack. I've tried with
Windows
> > > 2003
> > >> > Srv, Win 2000 Srv. SQL Standard, Enterprise. I just cant get it to
> run.
> > >> > Can
> > >> > you offer some more specific clues? It is so depressing and
> > > dissapointing.
> > >> > Here is the MS buletin that I mentioned:
> > >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;314636
> > >> >
> > >> > Thank you for your help.
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>
>
- Next message: John Kane: "Re: Performance problems -- need guidance on scaling"
- Previous message: Phil Sherrod: "Re: Performance problems -- need guidance on scaling"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
