Viewing 15 posts - 16 through 30 (of 1,160 total)
mccarron52 (4/8/2011)
Error result: -2067529698
Result facility code: 1220
Result error code: 30
For more information, review SQL Server 2008 Setup logs in your temp...
April 10, 2011 at 2:14 am
Execute the following query while the Maintenance Plan is running and check if there are any blocks or anything that the process is waiting on.
SELECT * FROM sys.dm_exec_requests
Also since...
April 10, 2011 at 2:10 am
Yes you are right. This article has more information about it.
April 9, 2011 at 11:28 am
Rod, please make sure that you install SP4 on a test box and after proper testing install it on the Production system. Like I mentioned in one of my earlier...
April 9, 2011 at 10:18 am
You may find this article useful.
April 9, 2011 at 9:28 am
It does not matter whether you installing the service pack by RDC or directly at the server. As always, make sure you have the latest FULL backup of system and...
April 9, 2011 at 9:26 am
You may find this article useful.
April 8, 2011 at 4:59 am
You are right Ivan. When using Windows Authentication, the login credentials are checked in the Active Directory. No information is saved locally in SQL Server.
April 4, 2011 at 2:22 am
You can query sys.server_principals to get login related information.
April 3, 2011 at 10:48 am
A SQL Server Login has to be explicitly granted access or through group membership. Hence the Agent service account has to be part of a group, since you don't find...
March 31, 2011 at 2:04 pm
If the service account is part of the group that you had mentioned, then it would have sysadmin rights on the instance. Do you see a login for myorg\sqlsvc in...
March 31, 2011 at 1:47 pm
In the Services console, look for the services which start with "SQL Server". In the Service Name the name inside the ( ) is the instance name. In the below...
March 30, 2011 at 1:26 pm
Please make sure that you are using the correct instance name to connect to SQL Server.
Open Run --> Services.msc
Check the SQL Server service, it should read something like SQLServer(InstanceName).
Make a...
March 29, 2011 at 9:54 am
How are you connecting to the database? Using SSMS? What is the error message that you get when you try connecting?
March 29, 2011 at 9:29 am
Does executing the below query help?
sp_configure 'xp_cmdshell',1
reconfigure with override
March 29, 2011 at 6:51 am
Viewing 15 posts - 16 through 30 (of 1,160 total)