Viewing 15 posts - 2,311 through 2,325 (of 2,386 total)
I guess your SQL Server Agent Service is started by local system account. Try to either change it to a domain a/c or run sp_grantlogin 'NT Authority\System' and grant it...
October 30, 2002 at 9:56 am
To remotely administer cluster SQL server from terminal server, install NT/2000 cluster administrator tools in it. You can find it from NT/2000 resources kit.
October 30, 2002 at 7:30 am
Install SQL Server 2000 client tools (including SQLDMO components) does not overwrite the SQL Server 7.0 files if default installation is choosed. Both of them have different installation directory.
You...
October 29, 2002 at 1:50 pm
Use SELECT @@LOCK_TIMEOUT to return the timeout setting and SET LOCK_TIMEOUT to set new lock timeout setting.
October 29, 2002 at 8:23 am
Can you see the master database physical files from the second node with Windows Explorer?
October 29, 2002 at 8:05 am
Our database is 350GB and I backup it into disks with four backup files and then backup those four backup file to another location with third party's backup software.
October 29, 2002 at 7:41 am
Can you go to the EM to verify your SQL Server authentication mode?
October 28, 2002 at 11:52 am
It looks there are some kind of jobs running at same time period DTS job was running. Try to move them either early ot later to see whether problem is...
October 25, 2002 at 1:02 pm
You can't change the service account for Search Service. It must be run by local system account. That is why I asked you whether BUILTIN\Administrators is in your SQL Server...
October 25, 2002 at 12:39 pm
Run sp_grantlogin 'NT Authority\System' and sp_addsrvrolemember @loginame = [NT Authority\System], @rolename = 'sysadmin' and you should be ok.
October 25, 2002 at 11:42 am
What service account do you use to start SQL Server? Is login Builtin\Administrators in your SQL Server logins?
October 25, 2002 at 9:29 am
Viewing 15 posts - 2,311 through 2,325 (of 2,386 total)