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.
ThanksShipra,
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 Serve
r
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 tha
t
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 th
e
> 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
>|||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:
[vbcol=seagreen]
> Shipra,
> From the error it looks like the sql server is up when your applicati
on
> is trying to connect. Since it will not give login failure. if the SQL Ser
ver
> 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 t
hat
> the ID doesn't have access to the default database.
> Neeraj
> "Shipra Gupta" wrote:
>|||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:
[vbcol=seagreen]
> 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:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment