MSSQLServer dependent service startup

Yes, that's true. But the login ID being used has all the required
permissions, I think it is a timing issue because later when I start the
services, they all start without a problem.

Thanks

"Neeraj" wrote:

 > Shipra,
 > From the error it looks like the sql server is up when your application
 > is trying to connect. Since it will not give login failure. if the SQL Server
 > is not up it will give a error "could not connect or something". Is your
 > application by default using any id to connect to the database. It seems that
 > the ID doesn't have access to the default database.
 >
 > Neeraj
 >
 > "Shipra Gupta" wrote:
 >
  > > Hello,
  > >
  > > I have some services that are dependent on MSSQLServer serivce but when the
  > > computer is restarted, my services don't start and I get an error message
  > > "Cannot open database requrent in login 'database name'. Login fails'.
  > >
  > > It seems like to me that these services come up before SQL Server even
  > > though I have the dependencies set right.
  > >
  > > Any help is appreciated.
  > > Thanks
  > >
 >> Stay informed about: MSSQLServer dependent service startup 

Its possible that database SQL Server is up but default database is going
through the recovery. Adding a bit of delay might help. In Sybase we can
chage the order in which the databases get recovered, i don't know if we can
do the same in sql server or not. If yes then you can set it such that the
database gets recovered before any other database.

Neeraj



"Shipra Gupta" wrote:

 > Yes, that's true. But the login ID being used has all the required
 > permissions, I think it is a timing issue because later when I start the
 > services, they all start without a problem.
 >
 > Thanks
 >
 > "Neeraj" wrote:
 >
  > > Shipra,
  > > From the error it looks like the sql server is up when your application
  > > is trying to connect. Since it will not give login failure. if the SQL Server
  > > is not up it will give a error "could not connect or something". Is your
  > > application by default using any id to connect to the database. It seems that
  > > the ID doesn't have access to the default database.
  > >
  > > Neeraj
  > >
  > > "Shipra Gupta" wrote:
  > >
   > > > Hello,
   > > >
   > > > I have some services that are dependent on MSSQLServer serivce but when the
   > > > computer is restarted, my services don't start and I get an error message
   > > > "Cannot open database requrent in login 'database name'. Login fails'.
   > > >
   > > > It seems like to me that these services come up before SQL Server even
   > > > though I have the dependencies set right.
   > > >
   > > > Any help is appreciated.
   > > > Thanks
   > > >
 >> Stay informed about: MSSQLServer dependent service startup