Error 18456 - domain admins only users that can authenticate

Server 2003
SQL 2000 SP3a
I have my server set up and my ODBC client configured. When I log in as
myself, as a domain admin, I can set my authentication to Windows (in my
ODBC), when I log on as a Domain Users, I cannot.
I get and error 18456. My server properties show SQL Server and Windows
authentication is allowed and there is no semi-colon in my password. What
security setting am I missing to allow my domain users to authenticate via
Windows authentication?
TIAHi,
Did you gave domain OS user access to SQL Server?
If not; open Enterprise manager and use Security option to add the Domain
user/group to SQL Server.
Thanks
Hari
SQL Server MVP
"dsb" <dsb@.discussions.microsoft.com> wrote in message
news:F7A3CA7A-1012-4673-8CDF-9B4B66583A3A@.microsoft.com...
> Server 2003
> SQL 2000 SP3a
> I have my server set up and my ODBC client configured. When I log in as
> myself, as a domain admin, I can set my authentication to Windows (in my
> ODBC), when I log on as a Domain Users, I cannot.
> I get and error 18456. My server properties show SQL Server and Windows
> authentication is allowed and there is no semi-colon in my password. What
> security setting am I missing to allow my domain users to authenticate via
> Windows authentication?
> TIA

Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER

I was rebuilding my index and my system admin rebooted the system without
shutting down the database first. After the reboot the SQLSERVERAGENT and
MSSQLSERVER services won't start and I received ERROR 1068:The dependency
service or group failed to start error while trying to start the two services.
In the Enterprise Manger screen I saw:
Connection failed, check SQL Server Registration Properties
I am not sure how to fix this problem. Can I rebuild my SQL Server
registery, and if so, how? Please advise. Thanks in advance.
Hi,
Could you please open the SQL server errorlog in program files\microsoft sql
server\log folder and investigate more on this error.
Thanks
Hari
MCDBA
"Ling" wrote:

> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.
|||There's only one line in the errorlog:
2004-09-22 11:28:07.03 server The system is older than SQL Server 7.0 RTM
version and is not supported by this server
"Hari Prasad" wrote:
[vbcol=seagreen]
> Hi,
> Could you please open the SQL server errorlog in program files\microsoft sql
> server\log folder and investigate more on this error.
> Thanks
> Hari
> MCDBA
>
> "Ling" wrote:
|||What exact messages do you get if you from a DOS prompt type below?
NET START MSSQLSERVER
(Adjust server name of it is a named instance.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ling" <Ling@.discussions.microsoft.com> wrote in message
news:F823DF33-6210-4E2D-AA98-37E2FEFD1659@.microsoft.com...
> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.

Errocde = 3

Hi..
I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
if I use normal user system will display error message like :
gereral SQL error
[MICROSOFT][ODBC SQL server Driver][SQL server]string or binary
data would
be trunated
[MicroSoft][ODBC SQL server Driver][SQL Server]the statement has
been
terminted
[MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
What's problem?how to solved it'
ThanksCan you reproduce this by running the code from within Query Analyzer?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James" <James@.discussions.microsoft.com> wrote in message
news:E4DC72AA-BC62-42F7-8552-6BB9212BFD4D@.microsoft.com...
> Hi..
> I wrote a StoreProcedure and use delphi to call it. if I am admin it run O
K,
> if I use normal user system will display error message like :
> gereral SQL error
> [MICROSOFT][ODBC SQL server Driver][SQL server]string or binar
y data would
> be trunated
> [MicroSoft][ODBC SQL server Driver][SQL Server]the statement h
as been
> terminted
> [MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
> What's problem?how to solved it'
> Thanks
>

Errocde = 3

Hi..
I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
if I use normal user system will display error message like :
gereral SQL error
[MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
be trunated
[MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
terminted
[MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
What's problem?how to solved it?
Thanks
Can you reproduce this by running the code from within Query Analyzer?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James" <James@.discussions.microsoft.com> wrote in message
news:E4DC72AA-BC62-42F7-8552-6BB9212BFD4D@.microsoft.com...
> Hi..
> I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
> if I use normal user system will display error message like :
> gereral SQL error
> [MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
> be trunated
> [MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
> terminted
> [MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
> What's problem?how to solved it?
> Thanks
>

Errocde = 3

Hi..
I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
if I use normal user system will display error message like :
gereral SQL error
[MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
be trunated
[MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
terminted
[MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
What's problem?how to solved it'
ThanksCan you reproduce this by running the code from within Query Analyzer?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James" <James@.discussions.microsoft.com> wrote in message
news:E4DC72AA-BC62-42F7-8552-6BB9212BFD4D@.microsoft.com...
> Hi..
> I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
> if I use normal user system will display error message like :
> gereral SQL error
> [MICROSOFT][ODBC SQL server Driver][SQL server]string or binary data would
> be trunated
> [MicroSoft][ODBC SQL server Driver][SQL Server]the statement has been
> terminted
> [MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
> What's problem?how to solved it'
> Thanks
>