Login failed for user NT AUTHORITY\ANONYMOUS LOGON (but user.identity.name is correct)

I need help. The security principal is the correct Domain\User, but the error message says I am not authenticated.

So here is my error Message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomain\Ryan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomain\Ryan; HttpContext.Current.User.Identity.Name=Company\Ryan

Generated by:

Dim

secPrincAs System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrentMe.lblError.Text = ex.Message & vbCrLf & vbCrLf &"Me.User.Identity.Name=" &Me.User.Identity.Name &"; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name &"; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name

Here is the Connection String:

Private ConnStringAsString ="Server=10.144.162.111;Database=DNS;Trusted_Connection=True"

IIS has 4 websites hosted on it. The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest.

In IIS, is there a problem with having the parent level anonymous and website level windows auth?

I think i found the error. My web server is a different machine from my data server. When my browser connects to the webserver it uses impersonation and delegation, but the web server is not trusted for delegation on the active directory. So when the webserver tries to pass the credentials to the data server the domain controller will not allow it.

Working on a 3 tier setup here...

Ryan

Login failed for user domain\domcontroller$ - 18456

I am running several instances of SQL Server 2005 sp2 on a W2k3 sp2 box (member server).

This morning, I installed reporting services to one of my instances and shortly after noticed I was getting the following two messages in my SQL Server log file:-

08/08/2007 11:05:03,Logon,Unknown,Login failed for user 'DOMAIN\DOMCONTROLLER$'. [CLIENT: xxx.xxx.xxx.xxx]
08/08/2007 11:05:03,Logon,Unknown,Error: 18456, Severity: 14, State: 16.

The above entries were each repeated 6 times every 15 minutes but with State 11. I created a logon for the above, and now get the above messages (state 16) repeated 3 times every 15 minutes!

Any ideas why?

Regards

Ian

It seems like a service in DOMCONTROLLER machine is trying to connect to SQL Server, it must be running under network service or local system account.

I recommend reading the following post, hopefully it will help you find the solution:

http://forums.microsoft.com/msdn/showpost.aspx?postid=66265&siteid=1

-Raul Garcia

SDE/T

SQL Server Engine

Login failed for user '(null)'...Reasons?

A SQL Server (in another domain) I'm trying to connect to with SQL Server
authentication (UID and password) fails from an Access application. I've
tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
mixed authentication mode.
I can get to the SQL Server with Enterprise Manager, can successfully test
the connection with the DSN in the ODBC Administrator, and can successfully
test the connection via a UDL test (OLEDB)...just not through an Access 2000
application.
Can anyone provide the various possible reasons for...
Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
...?
Why is the SQL Server receiving a null UID?
Thanks,
JoeIn order for the server to accept the connection attempt it needs to
"authenticate" that the user is some that has rights (user needs the ability
to connect to the \\servername\ipc$ share). This step happens before SQL
Server gets a change to interrogate the credentials. See Books Online
"Authentication Modes" for more detail.
Steve
"JRE" <nomail@.all> wrote in message
news:#FMgYTUAEHA.3316@.TK2MSFTNGP11.phx.gbl...
> A SQL Server (in another domain) I'm trying to connect to with SQL Server
> authentication (UID and password) fails from an Access application. I've
> tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
> mixed authentication mode.
> I can get to the SQL Server with Enterprise Manager, can successfully test
> the connection with the DSN in the ODBC Administrator, and can
successfully
> test the connection via a UDL test (OLEDB)...just not through an Access
2000
> application.
> Can anyone provide the various possible reasons for...
> Connection failed:
> SQLState: '28000'
> SQL Server Error: 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo
r user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
> ...?
> Why is the SQL Server receiving a null UID?
> Thanks,
> Joe
>
>|||Thanks... Proper user accounts exist on both domains in question.
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:%233d64rVAEHA.2484@.TK2MSFTNGP12.phx.gbl...
> In order for the server to accept the connection attempt it needs to
> "authenticate" that the user is some that has rights (user needs the
ability
> to connect to the \\servername\ipc$ share). This step happens before SQL
> Server gets a change to interrogate the credentials. See Books Online
> "Authentication Modes" for more detail.
> Steve
> "JRE" <nomail@.all> wrote in message
> news:#FMgYTUAEHA.3316@.TK2MSFTNGP11.phx.gbl...
Server
test
> successfully
> 2000
>|||On SQL Server, enabled auditing for "failed logins" and see if the accounts
are being rejected by SQL Server.
Security auditing at the server level should indicate if the user account is
failing to get a server connection.
Steve
"JRE" <nomail@.all> wrote in message
news:OmopmQtAEHA.1548@.TK2MSFTNGP12.phx.gbl...
> Thanks... Proper user accounts exist on both domains in question.
> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:%233d64rVAEHA.2484@.TK2MSFTNGP12.phx.gbl...
> ability
> Server
I've
in
> test
Access
>|||Joe,
See if this thread helps:
http://groups.google.com/groups?q=E...SQLServerTables Do you know
what piece of the Access application is raising the error?
SK
JRE wrote:

