Re: Resetting SQL Server Authentication / Security?
From: Steve Thompson (SteveThompson_at_nomail.please)
Date: 07/30/03
- Next message: Steve Smith: "Opening a TCP/ IP Port or Port Listener"
- Previous message: Dan Guzman: "Re: Permissions to syslogins"
- In reply to: Rick Stenson: "Resetting SQL Server Authentication / Security?"
- Next in thread: Rick Stenson: "Re: Resetting SQL Server Authentication / Security?"
- Reply: Rick Stenson: "Re: Resetting SQL Server Authentication / Security?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Jul 2003 09:23:05 -0400
"Rick Stenson" <rstenson@qualnetics.com> wrote in message
news:048c01c3562b$6f4b1580$a601280a@phx.gbl...
> The server hosting SQL Server was moved to a new domain.
> SQL was (is) configured for domain ID authentication.
> Since the original domain is no longer there, SQL wont
> start and none of the tools are able to access it or
> change any of the properties. I can't even uninstall it.
>
> How can I reset SQL for new domain credentials?
Before the move, you would have been better off first changing the
authentication to SQL Server.
You could try hacking the registry to change authentication mode to SQL
Server (mixed mode)
http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
Then, change the service to run under context of 'local system'.
Steve
- Next message: Steve Smith: "Opening a TCP/ IP Port or Port Listener"
- Previous message: Dan Guzman: "Re: Permissions to syslogins"
- In reply to: Rick Stenson: "Resetting SQL Server Authentication / Security?"
- Next in thread: Rick Stenson: "Re: Resetting SQL Server Authentication / Security?"
- Reply: Rick Stenson: "Re: Resetting SQL Server Authentication / Security?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
