F.A.O Imar - Underscores In Computer Name
Hi Imar,
Just thought I would put my past weeks experience into words to see if you can help others in the future?
Just so you know, when I started your book my setup was:-
My computer Name was IAN_AW_VAIO
MS SQL Server 2008 R2 Installed and all databases created through this version of SQL Server
VS 2010 Ultimate Installed
After your help during chapter 9 we worked out that my own computer name was causing me issues when communicating with an SMTP server to send email via a contact form. Amongst other things, which you know had nothing to do with the book, we solved this problem of sending emails by renaming my machine name and removing the underscores.
What I did not know at the time of chapter 9 was the ramifications that would be incurred by changing my machine name! Remember that my computer name after chapter 9 is now "IANAWVAIO" and SQL Server still works fine?
I got to chapter 12 a week ago, which to me is easy since I have been using SQL for as long as I have been programming, but I followed through anyway by speed reading and skipping where I knew I could to make sure I did not miss anything regarding ASP.
Then I got to adding the database diagram so that we could manipulate relationships. At this point I got an error stating that I did not have the security privileges to create database diagrams under my own user name even thought I could still log on to the SQL server and do anything I wanted except create database diagrams in SQL Server Management Studio?
Being a bit confused I checked my user name in SQL server and found it was still related to " IAN_AW_VAIO" even though the computer name was now "IANAWVAIO". Thinking that it was the old computer name that was causing problems I decided to delete my current account and recreate it under the new computer name.
This did not work (or I messed up) and trying to fix this issue I got numerous security issues on SQL server, ending up having to reinstall SQL server and VS 2010 numerous times. I lost "Publish to Provider" in VS 2010 along the way and then got database version compatibility issues. In the end both SQL Server and VS 2010 were both starting to give windows errors when trying to load and close down - nightmare ! Let me know if you want me to go into detail here, but for this blog I think it detracts from the origin of the cause.
I ended up having to do a full reinstall of my PC incorporating all the issues I had learned during the studying of this book and now that I have a clean install, incorporating what I know now, everything is working perfectly as per your book.
What this all boils down to Imar are the UNDERSCORES in the computer name identified in chapter 9.
As an experienced developer of 20 years this has taught me a huge lesson since underscores in a computer name have never caused me concern before but when migrating to the internet environment it is the must crucial thing to make sure that a user does NOT have underscores in their computer name before they start the journey.
Maybe this is something you would like to mention to other users to save them having to buy numerous packets of headache tables like me.
Talk to you again soon.
Kind regards,
Ian Ryder.
|
button below this post to show your appreciation!