>A SQL Server (in another domain) I'm trying to connect to with SQL Server
>authentication (UID and password) fails from an Access application. I've
>tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
>mixed authentication mode.
>I can get to the SQL Server with Enterprise Manager, can successfully test
>the connection with the DSN in the ODBC Administrator, and can successfully
>test the connection via a UDL test (OLEDB)...just not through an Access 200
0
>application.
>Can anyone provide the various possible reasons for...
>Connection failed:
>SQLState: '28000'
>SQL Server Error: 18452
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
>'(null)'. Reason: Not associated with a trusted SQL Server connection.
>...?
>Why is the SQL Server receiving a null UID?
>Thanks,
>Joe
>
>
>|||Thanks...I checked out the article. That's pretty much what I do to connect
to a SQL Server back end. The error I get is not an Access error. It's
generated by SQL Server.
"Steve Kass" <skass@.drew.edu> wrote in message
news:u$eUJJZBEHA.1544@.TK2MSFTNGP09.phx.gbl...
> Joe,
> See if this thread helps:
> http://groups.google.com/groups?q=E...SQLServerTables Do you know
> what piece of the Access application is raising the error?
> SK
> JRE wrote:
>
test
successfully
2000
>|||Thanks. I'll pass this on to the SQL Server admin.
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:e1yyddtAEHA.1456@.TK2MSFTNGP09.phx.gbl...
> On SQL Server, enabled auditing for "failed logins" and see if the
accounts
> are being rejected by SQL Server.
> Security auditing at the server level should indicate if the user account
is
> failing to get a server connection.
> Steve
> "JRE" <nomail@.all> wrote in message
> news:OmopmQtAEHA.1548@.TK2MSFTNGP12.phx.gbl...
SQL
> I've
running
> in
successfully
> Access
connection.
>|||Joe,
I know the error is a SQL Server error, but I wanted to know at what
point in your Access application that error is raised - is it a specific
line of VB code, is it when a specific form is opened, etc.? Since you
get the error when you run the Access application, there must be a way
to debug the Access application to see exactly at what point the error
occurs, and what Access is doing at that moment.
SK
JRE wrote:

>Thanks...I checked out the article. That's pretty much what I do to connect
>to a SQL Server back end. The error I get is not an Access error. It's
>generated by SQL Server.
>"Steve Kass" <skass@.drew.edu> wrote in message
>news:u$eUJJZBEHA.1544@.TK2MSFTNGP09.phx.gbl...
>
>test
>
>successfully
>
>2000
>
>
>

Login failed for user '(null)'...Reasons?

A SQL Server (in another domain) I'm trying to connect to with SQL Server
authentication (UID and password) fails from an Access application. I've
tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
mixed authentication mode.
I can get to the SQL Server with Enterprise Manager, can successfully test
the connection with the DSN in the ODBC Administrator, and can successfully
test the connection via a UDL test (OLEDB)...just not through an Access 2000
application.
Can anyone provide the various possible reasons for...
Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'(null)'. Reason: Not associated with a trusted SQL Server connection.
...?
Why is the SQL Server receiving a null UID?
Thanks,
JoeIn order for the server to accept the connection attempt it needs to
"authenticate" that the user is some that has rights (user needs the ability
to connect to the \\servername\ipc$ share). This step happens before SQL
Server gets a change to interrogate the credentials. See Books Online
"Authentication Modes" for more detail.
Steve
"JRE" <nomail@.all> wrote in message
news:#FMgYTUAEHA.3316@.TK2MSFTNGP11.phx.gbl...
> A SQL Server (in another domain) I'm trying to connect to with SQL Server
> authentication (UID and password) fails from an Access application. I've
> tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
> mixed authentication mode.
> I can get to the SQL Server with Enterprise Manager, can successfully test
> the connection with the DSN in the ODBC Administrator, and can
successfully
> test the connection via a UDL test (OLEDB)...just not through an Access
2000
> application.
> Can anyone provide the various possible reasons for...
> Connection failed:
> SQLState: '28000'
> SQL Server Error: 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo
r user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
> ...?
> Why is the SQL Server receiving a null UID?
> Thanks,
> Joe
>
>|||Thanks... Proper user accounts exist on both domains in question.
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:%233d64rVAEHA.2484@.TK2MSFTNGP12.phx.gbl...
> In order for the server to accept the connection attempt it needs to
> "authenticate" that the user is some that has rights (user needs the
ability
> to connect to the \\servername\ipc$ share). This step happens before SQL
> Server gets a change to interrogate the credentials. See Books Online
> "Authentication Modes" for more detail.
> Steve
> "JRE" <nomail@.all> wrote in message
> news:#FMgYTUAEHA.3316@.TK2MSFTNGP11.phx.gbl...
Server
test
> successfully
> 2000
>|||On SQL Server, enabled auditing for "failed logins" and see if the accounts
are being rejected by SQL Server.
Security auditing at the server level should indicate if the user account is
failing to get a server connection.
Steve
"JRE" <nomail@.all> wrote in message
news:OmopmQtAEHA.1548@.TK2MSFTNGP12.phx.gbl...
> Thanks... Proper user accounts exist on both domains in question.
> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:%233d64rVAEHA.2484@.TK2MSFTNGP12.phx.gbl...
> ability
> Server
I've
in
> test
Access
>|||Joe,
See if this thread helps:
http://groups.google.com/groups?q=E...SQLServerTables Do you know
what piece of the Access application is raising the error?
SK
JRE wrote:

