mhaeri
یک شنبه 22 دی 1387, 09:18 صبح
با سلام
من وقتي روي user sa مي خوام properties بگيرم با اين error مواجه مي شم:
Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
با Alter Login هم نمي شد تغييري داد
ورژن اس كيو ال:
Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
ممنون از همه.
من راهي كه تو يكي از فروم ها گفته بود رو رفتم:
1) Executed this in a query windows: ALTER LOGIN sa WITH PASSWORD =
'DamnYouStupidError' UNLOCK
2) Verified all databases had a valid account as an owner (all have sa
as an owner)
3) Verfied the sa account did not have rights to an old or nonexistent
database.
4) Verifed SP2 is installed, which it is
ولي نشد و راه ديگري هم كه توصيه شده بود اين بود:
The only "solution" that I've found is to backup all of your
databases, uninstall SQL and reinstall it. Then restore the databases
and finally as a preventative measure, switch ownership of each
database to the dbo account. I'm still of the believe that there is a
different way to remedy this situation, but I haven't found anything
yet.
كه اين راه رو فعلا نمي خوام تجربه كنم
من وقتي روي user sa مي خوام properties بگيرم با اين error مواجه مي شم:
Property IsLocked is not available for Login '[sa]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
با Alter Login هم نمي شد تغييري داد
ورژن اس كيو ال:
Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
ممنون از همه.
من راهي كه تو يكي از فروم ها گفته بود رو رفتم:
1) Executed this in a query windows: ALTER LOGIN sa WITH PASSWORD =
'DamnYouStupidError' UNLOCK
2) Verified all databases had a valid account as an owner (all have sa
as an owner)
3) Verfied the sa account did not have rights to an old or nonexistent
database.
4) Verifed SP2 is installed, which it is
ولي نشد و راه ديگري هم كه توصيه شده بود اين بود:
The only "solution" that I've found is to backup all of your
databases, uninstall SQL and reinstall it. Then restore the databases
and finally as a preventative measure, switch ownership of each
database to the dbo account. I'm still of the believe that there is a
different way to remedy this situation, but I haven't found anything
yet.
كه اين راه رو فعلا نمي خوام تجربه كنم