Troubleshoot Network Connectivity and Reset TCP/IP Windows XP

by Damiaan Peeters 18. April 2008 17:02

I regularly have some clients with network problems.  Using this article I solved a lot of problems.  The article How to troubleshoot TCP/IP connectivity with Windows XP describes a lot of useful tools to determine where the network problem exists.

If you suspect problems with the Tcp/IP stack.  You can use the article on TechNet: Reset the Internet Protocol (TCP / IP) stack in windows XP.  Because the TCP/IP stack is considered a core component of the Windows XP operating system, you cannot remove it.  You need to follow the instructions given in the article.  Being...

netsh int ip reset c:\resetlog.txt

Error attaching database to Microsoft SQL Server 2005 in Windows Vista (Business)

by Damiaan Peeters 12. April 2008 14:38

Today, I couldn't attach a database of my previous pc to my new MSSQL Server installation.

I got this strange error message in Microsoft SQL Server Management Studio.

[more]

I got this error message:

image 

Attach database failed for Server 'STELLA'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Unable to open the physical file "E:\MSSQL\InfoBase.mdf". Operating system error 5: "5(error not found)". (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

 

Solution

The solution was very easy.  Launch Microsoft SQL Server Management Studio as Administrator.

No Network connectivity - TCP Autotuning in Windows Vista

by Damiaan Peeters 4. April 2008 01:01

Problem

When i installed windows Vista, Live Messenger (and various other applications) where not working properly. They could not connect to the internet. 

Using the Internet Connectivity Evaluation Tool might help detecting any problems at home networks.  It did for me.  I found out that my router is not supporting "Universal Plug and Play" (UPnP).

Solution

A long story short:
Apparently the problem is the TCP auto tuning feature of Windows Vista.
On technet I found this: "Network connectivity may fail when you try to use Windows Vista behind a firewall device".  It helped.

Conclusion

Although everything is working for now, our router is still not "up-to-date".  I'm consider buying a new router.

Who.I.am

Certified Umbraco, .net and Azure developer, seo lover. Magician in my spare time.

Month List