>A SQL Server (in another domain) I'm trying to connect to with SQL Server
>authentication (UID and password) fails from an Access application. I've
>tried a ODBC DSN and a DSN-less connection. The SQL Server is running in
>mixed authentication mode.
>I can get to the SQL Server with Enterprise Manager, can successfully test
>the connection with the DSN in the ODBC Administrator, and can successfully
>test the connection via a UDL test (OLEDB)...just not through an Access 200
0
>application.
>Can anyone provide the various possible reasons for...
>Connection failed:
>SQLState: '28000'
>SQL Server Error: 18452
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
>'(null)'. Reason: Not associated with a trusted SQL Server connection.
>...?
>Why is the SQL Server receiving a null UID?
>Thanks,
>Joe
>
>
>|||Thanks...I checked out the article. That's pretty much what I do to connect
to a SQL Server back end. The error I get is not an Access error. It's
generated by SQL Server.
"Steve Kass" <skass@.drew.edu> wrote in message
news:u$eUJJZBEHA.1544@.TK2MSFTNGP09.phx.gbl...
> Joe,
> See if this thread helps:
> http://groups.google.com/groups?q=E...SQLServerTables Do you know
> what piece of the Access application is raising the error?
> SK
> JRE wrote:
>
test
successfully
2000
>|||Thanks. I'll pass this on to the SQL Server admin.
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:e1yyddtAEHA.1456@.TK2MSFTNGP09.phx.gbl...
> On SQL Server, enabled auditing for "failed logins" and see if the
accounts
> are being rejected by SQL Server.
> Security auditing at the server level should indicate if the user account
is
> failing to get a server connection.
> Steve
> "JRE" <nomail@.all> wrote in message
> news:OmopmQtAEHA.1548@.TK2MSFTNGP12.phx.gbl...
SQL
> I've
running
> in
successfully
> Access
connection.
>|||Joe,
I know the error is a SQL Server error, but I wanted to know at what
point in your Access application that error is raised - is it a specific
line of VB code, is it when a specific form is opened, etc.? Since you
get the error when you run the Access application, there must be a way
to debug the Access application to see exactly at what point the error
occurs, and what Access is doing at that moment.
SK
JRE wrote:

>Thanks...I checked out the article. That's pretty much what I do to connect
>to a SQL Server back end. The error I get is not an Access error. It's
>generated by SQL Server.
>"Steve Kass" <skass@.drew.edu> wrote in message
>news:u$eUJJZBEHA.1544@.TK2MSFTNGP09.phx.gbl...
>
>test
>
>successfully
>
>2000
>
>
>|||Hi,
Was this resolved by anybody... I have the same problem and I get the
error when I start the index page. My OS is Win2k with SP4, the ASP is
version 5.0 and not. net, SQL is 2000 sp3. My connection string in the
_appStart.asa file is
Connection string in_appStart.asp =
application("sADOConn") ="Provider=SQLOLEDB;" &_
"Initial Catalog=TheMatrix;" &_
"Data Source=sqlServerName;" &_
"Integrated Security=SSPI;"
I believe the problem is something to do with impersonation and I've
read SP4 handles this differently to SP3. The IIS security as you can
see is Windows Authentication enabled so the app knows what domain
account is accessing it and shows details for that account.
Please help!!
Many thanks!
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
Was this ever resolved.. Have the same problem for my own web app. I get
the error as soon as I launch the app. The connection string is in the
_appstart.asa file and goes like this..
Connection string in_appStart.asp =
application("sADOConn") ="Provider=SQLOLEDB;" &_
"Initial Catalog=TheMatrix;" &_
"Data Source=sqlServerName;" &_
"Integrated Security=SSPI;"
OS is Win2k SP4, ASP is version 5.0 not .net.
When I query the SQL server from my desktop, same place I try to open
the web app, I'm told the system_user is my own domain account.
I'm thinking the problem is to do with how SP4 has changed impersonation
and IIS is set to enable windows authentication. But this is how I
gather what domain user account is accessing the website so they can see
their details. This is the theory but I'm stuck at index page with this
error.
Please help!!
Thanks!!!
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Login failed for user (null). Reason: Not associated with a trusted SQL Server connection.

Anyone,

I have a user "john" whose machine is part of the "job" domain. He is
trying to establish an odbc connection to an MS SQL 2000 server on the
"school" domain. He uses Windows authentication to establish the odbc
connection however it gives the error "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection."

I am guessing that the odbc connection is trying to pass the
credentials of job\john to the sql server. And since the sql server
is on the school domain it expects the credentials of school\john. Is
there anyway to specify the username and password so that this will
work even though the servers are on different domains without having
to trust the domains? Thanks in advance for
any help on this!!

TonyTo log into SQL Server, the user needs a SQL Server login. If your SQL
Server is set up to use NT Authentication or mixed mode authentication on
the Schools domain, then give John a login on the Schools domain and have
him login using those credentials.

"TBone" <tony.despain@.gmail.com> wrote in message
news:64b1ef71.0411261033.1044c9e9@.posting.google.c om...
> Anyone,
> I have a user "john" whose machine is part of the "job" domain. He is
> trying to establish an odbc connection to an MS SQL 2000 server on the
> "school" domain. He uses Windows authentication to establish the odbc
> connection however it gives the error "Login failed for user '(null)'.
> Reason: Not associated with a trusted SQL Server connection."
> I am guessing that the odbc connection is trying to pass the
> credentials of job\john to the sql server. And since the sql server
> is on the school domain it expects the credentials of school\john. Is
> there anyway to specify the username and password so that this will
> work even though the servers are on different domains without having
> to trust the domains? Thanks in advance for
> any help on this!!
> Tony|||Hi

