Viewing 15 posts - 3,196 through 3,210 (of 6,105 total)
I've not seen any issues myself. Have you encountered any?
February 25, 2005 at 2:06 pm
Passwords are encrypted for SQL Server logins (you can see this in sysxlogins). If you are doing application-based logins where you are storing username/passwords in a database table, no, SQL...
February 25, 2005 at 9:06 am
replication or log shipping... either one would do here.
February 24, 2005 at 12:40 pm
It was probably because of FTI. The cluster service and SQL Server themselves do not come in through the local System account. One option here may be to set FTI's...
February 24, 2005 at 7:59 am
sc.exe has been around since NT 4 in the Resource Kits. I think it's now included in XP and 2003. It'll allow you to handle services both locally and remotely....
February 24, 2005 at 7:56 am
Yes. And if you want to go down this road, there is also a minimum operating system requirement of Windows 2000 Advanced Server or Windows 2003 Server Enterprise Edition. So...
February 24, 2005 at 7:45 am
NT Authority\System should only be needed if you're running SQL Server or SQL Server Agent under the local System account or using something like Full-Text Indexing (which should be configured...
February 24, 2005 at 7:43 am
Ensure you explicitly add the account that SQL Server is running under and give it SA privileges. Do the same for SQL Server Agent. BTW, this also should be...
February 24, 2005 at 7:41 am
Correct. Slammer used udp/1434. If there whole basis for blocking tcp/1433 is Slammer then they need to go back and learn about how Slammer works. If they didn't block udp/1434...
February 23, 2005 at 2:42 pm
We have cited the use of the rebuildm.exe utility. This has worked in our DR testing though usually there we are not restoring clusters to clustered equipment but rather normal...
February 23, 2005 at 12:59 pm
Yes, you would use cluster.exe to issue a command to either take the resource group offline or take the individual SQL Server resource off-line. This would also take SQL Agent...
February 23, 2005 at 8:18 am
Um, they are wrong.
SQL Slammer went after the SQL Server listener service which is on udp/1434. This has nothing to do with tcp/1433. Granted, there were a couple of worms...
February 23, 2005 at 8:14 am
ADSI is a system component in Windows 2000. It's not installed by default under NT 4.0 (as would be expected since NT 4.0 preceded AD). If you're on NT 4.0...
February 7, 2005 at 12:50 pm
Given this situation, use a password generator to create a complex password for your sa account and use it. You're going to want a strong password. Because as of right...
February 7, 2005 at 11:42 am
There's a lot of good advice to your post. However, to tailor a recommendation for your situation, we need to know a bit more. Recapping some of the questions (and...
February 2, 2005 at 7:05 am
Viewing 15 posts - 3,196 through 3,210 (of 6,105 total)