Problems with SQL Server 2005 Remote Connection

During execution of my project I had to access my virtual environment with Visio to do a Reverse Engineering in my database, and I got this error :

Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Here I got a SQL Server WorkGroup and to solve this problem use the following link:

How to configure SQL Server 2005 to allow remote connections (link)

Other important thing is to pay attention always remember to validate the server name when you creating a connection. Here I have a lot of Virtual Machines and sometimes the start up with the same name. Just pay attention, and if you have this case use the [IP]\[Instance_Name].

Solving Disallowed Parent Path Error

Today I was installing an ASP 3.0 Web site evaluate an ASP to ASP.net migration... and because that I start to get old kind of problems (nothing like a long time away from ASP 3.0).

I created and Virtual PC with Windows Server 2003, IIS6 and configure my Virtual Directory... and for my surprise I got this error message :

Active Server Pages error ''ASP 0131''

Disallowed Parent Path

/site/index.asp, line 1

The Include file ''../include/conn.asp'' cannot contain ''..'' to indicate the parent directory.



After some Microsoft KB search I found this :

Enable Parent Paths Is Disabled by Default in IIS 6.0 (link)

If you get the same error the workaround is:

1. On IIS, right click on you site/Virtual Directory, Properties

2. Click on Configuration

3. On Options tab

4. Select Enable Parent Paths

See ya!

SEO and .NET

In a recently chat with my friend José Papo we discuss about SEO and how can I make my blog more readable and searchable.

20 minutes after configure my Google Analitcs, Google WebMaster Tools and read his post about how to optimize sites for search engines (portuguese), I start to think how can I do this with .NET and its links, how can I help my customers with that.

Searching Amazon I found an intersting book, that is already in my wishlist for the next month:

• Professional Search Engine Optimization with ASP.NET: A Developer's Guide to SEO (amazon) (wrox)

• What you will learn from this book

• Understand the criteria that influence search engine rankings
• Create keyword-rich URLs using ASP.NET, ISAPI_Rewrite, and UrlRewriter.NET
• Use HTTP Headers to properly indicate the status of web documents
• Create optimized content and cope with duplicate content effectively
• Avoid being the victim of black hat SEO techniques
• Understand and implement geo-targeting and cloaking
• Use site maps effectively—for users as well as search engines
• SEO enhancements that can easily be applied to an existing web site
• Build a search engine–friendly e-commerce catalog
• In my recent projects a common requirement is how to make my site more searchable. How to change my links in ASP.NET to make them more compliance with search engines.

Just to define :

(Wiki) Search engine optimization (SEO) is the process of improving the volume and quality of traffic to a web site from search engines via "natural" ("organic" or "algorithmic") search results for targeted keywords.

I found an article that contains one way to do this :

Developing SEO friendly URLs with ASP NET 2.0 (link)