The school domain needs to trust the job domain to allow this to occur. You
could use SQL Server authentication instead if you don't want this trust to
occur.

John

"TBone" <tony.despain@.gmail.com> wrote in message
news:64b1ef71.0411261033.1044c9e9@.posting.google.c om...
> Anyone,
> I have a user "john" whose machine is part of the "job" domain. He is
> trying to establish an odbc connection to an MS SQL 2000 server on the
> "school" domain. He uses Windows authentication to establish the odbc
> connection however it gives the error "Login failed for user '(null)'.
> Reason: Not associated with a trusted SQL Server connection."
> I am guessing that the odbc connection is trying to pass the
> credentials of job\john to the sql server. And since the sql server
> is on the school domain it expects the credentials of school\john. Is
> there anyway to specify the username and password so that this will
> work even though the servers are on different domains without having
> to trust the domains? Thanks in advance for
> any help on this!!
> Tony

Login Failed for Linked Server

In EM I am trying to create a link between two SQL SQL2K servers using NT
domain logins. It works using SQL Server logins, but not with NT logins.
The error message is "Error 18456: Login failed for user 'NT
AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
servers. I have checked the 'be made using the logins current security
context' box in the security tab. I can run querys against the second
server, but I need to run a linked query. We are trying to keep to NT logins
for everything, so I prefer not to use SQL logins.DaveK wrote:
> In EM I am trying to create a link between two SQL SQL2K servers using NT
> domain logins. It works using SQL Server logins, but not with NT logins.
> The error message is "Error 18456: Login failed for user 'NT
> AUTHORITY\ANONOYMUS LOGIN'. What am I doing wrong? I am the DBA on both
> servers. I have checked the 'be made using the logins current security
> context' box in the security tab. I can run querys against the second
> server, but I need to run a linked query. We are trying to keep to NT logins
> for everything, so I prefer not to use SQL logins.
Hi
Try to look up "delegation" in Books On Line. There are a few settings
in your domain that has to be in place in order to use NT login for
Linked servers.
Regards
Steen

login failed events for administrator account??

Hi,
I see a lot of login failed errors in the event log.
its the domain\administrator account.
the data associated to this event is:
<server name>.master
I suppose its an access to the master database the reason of this error.
but the user has access to this database.
the event is generated every 10 minutes and 5 minutes later then again 10
minutes...
any idea?
thanks.
Jerome.Maybe some service is trying to connect? You could get more data with
Profiler, tray to catch this login failed event.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Jj" <willgart@.AAAhotmailBBB.com> wrote in message
news:OL$RqwBrFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I see a lot of login failed errors in the event log.
> its the domain\administrator account.
> the data associated to this event is:
> <server name>.master
> I suppose its an access to the master database the reason of this error.
> but the user has access to this database.
> the event is generated every 10 minutes and 5 minutes later then again 10
> minutes...
> any idea?
> thanks.
> Jerome.
>|||I have identified that its portal server the service which generate this
error.
I try to change some config in sharepoint, but the error is here again.
also this account access all databases without any problem, portal server
generates a lot of access but only 1 (but unidentified) of these requests
failed.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OufyX6FrFHA.2008@.TK2MSFTNGP10.phx.gbl...
> Maybe some service is trying to connect? You could get more data with
> Profiler, tray to catch this login failed event.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Jj" <willgart@.AAAhotmailBBB.com> wrote in message
> news:OL$RqwBrFHA.3424@.TK2MSFTNGP14.phx.gbl...
>

login failed events for administrator account??

Hi,
I see a lot of login failed errors in the event log.
its the domain\administrator account.
the data associated to this event is:
<server name>.master
I suppose its an access to the master database the reason of this error.
but the user has access to this database.
the event is generated every 10 minutes and 5 minutes later then again 10
minutes...
any idea?
thanks.
Jerome.Maybe some service is trying to connect? You could get more data with
Profiler, tray to catch this login failed event.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Jéjé" <willgart@.AAAhotmailBBB.com> wrote in message
news:OL$RqwBrFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I see a lot of login failed errors in the event log.
> its the domain\administrator account.
> the data associated to this event is:
> <server name>.master
> I suppose its an access to the master database the reason of this error.
> but the user has access to this database.
> the event is generated every 10 minutes and 5 minutes later then again 10
> minutes...
> any idea?
> thanks.
> Jerome.
>|||I have identified that its portal server the service which generate this
error.
I try to change some config in sharepoint, but the error is here again.
also this account access all databases without any problem, portal server
generates a lot of access but only 1 (but unidentified) of these requests
failed.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OufyX6FrFHA.2008@.TK2MSFTNGP10.phx.gbl...
> Maybe some service is trying to connect? You could get more data with
> Profiler, tray to catch this login failed event.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Jéjé" <willgart@.AAAhotmailBBB.com> wrote in message
> news:OL$RqwBrFHA.3424@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I see a lot of login failed errors in the event log.
>> its the domain\administrator account.
>> the data associated to this event is:
>> <server name>.master
>> I suppose its an access to the master database the reason of this error.
>> but the user has access to this database.
>> the event is generated every 10 minutes and 5 minutes later then again 10
>> minutes...
>> any idea?
>> thanks.
>> Jerome.
>

login failed events for administrator account??

