Windows 2003 Server Crashing
I have a Windows Server running Exchange 2003. Over the weekend the server must have crashed. I was able to reinstall Windows 2k3. But when I installed SP 1 and the patches, the server crashed again. I reinstalled Windows over C: and installed SP1 for Windows. On restart the server crashed again. No hardware has [...]

Answer Question   |  February 2, 2007  4:49 PM
Desktops, Exchange, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Blocking the use of web proxies.
Currently we are using a filter by 8e6 technologies called the R3000. The device works great accept for the fact that users can go to a web proxy and get to blocked web sites bypassing our filter. Is there a way to block the proxy traffic as well? Or do I have to manually block [...]

Answer Question   |  November 22, 2010  11:13 AM
DataCenter, Desktops, Management, Microsoft Windows, Network protocols, Networking, OS, Performance management, Security, Servers, SQL Server, Tech support

Weird Exchange Issue still hanging around
Not sure if anyone here has experienced this or is still having this issue but I am having a heck of a time getting this resolved. Here is the issue: We have Exchange 2003 sp2 on Windows 2k SP4 and we can not send e-mails to certain domains. I have tried setting these domains as [...]

Answer Question   |  January 24, 2007  1:05 PM
Desktops, Exchange, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Windows Server 2003 Web Edition Configuration
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from [...]

Answer Question   |  January 22, 2007  10:44 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management

Managing SQL 2000 server over the internet
I have an SQL 2000 server behind a firewall. I have set the ports to be forward to this server. I would like to manage this server from home using enterprise manager. How can I accomplish this.

Answer Question   |  January 19, 2007  12:20 PM
Access, DataCenter, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server

Proccess keep running. Cant find a solution
Hi, I have SQL Server 2000 SP4 running on a server with 2GB RAM , 18GB free in the DB disk and 2.3 GB free in the OS disk. It was running normally til 2 days ago. Now I have processes (dtss and jobs) running for 2 days. I tried to stop sqlServerAgent, but it [...]

Answer Question   |  January 19, 2007  8:26 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server

Exchange/OWA Password Change error
We are getting IIS error 5 when users are trying to change their password through OWA. I’ve deleted and recreated the virtual PWD directory in IIS with sucess once but the problem has reappeared and it doesn’t help this time. Running 2k3 server sp1 and 2k3 Exchange sp2 Mcafee Groupsheid for Exchange. All patches up [...]

Answer Question   |  January 15, 2007  1:40 PM
Desktops, Exchange, Exchange security, Management, Microsoft Windows, OS, Security, Servers, Software, SQL Server

Wireless connection unable to browse Internet
I run a Windows 2003 Server LAN, with Windows XP clients. All machines are members of the LAN and Group Policy is in place. The LAN uses DHCP with DNS servers and gateway specified. Notebooks that are part of the domain, when connected to the network (wired or wireless)have no problems accessing and browsing the [...]

Answer Question   |  January 12, 2007  11:09 AM
Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Wireless

Remote Authentication to AD Server
Our main site uses Active Directory, but our small remote sites do not; users up to this point had no need to log on to the domain. Now, we have a remote user that needs to log on to the domain. How do I point him there? What will I need at the AD end? [...]

Answer Question   |  January 9, 2007  10:17 AM
Active Directory, DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Worth investing in server
I am trying to decide if it is worth our expense to invest in a server for our small company. We currently have six network points – 4 desktop PCs networked on our LAN as well as 2 laptops that occasionally connect and are planning on buying another PC to add for another person that [...]

Answer Question   |  January 9, 2007  1:26 PM
Servers

Count distinct rows on multiple columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C [...]

Answer Question   |  April 19, 2013  8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows

Viewing SQL2005 Stored Procedure Code(DataReader)
We have a developer team that has been accustomed to viewing stored porcedure code through Enterprise Manager in SQL2000. We noticed that when having the same DataReader rights in SQL Management Studid(SQL2005) they cannot view the stored procedure code. Is this a bug in SQL2005 or is there another way/method(without maintenance nightmares) to allow them [...]

Answer Question   |  January 8, 2007  4:47 PM
Desktops, Management, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server

Wake-On-LAN / Cisco Mac address-tables
Recently I scheduled my computers to power on using Wake-On-LAN. There seems to be an issue with some of the computers not turning on. All the computers have identical hardware and have the same BIOS settings. I did some investigation and I noticed that the computers that were not turning on did not have their [...]

Answer Question   |  January 17, 2007  12:16 PM
Cabling, Cisco, Desktops, Hardware, Hubs, Management, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches

Max Row Size Error in SQL 2000 Update Error
Dear All, I have two tables T1 & T2.T1 is having 14501452 and T2 is having 15012458.I am running following queries and getting max row size error. “update t2 set t2.present=’Y’ from t1 where t2.no=t1.no” Please help

Answer Question   |  January 8, 2007  9:42 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

datamining SQL with access
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that [...]

Answer Question   |  July 4, 2008  4:29 PM
Access, Data analysis, Data mining/analysis, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Exchange 2003 not able to change send and receive file size limits
I have a user that needed to send a 50 Mb PDF file. His send and receive file size limits were 10Mb. So I changed them to 60 Mb but Exchange would not retain the new changes. It allowed me to make the change but is not retaining the changed settings and the user could [...]

Answer Question   |  January 4, 2007  9:18 PM
Desktops, Exchange, Exchange security, Hardware, Interoperability, Management, Microsoft Windows, OS, Security, Servers, Software, Spam, SQL Server, Tech support

Roaming Profles and Default Printers WinXP Server 2003
Does anyone know how default printers are handles when using Roaming Profiles with Windows XP and Server 2003? I am deploying printers per machine with GP; so all the computers do not have the same printers, but my clients are complaining that they always have to set the default printer. I thought this may be [...]

Answer Question   |  January 4, 2007  11:36 AM
DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support

Changing File Ownership to allow Disk Quota’s to work – Windows 2000
Hello, I have a windwos 2000 domain, recently I have been trying to configure disk quotas. Problem is Disk Quotas work on file ownership and alot of the data on the server was copied over from another server when we merged with another office. Therefore a large amount of user data is owned by the [...]

Answer Question   |  December 28, 2006  7:08 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support

Critical Error in Security Log
All, I mamange a Windows 2003 Small Business Server Network with 9 clients. The server provides all network services. We use Logon/logoff, shared storage, and print server functions. We do not use exchange except for the server reporting tool. We do use about 4 instances of SQL. All clients are Windows XP Professional patched to [...]

Answer Question   |  December 28, 2006  7:08 AM
Biometrics, configuration, DataCenter, Desktops, Digital certificates, Identity & Access Management, Management, Microsoft Systems Management Server, Microsoft Windows, OS, Patch management, patching, PEN testing, Platform Security, provisioning, Security, Security tokens, Servers, Single sign-on, Software, SQL Server, Tech support, vulnerability management

password recovery of win 2003 server…..
Hi, I disjointed my server from the domain and I forgot the local administrator password of this server!!!!now I don’t have the access to the server!!! I downloaded some free password recovery tools from internet but they are demo version!!! Could you please help me!!??? Thank you. —– Regards Mahnaz

Answer Question   |  May 24, 2010  3:28 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support