How to add additional IP addresses in Windows 2003 Server

1. Right Click My Network Places and click Properties. You can find My Network Places by opening an explorer window.
2. Right Click the Local Area Connection and click Properties.
3. in the Local Area Connection Properties window Select Internet Protocol (TCP/IP) and Click properties.
4. Click the Advanced button on the General tab of the Internet Protocol (TCP/IP) properties window.
5. Click the Add button in the IP Addresses section of the IP Settings tab of the Advanced TCP/IP Settings.
6. Enter appropriate IP addresses and subnet mask. I have to use 255.255.255.0. Click Add. Repeat for each ip address.
7. Click Ok until you're out of all the windows.

How to Configure SQL Server 2005 to Accept Remote Connections

1. Enable TCP/IP
- open SQL Server Configuration Manager
- expand SQL Server 2005 Network Configuration
- click Protocols for SQLEXPRESS
- right click TCP/IP and click Enable

2. Disable SQL Browser Service
- this service allows remote users to connect without specifying the port in the connection string.
- security risk
- open SQL Server Configuration Manager
- expand SQL Server 2005 Network Configuration
- click Protocols for SQLEXPRESS
- right click TCP/IP and click Properties
- click IP Addresses tab
- under IPAll, clear out TCP Dynamic Ports
- specify port number in TCP Port. make sure to open this port in Windows Firewall.

I got another wierd error today when I tried to upload a new module on one of my Dotnetnuke sites:

ExceptionSystem.ArgumentException: Invalid File or Directory attributes value. at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateModuleFile(PaFile File, PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

Turns out that the system account (Network Service) did not have full permissions on the root folder of the installation. As soon as I set it correctly, this error disappeared.

Recently, when I tried to upload a new module to DotNetNuke, I received the following error:

ExceptionSystem.ObjectDisposedException: Cannot access a closed file. at System.IO.__Error.FileNotOpen() at System.IO.FileStream.Seek(Int64 offset, SeekOrigin origin) at System.Web.HttpRawUploadedContent.TempFile.GetBytes(Int32 offset, Int32 length, Byte[] buffer, Int32 bufferOffset) at System.Web.HttpRawUploadedContent.CopyBytes(Int32 offset, Byte[] buffer, Int32 bufferOffset, Int32 length) at System.Web.HttpInputStream.Read(Byte[] buffer, Int32 offset, Int32 count) at ICSharpCode.SharpZipLib.Zip.ZipInputStream.FillBuf(Int32 size) at ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNextEntry() at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.ReadZipStream() at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

To fix it, open the Web.config file and locate the line:

<httpRuntime useFullyQualifiedRedirectUrl="true" ...

I've had to change the port that SQL Server uses to communicate over the Internet several times now, and I'm getting tired of looking it up. Here is is for future reference:

1. Open SQL Server Enterprise Manager.
2. Right-click on the server instance.
3. ClickProperties.
4. Click the General tab, then click the button marked "Network Configuration" to display the SQL Server Network Utility.
5. Find TCP/IP under Enabled Protocols on the right. Highlight it and hit the Properties button.
6. The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server. Change this entry to make SQL Server listen on a different port. Click OK to close the dialog.
7. Click Apply on the SQL Server Network Utility screen, then OK.
8. The changes are saved, but they will not take effect until you stop and restart the SQL Server service. ClickOK.
9. ClickOK ...

I am a jack of all trades, so I don't spend too much time on any one task. I just looked at directory where my sql server 2000 databases live and I noticed that my DB logs are huge. One log file was over a gig and a half in size for a 500 meg database. I'm putting it here for my future reference, but I hope someone else can use it, too.

BACKUP LOG <dbName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<dbName>_Log, 2)

The Unspecified Error I wrote about not long ago came back on my server. I thought that reinstalling ASP.Net would fix it once and for all but I was wrong. I installed a new antivirus product called NOD32 and ran a full scan. It found a few little cyber-squatters sitting on my machine and disabled them. They were:

Win32/HacDef trojan
Win32/VB.NEI worm
HTML/Amazofraud.N trojan

Hopefully, they were the problem. I just finished reinstalling ASP.Net again, so we'll see how it goes this time around.

I HATE it when I have tried and tested code working that just mysteriously stops working. This particular time the problem lies around OLEDB access to Excel. I was doing a simple Select * from [Sheet1$] when all the sudden I started getting this ugly, useless error:

System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) &l ...