Hi,
I see a lot of login failed errors in the event log.
its the domain\administrator account.
the data associated to this event is:
<server name>.master
I suppose its an access to the master database the reason of this error.
but the user has access to this database.
the event is generated every 10 minutes and 5 minutes later then again 10
minutes...
any idea?
thanks.
Jerome.
Maybe some service is trying to connect? You could get more data with
Profiler, tray to catch this login failed event.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Jj" <willgart@.AAAhotmailBBB.com> wrote in message
news:OL$RqwBrFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I see a lot of login failed errors in the event log.
> its the domain\administrator account.
> the data associated to this event is:
> <server name>.master
> I suppose its an access to the master database the reason of this error.
> but the user has access to this database.
> the event is generated every 10 minutes and 5 minutes later then again 10
> minutes...
> any idea?
> thanks.
> Jerome.
>
|||I have identified that its portal server the service which generate this
error.
I try to change some config in sharepoint, but the error is here again.
also this account access all databases without any problem, portal server
generates a lot of access but only 1 (but unidentified) of these requests
failed.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OufyX6FrFHA.2008@.TK2MSFTNGP10.phx.gbl...
> Maybe some service is trying to connect? You could get more data with
> Profiler, tray to catch this login failed event.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Jj" <willgart@.AAAhotmailBBB.com> wrote in message
> news:OL$RqwBrFHA.3424@.TK2MSFTNGP14.phx.gbl...
>

login failed error

I am trying to export data from one sql server instance to another on another domain.
however trying to connect to the remote instance never works due to 'login failed' error.
i have access to the remote domain and can verify that the login is correct.
what is the problem?
--
Message posted via http://www.sqlmonster.comCan you be a little more specific as to exactly how you are attempting this?
Are you using DTS, a remote query or what? How are you connecting and what
is the connection string?
--
Andrew J. Kelly SQL MVP
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:94ee95ffac054cb6af4c94330d544b85@.SQLMonster.com...
>I am trying to export data from one sql server instance to another on
>another domain.
> however trying to connect to the remote instance never works due to 'login
> failed' error.
> i have access to the remote domain and can verify that the login is
> correct.
> what is the problem?
> --
> Message posted via http://www.sqlmonster.com

login failed error

I am trying to export data from one sql server instance to another on anothe
r domain.
however trying to connect to the remote instance never works due to 'login f
ailed' error.
i have access to the remote domain and can verify that the login is correct.
what is the problem?
Message posted via http://www.droptable.comCan you be a little more specific as to exactly how you are attempting this?
Are you using DTS, a remote query or what? How are you connecting and what
is the connection string?
Andrew J. Kelly SQL MVP
"Mark Evans via droptable.com" <forum@.droptable.com> wrote in message
news:94ee95ffac054cb6af4c94330d544b85@.SQ
droptable.com...
>I am trying to export data from one sql server instance to another on
>another domain.
> however trying to connect to the remote instance never works due to 'login
> failed' error.
> i have access to the remote domain and can verify that the login is
> correct.
> what is the problem?
> --
> Message posted via http://www.droptable.com

login failed error

I am trying to export data from one sql server instance to another on another domain.
however trying to connect to the remote instance never works due to 'login failed' error.
i have access to the remote domain and can verify that the login is correct.
what is the problem?
Message posted via http://www.sqlmonster.com
Can you be a little more specific as to exactly how you are attempting this?
Are you using DTS, a remote query or what? How are you connecting and what
is the connection string?
Andrew J. Kelly SQL MVP
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:94ee95ffac054cb6af4c94330d544b85@.SQLMonster.c om...
>I am trying to export data from one sql server instance to another on
>another domain.
> however trying to connect to the remote instance never works due to 'login
> failed' error.
> i have access to the remote domain and can verify that the login is
> correct.
> what is the problem?
> --
> Message posted via http://www.sqlmonster.com

Login failed after reseting password

I was away from the office and there was a need to check in a few
sourcesafed documents. My domain user account had its password changed.
When I got back, I changed it back to the same password I have always
used. However, I now am experienced login issues with every server on
the domain using windows auth. Does setting the password create a new
profile? Can I not login to SQL Server becuase the SID has changed? Is
there anyway to restore my domain account so it has access to the SQL
Servers using windows auth. We are running Windows XP Pro and SQL
Server 2000 sp4. This error is essentially putting me out of
commission. Any suggestions?Hi
The SID remains the same.
If the domain is working correctly, the updated password should propagate
within a few minutes. Try logging off, rebooting and then see if you can
authenticate. You may want to try logging if from a different machine to
verify it is not machine specific.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<chase.colburn@.gmail.com> wrote in message
news:1133971287.204872.168840@.g49g2000cwa.googlegroups.com...
>I was away from the office and there was a need to check in a few
> sourcesafed documents. My domain user account had its password changed.
> When I got back, I changed it back to the same password I have always
> used. However, I now am experienced login issues with every server on
> the domain using windows auth. Does setting the password create a new
> profile? Can I not login to SQL Server becuase the SID has changed? Is
> there anyway to restore my domain account so it has access to the SQL
> Servers using windows auth. We are running Windows XP Pro and SQL
> Server 2000 sp4. This error is essentially putting me out of
> commission. Any suggestions?
>|||Thank you for the suggestion. This error persisted after about a day
and a half of troubleshooting, logging in as different users,
rebooting, ect. I just finally went ahead and bite the bullet and
reinstalled SQL Server. It was a little messy getting everything back
to normal but I seem to be authenticating fine now. I am still curious
as to why I had this problem and whether or not a reinstall could have
been prevented. If anyone has any insight, please feel to post.

