Hi,
We have just installed sql server 8
while using the enterprise manager, as we clicked on the
server icon the following error was issued:
"An error 1069 (the service did not start due to a logon
failure) ocurred while performing this service operation
on then MSSQL Server Service." In a related dialog we
found out that its default login procedure is by means of
the windows login. Another option was to
provide 'independent' login/password. In older versions I
was always able to login using sa as login with empty
password...
Which one should we use? what is missing?
tia
paco
tia,
FranciscoYour problem is not the login from EM to SQL Server. The problem is that SQL Server didn't event
start. Check out the Service Account for the SQL Server service, and the password specified for
this.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Francisco" <anonymous@.discussions.microsoft.com> wrote in message
news:09dd01c3aec7$002f4a50$a001280a@.phx.gbl...
> Hi,
> We have just installed sql server 8
> while using the enterprise manager, as we clicked on the
> server icon the following error was issued:
> "An error 1069 (the service did not start due to a logon
> failure) ocurred while performing this service operation
> on then MSSQL Server Service." In a related dialog we
> found out that its default login procedure is by means of
> the windows login. Another option was to
> provide 'independent' login/password. In older versions I
> was always able to login using sa as login with empty
> password...
> Which one should we use? what is missing?
> tia
> paco
>
> tia,
> Francisco
>
No comments:
Post a Comment