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

I have installed MSDE on a w/s and when logged in as administrator I can
access the server using OSQL -E however if I am logged in as a user and try
to access the server I am denied access.
I have the SQL tools installed on a different machine and would like to
access this server using EM across the LAN, on the machine running EM do I
need to login as administrator in order to connect the MSDE server machine ?
Thanks
Murphy
"Murphy" <Murphy@.murphy.com> wrote in message
news:u3stcLpLEHA.1052@.TK2MSFTNGP12.phx.gbl...
> I have installed MSDE on a w/s and when logged in as administrator I can
> access the server using OSQL -E however if I am logged in as a user and
try
> to access the server I am denied access.
> I have the SQL tools installed on a different machine and would like to
> access this server using EM across the LAN, on the machine running EM do I
> need to login as administrator in order to connect the MSDE server machine
?
> Thanks
> Murphy
>
I have just logged in ad administrator on the machine running EM and tried
to connect to the MSDE server using:
C:\>osql -S MachineA -E
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
C:\>
This command works perfectly when run on the machine runnng MSDE when logged
in as adminsitrator...
What am I missing ?
Thanks
Murphy
|||Is there anything which could be blocking the connection?
Are the machines part of a workgroup or domain?
Some Links:
http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k
Cheers,
James Goodman
"Murphy" <murphy@.murphy.com> wrote in message
news:evoz1NpLEHA.1388@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> "Murphy" <Murphy@.murphy.com> wrote in message
> news:u3stcLpLEHA.1052@.TK2MSFTNGP12.phx.gbl...
> try
I[vbcol=seagreen]
machine
> ?
> I have just logged in ad administrator on the machine running EM and tried
> to connect to the MSDE server using:
> C:\>osql -S MachineA -E
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
> C:\>
> This command works perfectly when run on the machine runnng MSDE when
logged
> in as adminsitrator...
> What am I missing ?
> Thanks
> Murphy
>
|||There's no local firewall running etc and the machines are part of a domain.
Thanks
Murphy
"James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:uqnZ0cpLEHA.556@.tk2msftngp13.phx.gbl...
> Is there anything which could be blocking the connection?
> Are the machines part of a workgroup or domain?
>
> Some Links:
>
http://support.microsoft.com/default...&Product=sql2k
>
http://support.microsoft.com/default...&Product=sql2k[vbcol=seagreen]
>
>
> --
> Cheers,
> James Goodman
> "Murphy" <murphy@.murphy.com> wrote in message
> news:evoz1NpLEHA.1388@.TK2MSFTNGP09.phx.gbl...
can[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]
do[vbcol=seagreen]
> I
> machine
tried
> logged
>

Login error at Microsoft SQl server 2005

when i tried to login at SQL server 2005 by my local account i found an error (i login by the administrator account and use windows authentication) ... can any one help me plz?

Which error did you get ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||See this http://msdn2.microsoft.com/en-us/library/ms366351.aspx is any help.

Login attempts

are there option for administrator to set the number of
attempts of password login into the sql server?
thanksHi,
In SQL Server authentication you can't set the password attempts, because
there is no password policies inside sql server.
You can set password attempts policy for Windows based logins.
How to set
1. Control panel-- Adminstraive tools
2. Select Local security settings
3. Select account lockout policy and select Account lockout threshold.
4. DEfine the value for that policy and click ok.
Thanks
Hari
MCDBA
"NG" <angiecmf@.hotmail.com> wrote in message
news:11bba01c410ae$8a7e6670$a401280a@.phx
.gbl...
> are there option for administrator to set the number of
> attempts of password login into the sql server?
> thanks

Login as sa

How do I login to Query Analyser or EM as system administrator (sa) ?Alan wrote:
> How do I login to Query Analyser or EM as system administrator (sa) ?
Enter "sa" as the user name
Enter the sa password
Press OK.
If your server is not set up for Mixed-mode security, you may need to
enable that option to use the "sa" login.
If you've lost the "sa" password, you can log into the server using any
other administrator account and change the password for the "sa" user.
What trouble are you running into?
David Gugick
Imceda Software
www.imceda.com|||I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> > How do I login to Query Analyser or EM as system administrator (sa) ?
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||It exists but will give you an error that the connection is not trusted and
will refuse it if tried. However, give the account A VERY STRONG PASSWORD
as it is very easy to switch SQL Server's Authentication mode.
Sincerely,
Anthony Thomas
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eRk4SKgHFHA.3624@.tk2msftngp13.phx.gbl...
I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> > How do I login to Query Analyser or EM as system administrator (sa) ?
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Login as sa

How do I login to Query Analyser or EM as system administrator (sa) ?Alan wrote:
> How do I login to Query Analyser or EM as system administrator (sa) ?
Enter "sa" as the user name
Enter the sa password
Press OK.
If your server is not set up for Mixed-mode security, you may need to
enable that option to use the "sa" login.
If you've lost the "sa" password, you can log into the server using any
other administrator account and change the password for the "sa" user.
What trouble are you running into?
David Gugick
Imceda Software
www.imceda.com|||I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||It exists but will give you an error that the connection is not trusted and
will refuse it if tried. However, give the account A VERY STRONG PASSWORD
as it is very easy to switch SQL Server's Authentication mode.
Sincerely,
Anthony Thomas
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eRk4SKgHFHA.3624@.tk2msftngp13.phx.gbl...
I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>

Login as sa

How do I login to Query Analyser or EM as system administrator (sa) ?
Alan wrote:
> How do I login to Query Analyser or EM as system administrator (sa) ?
Enter "sa" as the user name
Enter the sa password
Press OK.
If your server is not set up for Mixed-mode security, you may need to
enable that option to use the "sa" login.
If you've lost the "sa" password, you can log into the server using any
other administrator account and change the password for the "sa" user.
What trouble are you running into?
David Gugick
Imceda Software
www.imceda.com
|||I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||It exists but will give you an error that the connection is not trusted and
will refuse it if tried. However, give the account A VERY STRONG PASSWORD
as it is very easy to switch SQL Server's Authentication mode.
Sincerely,
Anthony Thomas

"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:eRk4SKgHFHA.3624@.tk2msftngp13.phx.gbl...
I installed the SQL Server 2000 as Windows Authentication mode, just wonder
if there is a sa login.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23Cdsx1uGFHA.4084@.TK2MSFTNGP14.phx.gbl...
> Alan wrote:
> Enter "sa" as the user name
> Enter the sa password
> Press OK.
> If your server is not set up for Mixed-mode security, you may need to
> enable that option to use the "sa" login.
> If you've lost the "sa" password, you can log into the server using any
> other administrator account and change the password for the "sa" user.
> What trouble are you running into?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>