RE: sql server startup account
From: Paul Cyr (PaulCyr_at_discussions.microsoft.com)
Date: 09/10/04
- Next message: Thomas Tsang: "Re: Recover data with updated transaction Log only"
- Previous message: Dan Guzman: "Re: Recover data with updated transaction Log only"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Sep 2004 04:37:04 -0700
What is I also want to use SQLMAIL. I have a regular domain user account with
local administrator rights on the SQL box but now when I try to connect with
the SQL Server Enterprise Manager or query analyser via NT Authentication if
fails with Login failed for user '(null)'.
SQL authentication works great but NT authentication fails every time.
If I switch to a domain admin account or a local system account NT
authentication works fine but I don't want to use a domain admin account or a
local system account because I want to use SQLMAIL!!!
I tried using the setspn.exe utility to fix the problem but that didn't help
unless I have to restart the MSSQLService after using this utility but the
instructions don't say you need to do this and this is now a production SQL
Server that can't be stopped and started willie nillie.
"Pankaj Agarwal [MSFT]" wrote:
> Hello Biva
>
> I believe that the following article should answer your question :
>
> 283811 How to change the SQL Server or SQL Server Agent Service account
> without
> http://support.microsoft.com/?id=283811
>
>
> Thank you for using Microsoft newsgroups.
>
> Sincerely
>
> Pankaj Agarwal
> Microsoft Corporation
>
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
- Next message: Thomas Tsang: "Re: Recover data with updated transaction Log only"
- Previous message: Dan Guzman: "Re: Recover data with updated transaction Log only"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
