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 accepts
either windows accounts or the new sequel account. so i have basically locked
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 account
> work. things hung for a while and when restarted the sequel no longer accepts
> either windows accounts or the new sequel account. so i have basically locked
> 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.
> -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:
> You 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 account
> > work. things hung for a while and when restarted the sequel no longer accepts
> > either windows accounts or the new sequel account. so i have basically locked
> > 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.
> >
> > -Bahman
> >
> >|||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:
> 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:
> > You 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 account
> > > work. things hung for a while and when restarted the sequel no longer accepts
> > > either windows accounts or the new sequel account. so i have basically locked
> > > 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.
> > >
> > > -Bahman
> > >
> > >|||John,
sorry for delay.
I rebuilt the system. It was gone too far away.
-Bahman
"John B." 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:
> > 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:
> >
> > > You 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 account
> > > > work. things hung for a while and when restarted the sequel no longer accepts
> > > > either windows accounts or the new sequel account. so i have basically locked
> > > > 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.
> > > >
> > > > -Bahman
> > > >
> > > >