Re: MSDE installation/connection issues
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 07/19/04
- Next message: Lee Trotter: "Date in SQL insert"
- Previous message: Alan Brewer [MSFT]: "Re: osql command reference?"
- In reply to: public.microsoft.com: "MSDE installation/connection issues"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 22:51:20 +0200
hi,
"public.microsoft.com" <lakamsani AT gmail.com> ha scritto nel messaggio
news:%23kZ5Z$cbEHA.3684@TK2MSFTNGP09.phx.gbl...
> I installed MSDE (sp3a) in a Windows 2000 server SP4. This is configured
to
> be a domain controller and (AD turned on). I can use MSDE webadmin to
> access the database instance fine. I have a couple of problems.
>
> 1. MSSQLServerADHelper service does not startup.
>
> System log message is:
> The MSSQLServerADHelper service terminated with service-specific error
> 3221225572.
please have a look at http://tinyurl.com/6qwgg
>
> 2.Despite following the instructions in KB article: 840219 I still 'm not
> able to login to MSDE using OSQL from a command prompt. Error message is:
>
> Cr>osql -U domain\administrator -P xxxx
> Login failed for user 'domain\administrator'. Reason: Not associated with
a
> trusted SQL Server connection.
>
> Is something wrong with my syntax for the value for the -U parameter? I
> restarted the SQL server and the agent services after following the steps
in
> 840219.
for trusted connections, you shoul'd pass the -E parameter (where -E
specifys a trusted connection using you actual WindowsNT login credential)
instead that providing SQL Server authenticated related credentials...
tipically
c:\>osql -E
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Lee Trotter: "Date in SQL insert"
- Previous message: Alan Brewer [MSFT]: "Re: osql command reference?"
- In reply to: public.microsoft.com: "MSDE installation/connection issues"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
