Windows Server 2000 domain
Briefly, how would you go about adding a new Windows XP Pro PC & User onto a Windows Server 2000 domain?

Answer Question   |  February 5, 2007  4:29 PM
Active Directory, DataCenter, Desktops, DHCP, DNS, General Directories, Lotus Domino, Management, Microsoft Windows, Networking, Networking services, OS, Security, Servers, SQL Server, WINS

Terminal server licensing problem
Hi, We recently activated TS license server and installed win2003 unlimited CAL on one of our domain controller. Activation and installation was successful. But 1. When I run the TS license manager on the domain controller (license server) itself, I get an error message “No terminal server license server is available in the current domain [...]

Answer Question   |  February 9, 2007  11:39 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Blocking access to local Drive Win XP Server 2003 GPO
I recently found a way to access a local drive that is supposed to be hidden using group policy. I configured the policy to block the c: drive which works great – the drive is not listed in any program or my computer. The issue is this. If I open Notepad, Word, or most any [...]

Answer Question   |  January 30, 2007  4:13 PM
DataCenter, Desktop management applications, Desktops, Development, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server

WSUS Server multiple instances of computers listed.
I am very new to the Windows update server (WSUS). I installed and configured the update server and everything seems to be working. I added some settings in my group policy and applied the GP to an OU and went on my way. The clients started to appear in the list of workstations on the [...]

Answer Question   |  May 27, 2009  11:20 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server, Tech support

SQL 2005 Restore
Hello, Yesterday at 1400 I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can’t take this long. Does anyone know what I can do??? I need to get this database back up, even if it is the version [...]

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

Exchange Server auto-reply setup
We have an exchange server that has been servicing records as follows: user1@alpha.company.com is an alias for user1@bravo.company.com. All mail destined for alpha is forwarded to bravo e-mail address. We now need to only use the @bravo.company.com e-mail and set up an auto reply on the alpha.company.com to let the sender know that the old [...]

Answer Question   |  December 16, 2010  4:24 PM
Desktops, Exchange, Exchange security, Management, Microsoft Windows, OS, Security, Servers, SQL Server

Windows XP Policies..
I have a problem with users copying files from their local workstation to a USB memory stick, floppys and at times burn CDs with company files. Is there any way I can deny access to these peripherals? Currently, the users are not administrators of their local machines and are just users.

Answer Question   |  January 24, 2007  3:59 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server

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

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