Viewing 15 posts - 811 through 825 (of 1,157 total)
You can get that information by reading the Default Trace. Please refer this.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 9, 2010 at 6:36 am
Detailed error logs would be available in the Application/System Event Logs and also in the SetupBootStrap directory.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 9, 2010 at 5:27 am
Are you talking about deleting the backup files or the actual data in the database?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 9, 2010 at 3:46 am
Check
1) if you are running the Setup as an Administrator.
2) if multiple instances on Setup is running
3) clean up left over older installations of SQL Server 2008, if any.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 8, 2010 at 11:44 pm
Please navigate to Maintenance Plans and open the Maintenance Plan. Inside that you will have a BACKUP DATABASE task which takes care of the backups.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 8, 2010 at 10:54 pm
Adding an output file for the job step will give more information on the failure.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 8, 2010 at 12:19 pm
a.ghasemi (8/7/2010)
yes,exactly:-)
Earlier it was confirmed that the requirement was to grant the Application Role the ALTER LOGIN privileges. ALTER LOGIN privilege is an instance level privilege. Hence the answer.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 8, 2010 at 2:50 am
a.ghasemi (8/8/2010)
such a thing doesn't exist.I mean 'Alter Any Login' permission,we have 'Alter any user ' permission that I 've already granted it.
Please click on the hyperlink and read through...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 8, 2010 at 2:16 am
You need to GRANT ALTER ANY LOGIN permissions to that account. Please refer MSDN.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 8, 2010 at 12:24 am
Cross post. Discussion is on here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 7, 2010 at 11:33 am
These posts are good for getting it started.
http://www.mssqltips.com/tip.asp?tip=1731
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71908
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 7, 2010 at 11:32 am
Check if the Method 3 listed in this article is applicable to you.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 7, 2010 at 11:12 am
Sorry. Did not get the question. You want the Application Role to have ALTER LOGIN privileges?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 7, 2010 at 11:00 am
May be you have read this already. I would go with any one of the options given in this article.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 7, 2010 at 10:57 am
I second what Jeffrey mentioned. Please run SSMS/Configuration Manager as Administrator.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 7, 2010 at 10:48 am
Viewing 15 posts - 811 through 825 (of 1,157 total)