Viewing 15 posts - 4,456 through 4,470 (of 6,105 total)
Even with SQL Server 7.0 you could have instances where you couldn't view CALs via SQL Server. For instance, if an organization purchased 100 Back Office CALs... Typically, if you...
March 24, 2003 at 11:37 am
On this point I'll respectfully disagree. Here's why:
If you're encrypting the data stream, either through SSL or IPSec, then a packet sniffer isn't going to be able to interrogate the...
March 24, 2003 at 7:02 am
No. Data recovery model does not refer to security, but rather how much data you can get back should a failure occur. This may help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4l83.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish...
March 24, 2003 at 12:37 am
Windows 2000 DNS supports the use of WINS RR records to resolve queries against an existing WINS server if the DNS server isn't able to resolve the name.
While WINS is...
March 21, 2003 at 9:47 am
Oops, you're right. I just ran a job every second to try and capture sysprocesses and never grabbed the failure even though it temporarily has a SPID but it doesn't...
March 21, 2003 at 9:01 am
A few things:
(1) There is no pure SQL Server solution. SQL Server captures the MAC address but not IP address. This is a problem they'll hopefully fix in Yukon.
(2) You'll...
March 21, 2003 at 7:45 am
SQL Slammer works by exploiting a buffer overflow vulnerability in the SQL Server 2000 listener service. Basically this is what happens:
(1) Specially crafted UDP packet hits port 1434.
(2) Unpatched SQL...
March 20, 2003 at 9:26 am
Yes, creating a SQL Server user with the exact same rights would work.
As for mapping as sa, I dunno if that's such a good idea. If you have a DBA...
March 18, 2003 at 4:08 pm
OK, that eliminates the port as a possibility. Does the modem manufacturer say there's any conflict with any services such as SQL Server?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to...
March 18, 2003 at 1:42 pm
Unfortunately, with the double-hopping ruled out by design, no. One of the two connections is going to have to be SQL Server login-based.
Going away from linked server, an idea might...
March 18, 2003 at 12:32 pm
Server Network Utility. You'll see it in the same folder as SQL Server under Start | Programs. It'll require you to stop and restart SQL Server. I'm wondering if there...
March 18, 2003 at 8:13 am
What happens when you change the port your SQL Server is listening to to some large number like 7777 or 8888 or 9999? Does it still lockup your internet connection?
K....
March 18, 2003 at 7:37 am
As always, Chris, an excellent article. I'll be shooting this article to certain members in my organization. I also like how you've pointed out a need to understand branching, labeling,...
March 15, 2003 at 4:07 pm
Realize for redundancy sake you're going to have to have an app server farm to point to your COM+ server farm, unless I'm mistaken. It's been a LONG time since...
March 14, 2003 at 9:05 am
The cluster service account needs to be a domain account (not domain admin). A slight, but important security distinction.
As far as access to SQL Server, the cluster account must have...
March 14, 2003 at 7:12 am
Viewing 15 posts - 4,456 through 4,470 (of 6,105 total)