Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / October 2004

Tip: Looking for answers? Try searching our database.

SSL in won't work under Domain User account. MS Fix buletin does not help at all. Please Help!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jason Robertson - 25 Oct 2004 23:22 GMT
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.
Hilary Cotter - 26 Oct 2004 12:59 GMT
I suggest you open up a support incident with PSS.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

> Hi,
>
[quoted text clipped - 30 lines]
>
> Thank you for your help.
Jason Robertson - 26 Oct 2004 19:19 GMT
Hi, What is PPS?

> I suggest you open up a support incident with PSS.
>
[quoted text clipped - 36 lines]
> >
> > Thank you for your help.
John Kane - 26 Oct 2004 19:32 GMT
Jason,
PSS is Microsoft's support organization, generally referred to as PSS or
"Product Support Services". What Hilary is recommending is that you call
Microsoft for support for this issue as he cannot answer this issue for you.
Sometimes, it is best to get paid support for such issues as this as they
are complex and would require more time and effort to answer.

Best regards,
John

> Hi, What is PPS?
>
[quoted text clipped - 44 lines]
> > >
> > > Thank you for your help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.