|
Home > Archive > MS SQL Server security > November 2005 > why i can't login to a server using windows authentication ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
why i can't login to a server using windows authentication ?
|
|
| rafameza 2005-11-28, 8:23 pm |
| I have a SQL 2000 Server standard edition, it is configured for mixed mode
authentication, but every time i try to login using windows authentication
from the server console the following error comes up:
Unable to connect to server XXXXX:
Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL ServerDriver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL server connection.
The issue start appearing after installing Service Pack 1 to W2K3,
During the installation of SP1 everything went Ok, and after rebooting the
server the following pop up window error came up:
Title bar : Windows – Registry Hive Recovered
Content : Registry hive (file): SYSTEM was corrupted and it has been
recovered. Some data might have been lost.
Since then,, i haven't been able to login using windows authentication mode
from the server console,,(the weird thing is that from another machine i can
connect using windows authentication mode, it takes an eternity but connects)
Also SQL Server Agent is having the same trouble connecting to the server.
I just reinstalled SQL server from scrath and applied SP4,, but the issue
persist. My next move is to format the server and reinstall everything.
Any ideas less radical ?
| |
| Andy Davis 2005-11-29, 3:23 am |
| Hi,
refer following link for relavent information
http://www.derkeiler.com/Newsgroups...04-06/0579.html
http://geekswithblogs.net/ranganh/a...5/25/40489.aspx
http://support.microsoft.com/defaul...kb;en-us;555332
http://support.microsoft.com/defaul...kb;en-us;265808
HTH
Regards
--
Andy Davis
Activecrypt Team
--------------------------------------------SQL Server Encryption Software
http://www.activecrypt.com
"rafameza" wrote:
> I have a SQL 2000 Server standard edition, it is configured for mixed mode
> authentication, but every time i try to login using windows authentication
> from the server console the following error comes up:
>
> Unable to connect to server XXXXX:
> Server: Msg 18452, Level 16, State 1
> [Microsoft][ODBC SQL ServerDriver][SQL Server]Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL server connection.
>
> The issue start appearing after installing Service Pack 1 to W2K3,
> During the installation of SP1 everything went Ok, and after rebooting the
> server the following pop up window error came up:
>
> Title bar : Windows – Registry Hive Recovered
> Content : Registry hive (file): SYSTEM was corrupted and it has been
> recovered. Some data might have been lost.
>
> Since then,, i haven't been able to login using windows authentication mode
> from the server console,,(the weird thing is that from another machine i can
> connect using windows authentication mode, it takes an eternity but connects)
>
> Also SQL Server Agent is having the same trouble connecting to the server.
>
> I just reinstalled SQL server from scrath and applied SP4,, but the issue
> persist. My next move is to format the server and reinstall everything.
>
> Any ideas less radical ?
>
>
|
|
|
|
|