SQL Repair

SQL Repart would Not Run

Error Message

Server: Msg 7919, Level 16, State 2, Line 1

Repair statement not processed. Database needs to be in single user mode.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Symptoms

I was get no errors on the database. I was trying to run some prventative mantainance.

Fix

You can convert the database to a single user mode by:

1. Opening Enterprise Manager

2. Right Click on the Database and go to property

3. Go to the options tab.

4. Select Restrict access and select single user.

Also see the Microsoft technical document Q264154 for more information.

 

NetMail Server Not Getting Email

Error Message

None

Symptoms

The Netmail Server could send email to Yahoo but I was not Receiving email. Several tests where run. Closing down the firewall had no impact. Following on tests, I noticed the firewall stated that the SMTP traffice was routed to a internal server.

Fix

Internet connection share had bee configured to route mail traffic to an internal server. (See Windows 2000 Server on line help, Internet Connection Sharing for Applications and Services.) I took the following steps:

1. Right clicked on the Network Neighborhood and select properties.

2. Select Sharing tab.

3. On the Sharing tab, I selected the Settings tab.

4. On the settings page, I selected the services tab and deselected all.

I ran a test and the email server was able to receive email.

 

 

 

Netmail not Receiving Email

Access CMOS on Toshiba Laptop

Tecra Laptop Setup

Error Message

No Error Message. I could not get into CMOS. System did not indicate a key to press to get into cmos

Symptoms

System was booting normal.

Fix

I went on Toshiba's Website and navigated to support area. I did a search on CMOS setup and found this document. Only part of it is here:

Accessing the hardware settings on a Toshiba computer Document Number 98050233

 

Use of any software made available for download from this system constitutes your acceptance of the Export Control Terms and the terms in the Toshiba end-user license agreement both of which you can view before downloading any such software.

Document number:

1. Hold down the <ESC> key as the computer starts up. The computer should beep and display a message "Check system. Press <F1>"

2. Press the <F1> key and the System Setup information is displayed.

3. Changing the settings: There are instructions about how to change these setting at the bottom of the screen.

 

 

Activation Error Server 2008

Error Message

I got an activation error on Windows Server 2008.  The details are as follows:

Log Name: Application
Source: Software Licensing Service
Event ID: 8198
Level: Error Description: License Activation (SLUI.exe) failed with the following error code: 0x80004005

It should be noted that I was never asked for a product key during install.

Research

I found a Microsoft document that recommend phone activation. I called and the Microsoft activation staff referred me to the technical helpdesk. This would have cost. I decided to continue my research and found that if you change your product key you can active Windows.

Hypothesis

Changing the product key would allow me to activate Windows.

Procedures

To change your Vista product key (source):

1. Click on the Start Button and type Command Prompt in the search field.
2. From the list that appears, right click the Command Prompt shortcut and select Run As Administrator.
3. At the administrator command prompt, type in "slmgr.vbs -ipk [insert your product key here]"
4. To activate windows after changing the key, run "slmgr.vbs -ato"

To run the Windows Activation Wizard use these comands:

slui or slui 0x01 Display Windows Activation status
slui 0x02 Prompt for Windows Activation wizard via Internet
slui 0x03 Run Change Product Key wizard
slui 0x04 Launch Windows Activation wizard via Telephone.
slui 0x05 Prompt Windows Activation and show activation way except Internet.
slui 0x06 Launch Windows Activation wizard
slui 0x07 Prompt Windows Activation as Windows running on last day to activate.
slui 0x09 Launch Windows Activation wizard after license expiration.
slui 0x016 Display activation status with license expiration warning
"Your Windows will expire in 234 days and Windows will stop working"
slui 0x018 "Your Windows will expire in 5626 hours and Windows will stop working"

Source: Tom's Tricks.

Results

These steps allowed me to activate my copy of Windows 2008 server. I am not sure why I got the error. I think the error is related to the software being from the Microsoft Developers Network Academic Alliance.

Network Drives Showing Disconnected

 

My network drives where showing up as "Disconnected Network Drive", but the drive were working. I was running Windows 2008 Server with an XP client. I was mapping the drive using a startup script in Domain group policy object.

I found a discussion thread on Tech Republic that helped me fix the problem. Click here.

I moved the login script to a user container and the drives connected just fine.

You need to run the gpudate /force command get the change to start correctly.

The problem with this fix is that I will have more than one login script.

Error Connecting to PeopleSoft

My college uses PeopleSoft for managing student records. I was unable to connect to the server from home. I had time out error.

My first hypothesis was that my firewall was blocking access. I was able to open the correct port (I am not mentioning it here for Security reasons) and I was able to connect.

I have had issues with open ports in the past so this an easy fix. The learning from this is to always consider port issues with Internet applications.