Login Authentication for Standard Accounts

We have a couple of vendor applications that create standard accounts.
These accounts have the same format as our domain accounts. For
example, my Windows account would be <domain>\<user_name>. The SQL
standard account would be <user_name>.
What we would like to do is change the login process to validate
against active directory either prior to or instead of checking the
SQL password. Everything else could remain the same.
This would be on SQL 2000 or SQL 2005. Any suggestions or other
insight would be appreciated.RogerT (roger.tompkins@.gmail.com) writes:
> We have a couple of vendor applications that create standard accounts.
> These accounts have the same format as our domain accounts. For
> example, my Windows account would be <domain>\<user_name>. The SQL
> standard account would be <user_name>.
> What we would like to do is change the login process to validate
> against active directory either prior to or instead of checking the
> SQL password. Everything else could remain the same.
> This would be on SQL 2000 or SQL 2005. Any suggestions or other
> insight would be appreciated.
I'm not really sure what you mean here. SQL Server provides to
means of authentication: SQL authentication and Windows authentication.
It sounds from your description that the vendor accounts are for
SQL authentication. But you cannot change a login from being an SQL
login, to be a Windows login. These two types of logins are competely
unconnected.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Login Attempt through EM

Strange opportunity here: I have a sql server that I manage it is not in a
domain but uses my domain id for a local login account. ie domain\tbolin,
localserver\tbolin.
I have the SQL registered from my desktop using sa, but idea I know. The
issue is that my local id get locks out. I noticed in the security logs tha
t
my domain account is getting a login failure every 17 seconds, and causes
windows to lock my local account.
How can that be when they are not even connected?
Also why is EM trying to login to the server when it is registered as sa?
THomIt's probably the polling of the services from Enterprise
Manager. Try turning off the polling and see if that makes a
difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Fri, 4 Nov 2005 07:59:12 -0800, "Thom"
<Thom@.discussions.microsoft.com> wrote:

>Strange opportunity here: I have a sql server that I manage it is not in a
>domain but uses my domain id for a local login account. ie domain\tbolin,
>localserver\tbolin.
>I have the SQL registered from my desktop using sa, but idea I know. The
>issue is that my local id get locks out. I noticed in the security logs th
at
>my domain account is getting a login failure every 17 seconds, and causes
>windows to lock my local account.
>How can that be when they are not even connected?
>Also why is EM trying to login to the server when it is registered as sa?
>THom

Login and corresponding user rights

Hello,
I want to retrieve information for a SQL or NT login that has different
types of privileges in all the DB's. Lets say NT login Domain\Test has access
to pubs, Northwind, HR, Finance. This login has db_datareader to pubs,
db_datareader and db_datawriter to Northwind, public to HR and Finance. So I
just need the full summary with one script.
I can look this info by clicking the login in security folder in enterprise
manager. But I have over 200 databases in many different servers and it takes
huge time.
I really appreciate it in advance.
David,
Did you try with sp_helpuser?
AMB
"David" wrote:

> Hello,
> I want to retrieve information for a SQL or NT login that has different
> types of privileges in all the DB's. Lets say NT login Domain\Test has access
> to pubs, Northwind, HR, Finance. This login has db_datareader to pubs,
> db_datareader and db_datawriter to Northwind, public to HR and Finance. So I
> just need the full summary with one script.
> I can look this info by clicking the login in security folder in enterprise
> manager. But I have over 200 databases in many different servers and it takes
> huge time.
> I really appreciate it in advance.

Login and corresponding user rights

Hello,
I want to retrieve information for a SQL or NT login that has different
types of privileges in all the DB's. Lets say NT login Domain\Test has acces
s
to pubs, Northwind, HR, Finance. This login has db_datareader to pubs,
db_datareader and db_datawriter to Northwind, public to HR and Finance. So I
just need the full summary with one script.
I can look this info by clicking the login in security folder in enterprise
manager. But I have over 200 databases in many different servers and it take
s
huge time.
I really appreciate it in advance.David,
Did you try with sp_helpuser?
AMB
"David" wrote:

> Hello,
> I want to retrieve information for a SQL or NT login that has different
> types of privileges in all the DB's. Lets say NT login Domain\Test has acc
ess
> to pubs, Northwind, HR, Finance. This login has db_datareader to pubs,
> db_datareader and db_datawriter to Northwind, public to HR and Finance. So
I
> just need the full summary with one script.
> I can look this info by clicking the login in security folder in enterpris
e
> manager. But I have over 200 databases in many different servers and it ta
kes
> huge time.
> I really appreciate it in advance.

Login Account

