|
Posted by Paul on August 3, 2005, 6:56 am
Please log in for more thread options
Thanks in advance for any assistance.
My developers have requested that they be allowed to remotely use SQL
Enterprise Manager (SQL 2000) to access our databases while off-site.
I used the Security Confoguration Wizard to create a security policy and
checked SQL 2000 as a role. I applied the policy. SQL 2000 now appears as a
"selected" role in the Wizard, but if I view the Security Configuration
Database, it appears as Uninstalled, Disabled.
I've been through this several times. Any idea?
|
|
Posted by Steve Clark [MSFT] on August 3, 2005, 12:46 pm
Please log in for more thread options
Can you share the policy you are applying?
show/hide quoted text
> Thanks in advance for any assistance.
> My developers have requested that they be allowed to remotely use SQL
> Enterprise Manager (SQL 2000) to access our databases while off-site.
> I used the Security Confoguration Wizard to create a security policy and
> checked SQL 2000 as a role. I applied the policy. SQL 2000 now appears
> as a
> "selected" role in the Wizard, but if I view the Security Configuration
> Database, it appears as Uninstalled, Disabled.
> I've been through this several times. Any idea?
|
|
Posted by Paul on August 3, 2005, 1:01 pm
Please log in for more thread options Sorry Steve, I'm not sure what you're asking by sharing the policy. I've
not attempted to distribute the policy to any other servers.
If I use the SCW Viewer to analyze the resulting XML file, I get the a
section titled : Misconfigured Services, where MSSQLSERVER appears as having
a policy start-up mode of automatic, but a System Start-Up mode of
uninstalled. SQL 2000 is indeed installed and working.
"Steve Clark [MSFT]" wrote:
show/hide quoted text
> Can you share the policy you are applying?
>
>
> > Thanks in advance for any assistance.
> > My developers have requested that they be allowed to remotely use SQL
> > Enterprise Manager (SQL 2000) to access our databases while off-site.
> > I used the Security Confoguration Wizard to create a security policy and
> > checked SQL 2000 as a role. I applied the policy. SQL 2000 now appears
> > as a
> > "selected" role in the Wizard, but if I view the Security Configuration
> > Database, it appears as Uninstalled, Disabled.
> > I've been through this several times. Any idea?
>
>
>
|
|
Posted by Steve Clark [MSFT] on August 3, 2005, 3:24 pm
Please log in for more thread options I need the output XML file that you got at the completion of the wizard.
If would also be very helpful if you could include the results of the "sc
query" command...
show/hide quoted text
> Sorry Steve, I'm not sure what you're asking by sharing the policy. I've
> not attempted to distribute the policy to any other servers.
> If I use the SCW Viewer to analyze the resulting XML file, I get the a
> section titled : Misconfigured Services, where MSSQLSERVER appears as
> having
> a policy start-up mode of automatic, but a System Start-Up mode of
> uninstalled. SQL 2000 is indeed installed and working.
> "Steve Clark [MSFT]" wrote:
>> Can you share the policy you are applying?
>> > Thanks in advance for any assistance.
>> > My developers have requested that they be allowed to remotely use SQL
>> > Enterprise Manager (SQL 2000) to access our databases while off-site.
>> > I used the Security Confoguration Wizard to create a security policy
>> > and
>> > checked SQL 2000 as a role. I applied the policy. SQL 2000 now
>> > appears
>> > as a
>> > "selected" role in the Wizard, but if I view the Security Configuration
>> > Database, it appears as Uninstalled, Disabled.
>> > I've been through this several times. Any idea?
>>
|
| Similar Threads | Posted | | Windows security wizard Firewall configuration | September 3, 2008, 9:07 am |
| Security Configuration Editor versus Wizard for 2003 policy | September 26, 2005, 10:59 am |
| Security Configuration Wizard: 2nd try | August 2, 2006, 9:44 am |
| Security Configuration Wizard (SCW) | March 1, 2007, 2:35 pm |
| Re: How to install security configuration wizard | December 30, 2005, 2:24 pm |
| Security Configuration Wizard question | December 12, 2007, 8:59 pm |
| Security Configuration Wizard: Catastrophic Failure | October 7, 2005, 8:30 am |
| confusion about W2003 SP1 security configuration wizard | July 28, 2006, 9:07 am |
| Security configuration wizard: Parameter incorrect error | September 26, 2007, 7:11 am |
| Security Configuration Wizard & Routing and Remote Access | November 12, 2008, 10:23 am |
|
XML Sitemap
> My developers have requested that they be allowed to remotely use SQL
> Enterprise Manager (SQL 2000) to access our databases while off-site.
> I used the Security Confoguration Wizard to create a security policy and
> checked SQL 2000 as a role. I applied the policy. SQL 2000 now appears
> as a
> "selected" role in the Wizard, but if I view the Security Configuration
> Database, it appears as Uninstalled, Disabled.
> I've been through this several times. Any idea?