No Google Docs on Frontrunner Graphic

SQL Book

I like this book. It teaches SQL with MS SQL, MySQL, and Access.

Can’t connect remotely to SQL 2005

Error Message and Symptoms

I could not get to a SQL server. I was getting this error when I tried to connect. See the picture in the next post.

Gathering Information

I Googled the error message and I found that you need to configure your firewall if you have configured for remote connections. Server 2008 default install has a firewall.

Hypothesis

If I open the correct ports, I should be able to connect.

Procedures (This is for Server 2008)


I did the following:

1. Click on Start.
2. Right click and select properties on Network
3. In the network sharing center select the firewall (lower left hand corner).
4. In the Windows firewall window select change settings.
5. Click on the exceptions tab.
6. Click on add port.
7. Named the port SQL, and enter 1433 as the port
8. Click on Okay.

Results

This worked. I was able to connect to SQL server in the building. The server is behind a external firewall so it will not work outside.

Could Not Connect to SQL Server

Internal DNS Error

My lab is experience odd DNS errors. The internet address http://bis.ldsbc.edu (172.16.1.11 internal IP) is not resolving correctly. Some computer gets the correct webserver but others get a second server that has an internal ip address of 172.16.1.12.

The records in the internal DNS server seem correct. I am working the issue.

 

Gathering Information

I need to identify which computer had the issue with DNS. I only remember workstation 43 having an issue. I will ask students to give me feedback.

The error continues to happen. Server1 and Server2 are still being resolved to bis.ldsbc.edu.

 

Hypothesis

H1. Create an A record for bis 172.16.1.11 and the situations should be fixed.

 

Results

Still have issues after H1 was completed.

 

Searching in Vista and Server 2008

 

Having just recently moved to Vista and Server 2008, I was not sure how to search for file content.

Searching for file name is fairly clear. You type the file name in the search box. See Figure 1 upper right hand corner.

After reading several helpfiles, I found that you type the content in the box also. The OS will search the content from the same search box.

This is easier but not too easy to figure out. Did Microsoft get it right? They got it have right; the function is great but they need to include some direction that content search is in the same box.

This is also my first attempt at a picture in a blog. The picture does not work. See the empty space below. Well. That will be a blog later.

 

 

Figure 1

Skipping the CD-ROM Buring

I went to Microsoft Developer's Network Academic Alliance and downloaded an ISO of Microsoft's new web publishing software (Expression) because I did not want to burn CD Rom.

I went to sourceforge.net and searched for "Mount ISO " . There is a piece of software called 7-zip that allows you to read an ISO and extract the files.

Why this software package? It had over 25 million downloads and the rating was very high.

It is important, as IT professionals to look at costs and try to go with free software whenever possible along with considering the total cost of ownership.

Training is a cost that is often overlooked. We tend to think that "They can pick it up on their own" and forget that a lot of users have trouble with new software. Training is valuable part for them. For example: My wife's company just went to Office 2007. She had a few rough spots, but managed to get through it. I rate her computer skills higher than the average user. (She is able to easily manage her Sprint card and a complex VPN software on her own.) The lesson? Don't forget the training.

Click here for a link to 7-zip.