connectivity problem

good morning!
All was fine until a few hours ago. the sequel was set to windows
authentication only. then i realized i needed a sequel user account which i
then created. then i tried to switch back to mixed mode to make the account
work. things hung for a while and when restarted the sequel no longer accept
s
either windows accounts or the new sequel account. so i have basically locke
d
myself out. do i need to reinstall? is there an easy way to reset the
authentication mode without being able to get into the engine itself? thanks
.
-BahmanYou should be able to switch between the authentication modes. Did you get
any error message when tryin to log in?
Linchi
"Bahman" wrote:

> good morning!
> All was fine until a few hours ago. the sequel was set to windows
> authentication only. then i realized i needed a sequel user account which
i
> then created. then i tried to switch back to mixed mode to make the accoun
t
> work. things hung for a while and when restarted the sequel no longer acce
pts
> either windows accounts or the new sequel account. so i have basically loc
ked
> myself out. do i need to reinstall? is there an easy way to reset the
> authentication mode without being able to get into the engine itself? than
ks.
> -Bahman
>|||yes i did.
it said that it could not connect to sequel. it said one reason could be
that by default sequel 2005 does not allow remote connections.
so i went into surface area and added that functionlity. but surface area
does not allow me to check on authentication mode and switch it. the only
place i could do that was on the engine itself, which i cannot get to at the
moment.
the other issue is that the agent does not start at all. if i try to start
the service is says the service did not start and did not return an error
code. so, i don't know what it is i need to fix.
-Bahman
"Linchi Shea" wrote:
[vbcol=seagreen]
> You should be able to switch between the authentication modes. Did you get
> any error message when tryin to log in?
> Linchi
> "Bahman" wrote:
>|||Bahman,
Are the buttons greyed out for switching modes. I need to switch from
windows to mixed in 2005 but both buttons are greyed out. Any ideas on how
I
can switch to mixed?
Thanks
John
"Bahman" wrote:
[vbcol=seagreen]
> yes i did.
> it said that it could not connect to sequel. it said one reason could be
> that by default sequel 2005 does not allow remote connections.
> so i went into surface area and added that functionlity. but surface area
> does not allow me to check on authentication mode and switch it. the only
> place i could do that was on the engine itself, which i cannot get to at t
he
> moment.
> the other issue is that the agent does not start at all. if i try to start
> the service is says the service did not start and did not return an error
> code. so, i don't know what it is i need to fix.
> -Bahman
> "Linchi Shea" wrote:
>|||John,
sorry for delay.
I rebuilt the system. It was gone too far away.
-Bahman
"John B." wrote:
[vbcol=seagreen]
> Bahman,
> Are the buttons greyed out for switching modes. I need to switch from
> windows to mixed in 2005 but both buttons are greyed out. Any ideas on ho
w I
> can switch to mixed?
> Thanks
> John
> "Bahman" wrote:
>