have registered a new server. When I register the server
using the wizard, I set the authentication to Windows.
This allows connection using Enterprise Manager.
For a number of reasons I want to change the
authentication to allow 'Mixed mode' but if I go to the
server properties, security tab and try and change the
authentication to SQL and Windows, the change is not saved
(I cant change the authentication this way)
If I edit the server registration to SQL and specify a Log
in and password, I get the message " Not associated with
Trusted SQL server connection"
Can anyone tell me how to set up the server to allow mixed
mode working. Other servers on the network are fine
Thanks in advance for any helpDid you restart the SQL Server service after changing the security mode?
When you make a change in SQL configuration, it becomes a configured value,
but you have to restart for it becoming a running value.
You may want to check the SQL errorlog and Windows Event viewer as well for
detail. You are definitely going to the right place in Enterprise Manager.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Duncan Stott" <Duncan@.intracite.com> wrote in message
news:74bf01c3e747$79074640$a501280a@.phx.gbl...
quote:|||It sounds like the account that you are logged on as does not have
> Running SQL2000 on Windows NT. Using Enterprise Manager I
> have registered a new server. When I register the server
> using the wizard, I set the authentication to Windows.
> This allows connection using Enterprise Manager.
> For a number of reasons I want to change the
> authentication to allow 'Mixed mode' but if I go to the
> server properties, security tab and try and change the
> authentication to SQL and Windows, the change is not saved
> (I cant change the authentication this way)
> If I edit the server registration to SQL and specify a Log
> in and password, I get the message " Not associated with
> Trusted SQL server connection"
> Can anyone tell me how to set up the server to allow mixed
> mode working. Other servers on the network are fine
> Thanks in advance for any help
>
permission to change the registry.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Andy
Thanks for the ideas, but I had already tried this. I have
also tried deleting the registration and setting it from
scratch. Same problem. As soon as I specify that I want to
log in usin SQL( not windows) I get the 'Not associated
with Trusted SQL server connection"
I looked in the SQL log as you suggested and there is the
following message
"Configuration option 'show advanced option' changed from
1 to 1. Run the RECONFIGURE statement to instal."
Any ideas
Duncan
quote:
>--Original Message--
>Did you restart the SQL Server service after changing the
security mode?
quote:
>When you make a change in SQL configuration, it becomes a
configured value,
quote:
>but you have to restart for it becoming a running value.
>You may want to check the SQL errorlog and Windows Event
viewer as well for
quote:
>detail. You are definitely going to the right place in
Enterprise Manager.
quote:
>--
> ****************************************
******************
*********
quote:
>Andy S.
>MCSE NT/2000, MCDBA SQL 7/2000
>andymcdba1@.NOMORESPAM.yahoo.com
>Please remove NOMORESPAM before replying.
>Always keep your antivirus and Microsoft software
>up to date with the latest definitions and product
updates.
quote:
>Be suspicious of every email attachment, I will never send
>or post anything other than the text of a http:// link nor
>post the link directly to a file for downloading.
>This posting is provided "as is" with no warranties
>and confers no rights.
> ****************************************
******************
*********
quote:
>"Duncan Stott" <Duncan@.intracite.com> wrote in message
>news:74bf01c3e747$79074640$a501280a@.phx.gbl...
I[QUOTE]
saved[QUOTE]
Log[QUOTE]
mixed[QUOTE]
>
>.
>
No comments:
Post a Comment