NYSystemsAnalyst

less info
949 reputation
59
bio website
location
age
visits member for 4 years, 11 months
seen Dec 12 '13 at 19:35

May
16
comment Failed Account Logon Events
The LMCompatibilityLevel is set to 2.
Jan
5
comment Search Active Directory by Comparing Two Attributes
Excellent ... thank you!
Jan
5
comment Search Active Directory by Comparing Two Attributes
Powershell - yes. I'm not sure about the AD web service. I need to talk to the admin. Even with powershell, what would the query look like?
Jun
1
comment Windows Server 2008 Denial of Service Detection
This file server is internal only, it's not directly exposed to the internet, but it is accessed by a web server. We did not turn anything on in Windows to make this start happening.
Dec
21
comment Maintenance window and recovery for a large database
I tried to convince them that being offline for a day or so would be required, but was told that was unacceptable. If there is no alternative, then that is that and that is what I will present to the team. Unfortunately (or maybe fortunately), this is not my project. I'm just an adviser and as such have little authority in the ultimate decision. I just want to present options and facts. Thank you for your input.
Dec
21
comment Maintenance window and recovery for a large database
Well, this project isn't my project. The team just came to me for advice, and according to them, having the database offline for even one day to do a full restore is unacceptable. I'm not inclined to pursue this further with management as it is not my project, but I would like to present them with as much information and as many facts as possible to allow them to make a decision.
Dec
21
comment Maintenance window and recovery for a large database
Not planning for a restore really isn't an option. Replication would be nice, but we lack the hardware and the budget to purchase additional hardware. In addition, the backup solution implemented by our network / systems group is to backup the databases to .bak files, then backup those .bak files to tape. I have no control over this process. Therefore, we need to find a solution involving backups / restores. I'm sorry, but a catastrophic database failure is any failure of the database that is not recoverable. This may or may not be a catastrophe depending on the value of the data.
Nov
15
comment Active Directory Self Service
This looks interesting, though I don't see any pricing info on their website. I'll be passing it on to my manager.
Nov
15
comment Active Directory Self Service
Thank you for the suggestion, but the pricing (~$1500 / year) is more than we can afford at this time.
Nov
15
comment Active Directory Self Service
Of the remaining three, the certificate one is unresolved. The IIS one required a re-build of the server (not a solution). The printer issue resulted in purchasing a new printer (again, not a solution). Now, unless you have something constructive to add regarding THIS question, please do not add anymore useless comments.
Nov
15
comment Active Directory Self Service
For one of those questions...yes, I failed to accept an answer and I have remedied the situation for that instance. For the others, there was no acceptable answer. Just because there are proposed answers does not mean one of them is an actual workable solution. Therefore, no answer was accepted nor will one be accepted unless someone proposes a proper solution.
Aug
23
comment SQL service log on account
You can leave the SQL Browser as Local Service. Change the SQL Server account and the SQL Agent account to be an actual domain account.
Aug
11
comment SQL service log on account
@Jeff: It does not need to be a new account. However, it is a best practice that the SQL Server service use it's own account.
Jul
19
comment Installing IIS on Windows 2003
Also, after installing IIS, that file is not present in the system32 directory.
Jul
19
comment Installing IIS on Windows 2003
I ended up re-installing windows and it worked after that. I just checked my CD, and it only has smtpsnap.dl_ (no .hl_ file). It should be noted that I also tried using several different Windows 2003 CDs, including the original CD and one with SP2 slipstreamed into it. Neither worked.
Jul
13
comment Installing IIS on Windows 2003
Installing the Admin pack did not work.
Mar
31
comment [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
This could be a network issue. You may need to run a trace using something like Wireshark on the webserver to capture the packets. Then, when you experience one of these errors, look at the packets for that time and see if there is anything strange. (e.g. Outgoing packets without incoming packets, Packets being sent to the wrong host, etc.)
Mar
9
comment MS SQL Server slows down over time?
Growth by percentage usually isn't a good thing either. When you database becomes large, a 5% growth will be much larger than when the database first started off. 1MB is too small, but you should decide on a fixed MB growth rate based on the size and usage of your database.
Mar
9
comment MS SQL Server slows down over time?
If you run the same queries through Management Studio, do you see the same performance problems as if they are ran through the application? What makes the performance degradation stop or go away? Do you reboot the server? Is this a physical server or a VM? Does it have its own storage or is it part of a SAN?
Mar
5
comment Will Windows 2008 or Windows 7 interfere with a network of Windows 2003 servers
How would legacy applications affect this, and how does WINS and NETBIOS relate to this? Forgive me ... I have a solid, basic understanding of networking, but I'm not a network admin. I have pressed for specifics, but received little. I'll keep at it. Any idea where this fear that newer versions of Windows are going to take over the network might emanate from?