Hello,
When I try to add a login account to SQL Server, I get the following error.
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
The account is the built in Windows Administrator account renamed.
Any and all help is greatly appreciated.
Thanks,
Donnie
"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following
> error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
I'm not following here.
Did you:
1. Create a new Windows Account and grant it all the same privs and the
Administrator account?
2. Rename the Windows Administrator account. (Not sure if you can even do
that...)
When you tried to add the account, were you using sp_grantlogin, sp_addlogin
or SQL Enterprise Manager?
When you tried to add the account, did you specify the domain\user name
like: MyLocalComputer\Administrator or something else?
Is it a Domain account?
Does the account have access to your local server?
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick,
Thanks for your reply.
The renamed administrator account is the built-in default administrator
account for Windows 2003 SBS.
When I try to add this account using Enterprise Manager on the same server,
I get the error:
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
Hope this clarifies the issue. Thanks for your help.
Donnie
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> I'm not following here.
> Did you:
> 1. Create a new Windows Account and grant it all the same privs and the
> Administrator account?
> 2. Rename the Windows Administrator account. (Not sure if you can even
> do that...)
> When you tried to add the account, were you using sp_grantlogin,
> sp_addlogin or SQL Enterprise Manager?
> When you tried to add the account, did you specify the domain\user name
> like: MyLocalComputer\Administrator or something else?
> Is it a Domain account?
> Does the account have access to your local server?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Rick,
> Thanks for your reply.
> The renamed administrator account is the built-in default administrator
> account for Windows 2003 SBS.
> When I try to add this account using Enterprise Manager on the same
> server, I get the error:
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> Hope this clarifies the issue. Thanks for your help.
> Donnie
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>
I don't know if this will help here, but have you restarted the server with
the account name change?
Rick
|||Yes. The account has been renamed for some time now.
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23bsj0o5lFHA.320@.TK2MSFTNGP09.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> I don't know if this will help here, but have you restarted the server
> with the account name change?
>
> Rick
>
>
|||Hi,
Are you specifying the account as:
NameOfComputer\AccountName
?
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
|||Hey Dan,
I am specifiying as
Domain\AccountName
Thanks,
Donnie
"Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Are you specifying the account as:
> NameOfComputer\AccountName
> ?
> --
> HTH
> Dan Artuso, Access MVP
>
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>
|||Hi,
I think we mean the same thing :-)
If you're specifying a local account, the 'Domain' is the computer name.
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OP$fQxQmFHA.2628@.tk2msftngp13.phx.gbl...
> Hey Dan,
> I am specifiying as
> Domain\AccountName
> Thanks,
> Donnie
> "Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
> news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
>

Login Account

Hello,
When I try to add a login account to SQL Server, I get the following error.
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
The account is the built in Windows Administrator account renamed.
Any and all help is greatly appreciated.
Thanks,
Donnie"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following
> error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
I'm not following here.
Did you:
1. Create a new Windows Account and grant it all the same privs and the
Administrator account?
2. Rename the Windows Administrator account. (Not sure if you can even do
that...)
When you tried to add the account, were you using sp_grantlogin, sp_addlogin
or SQL Enterprise Manager?
When you tried to add the account, did you specify the domain\user name
like: MyLocalComputer\Administrator or something else?
Is it a Domain account?
Does the account have access to your local server?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick,
Thanks for your reply.
The renamed administrator account is the built-in default administrator
account for Windows 2003 SBS.
When I try to add this account using Enterprise Manager on the same server,
I get the error:
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
Hope this clarifies the issue. Thanks for your help.
Donnie
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
> I'm not following here.
> Did you:
> 1. Create a new Windows Account and grant it all the same privs and the
> Administrator account?
> 2. Rename the Windows Administrator account. (Not sure if you can even
> do that...)
> When you tried to add the account, were you using sp_grantlogin,
> sp_addlogin or SQL Enterprise Manager?
> When you tried to add the account, did you specify the domain\user name
> like: MyLocalComputer\Administrator or something else?
> Is it a Domain account?
> Does the account have access to your local server?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Rick,
> Thanks for your reply.
> The renamed administrator account is the built-in default administrator
> account for Windows 2003 SBS.
> When I try to add this account using Enterprise Manager on the same
> server, I get the error:
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> Hope this clarifies the issue. Thanks for your help.
> Donnie
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
>> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
>>
>> I'm not following here.
>> Did you:
>> 1. Create a new Windows Account and grant it all the same privs and the
>> Administrator account?
>> 2. Rename the Windows Administrator account. (Not sure if you can even
>> do that...)
>> When you tried to add the account, were you using sp_grantlogin,
>> sp_addlogin or SQL Enterprise Manager?
>> When you tried to add the account, did you specify the domain\user name
>> like: MyLocalComputer\Administrator or something else?
>> Is it a Domain account?
>> Does the account have access to your local server?
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>
I don't know if this will help here, but have you restarted the server with
the account name change?
Rick|||Yes. The account has been renamed for some time now.
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23bsj0o5lFHA.320@.TK2MSFTNGP09.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
>> Rick,
>> Thanks for your reply.
>> The renamed administrator account is the built-in default administrator
>> account for Windows 2003 SBS.
>> When I try to add this account using Enterprise Manager on the same
>> server, I get the error:
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> Hope this clarifies the issue. Thanks for your help.
>> Donnie
>> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
>> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
>> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
>>
>> I'm not following here.
>> Did you:
>> 1. Create a new Windows Account and grant it all the same privs and the
>> Administrator account?
>> 2. Rename the Windows Administrator account. (Not sure if you can even
>> do that...)
>> When you tried to add the account, were you using sp_grantlogin,
>> sp_addlogin or SQL Enterprise Manager?
>> When you tried to add the account, did you specify the domain\user name
>> like: MyLocalComputer\Administrator or something else?
>> Is it a Domain account?
>> Does the account have access to your local server?
>>
>> Rick Sawtell
>> MCT, MCSD, MCDBA
>>
>>
>>
> I don't know if this will help here, but have you restarted the server
> with the account name change?
>
> Rick
>
>|||Hi,
Are you specifying the account as:
NameOfComputer\AccountName
?
--
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>|||Hey Dan,
I am specifiying as
Domain\AccountName
Thanks,
Donnie
"Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Are you specifying the account as:
> NameOfComputer\AccountName
> ?
> --
> HTH
> Dan Artuso, Access MVP
>
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> When I try to add a login account to SQL Server, I get the following
>> error.
>> " Error 15401: Windows NT user or group "Domain\User" not found.
>> Check the name again. "
>> The account is the built in Windows Administrator account renamed.
>> Any and all help is greatly appreciated.
>> Thanks,
>> Donnie
>>
>|||Hi,
I think we mean the same thing :-)
If you're specifying a local account, the 'Domain' is the computer name.
--
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OP$fQxQmFHA.2628@.tk2msftngp13.phx.gbl...
> Hey Dan,
> I am specifiying as
> Domain\AccountName
> Thanks,
> Donnie
> "Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
> news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> > Are you specifying the account as:
> >
> > NameOfComputer\AccountName
> > ?
> >
> > --
> > HTH
> > Dan Artuso, Access MVP
> >
> >
> > "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> > news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> >> Hello,
> >> When I try to add a login account to SQL Server, I get the following
> >> error.
> >>
> >> " Error 15401: Windows NT user or group "Domain\User" not found.
> >> Check the name again. "
> >>
> >> The account is the built in Windows Administrator account renamed.
> >>
> >> Any and all help is greatly appreciated.
> >>
> >> Thanks,
> >> Donnie
> >>
> >>
> >>
> >
> >
>

Login Account

Hello,
When I try to add a login account to SQL Server, I get the following error.
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
The account is the built in Windows Administrator account renamed.
Any and all help is greatly appreciated.
Thanks,
Donnie"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following
> error.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>
I'm not following here.
Did you:
1. Create a new Windows Account and grant it all the same privs and the
Administrator account?
2. Rename the Windows Administrator account. (Not sure if you can even do
that...)
When you tried to add the account, were you using sp_grantlogin, sp_addlogin
or SQL Enterprise Manager?
When you tried to add the account, did you specify the domain\user name
like: MyLocalComputer\Administrator or something else?
Is it a Domain account?
Does the account have access to your local server?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick,
Thanks for your reply.
The renamed administrator account is the built-in default administrator
account for Windows 2003 SBS.
When I try to add this account using Enterprise Manager on the same server,
I get the error:
" Error 15401: Windows NT user or group "Domain\User" not found.
Check the name again. "
Hope this clarifies the issue. Thanks for your help.
Donnie
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
> I'm not following here.
> Did you:
> 1. Create a new Windows Account and grant it all the same privs and the
> Administrator account?
> 2. Rename the Windows Administrator account. (Not sure if you can even
> do that...)
> When you tried to add the account, were you using sp_grantlogin,
> sp_addlogin or SQL Enterprise Manager?
> When you tried to add the account, did you specify the domain\user name
> like: MyLocalComputer\Administrator or something else?
> Is it a Domain account?
> Does the account have access to your local server?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||"Donald Sweat" <donsweat@.hotmail.com> wrote in message
news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Rick,
> Thanks for your reply.
> The renamed administrator account is the built-in default administrator
> account for Windows 2003 SBS.
> When I try to add this account using Enterprise Manager on the same
> server, I get the error:
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> Hope this clarifies the issue. Thanks for your help.
> Donnie
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:%23SWnmS4lFHA.2920@.TK2MSFTNGP14.phx.gbl...
>
I don't know if this will help here, but have you restarted the server with
the account name change?
Rick|||Yes. The account has been renamed for some time now.
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:%23bsj0o5lFHA.320@.TK2MSFTNGP09.phx.gbl...
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OXnHDP5lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> I don't know if this will help here, but have you restarted the server
> with the account name change?
>
> Rick
>
>|||Hi,
Are you specifying the account as:
NameOfComputer\AccountName
?
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OMP54h3lFHA.3380@.TK2MSFTNGP12.ph
x.gbl...
> Hello,
> When I try to add a login account to SQL Server, I get the following error
.
> " Error 15401: Windows NT user or group "Domain\User" not found.
> Check the name again. "
> The account is the built in Windows Administrator account renamed.
> Any and all help is greatly appreciated.
> Thanks,
> Donnie
>
>|||Hey Dan,
I am specifiying as
Domain\AccountName
Thanks,
Donnie
"Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Are you specifying the account as:
> NameOfComputer\AccountName
> ?
> --
> HTH
> Dan Artuso, Access MVP
>
> "Donald Sweat" <donsweat@.hotmail.com> wrote in message
> news:OMP54h3lFHA.3380@.TK2MSFTNGP12.phx.gbl...
>|||Hi,
I think we mean the same thing :-)
If you're specifying a local account, the 'Domain' is the computer name.
HTH
Dan Artuso, Access MVP
"Donald Sweat" <donsweat@.hotmail.com> wrote in message news:OP$fQxQmFHA.2628@.tk2msftngp13.ph
x.gbl...
> Hey Dan,
> I am specifiying as
> Domain\AccountName
> Thanks,
> Donnie
> "Dan Artuso" <dartuso@.NSpagepearls.com> wrote in message
> news:OjT6jp7lFHA.3380@.TK2MSFTNGP10.phx.gbl...
>