How to set up a SQL Server 2008 Local Database


Setting up and Configuring your Microsoft SQL Server 2008 Local Database


Download SQL Server

Download SQL Server Express.  Express is the Free edition of MS SQL Server

http://www.microsoft.com/en-us/download/details.aspx?id=1695


Install your SQL Server Instance

  • Click the Start button -> Click Microsoft SQL Server 2008 -> Click Configuration Tools -> Select SQL Server Installation Center
  • Select Installation -> Select New SQL Server stand-alone installation

SQL Server Installation Center Image
Select SQL Server stand-alone installation




Get your Local SQL Server Service Up and Running


Open up the SQL Server Configuration Manager
  • Click the Start button -> Click Microsoft SQL Server 2008 -> Click Configuration Tools -> Select SQL Server Configuration Manager
SQL Server Configuration Manager Image
Setup SQL Server Config Manager


Start up the SQL Services

You want to ensure the following services are in the "Running" State and then you want to set the following services to automatic Start mode.  
  • SQL Server:  SQLEXPRESS 
  • SQL Server Browser

Right click each service -> Select Properties -> Select Service Tab


SQL Server Config Manager Console
Start up required SQL Server Services


Setup Authentication to your Local SQL Server




  • Click the Start button -> Click Microsoft SQL Server 2008 -> Select SQL Server Management Studio 
  • Click "Connect to Object Explorer" and select Server Name:

[YOUR_PC_NAME]\SQLEXPRESS

Example: 

Your Computer\SQLEXPRESS or (localhost)\SQLEXPRESS


Setup Authentication for your SQL Server


Finding your PC Name:
Click the Start Button -> Right-click My Computer -> Properties -> Computer Name tab


Control Panel Console - Basic Information
How to find your PC Name on the network



Configure your User Accounts and Permissions


Create a Login Account: 


  • Click the Start button -> Click Microsoft SQL Server 2008 -> Select SQL Server Management Studio 
  • Connect to your Local SQL Server
  • Click on the expand tree button for your Local Server -> Security -> Right-click on Logins -> Select New Login

Setup the Password for the New User: 

Un-check the following settings:



  • Enforce password policy
  • Password expiration 
  • User must change pw(Since this is local) 


Set the Default database -> This DB

Grant roles to New User Account: User Configuration Page


  • Map to your database -> grant db_owner role Status Page
  • Grant Permissions to connect then Enable Login
Permissions and Roles config in User Account Console
Setup Permissions and Roles




Setup Network and Authentication


Enable all Authentication Modes


  • Click the Start button -> Click Microsoft SQL Server 2008 -> Select SQL Server Management Studio 
  • Connect to your Local SQL Server
  • Right-click your Local Server -> Select Properties -> Select Security Tab -> Enable SQL Server and Windows Authentication Mode

Network Configuration

Enable TCP/IP



  • Open SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for SQLEXPRESS -> Enable TCP/IP
Network and Auth Configuration
Enable TCP/IP and set up authentication method


Restart your SQL Local Server Service

  • You will have to restart your SQL Server after enabling TCP/IP



Comments

  1. thanks for the shared such a informative information.

    Fully dedicated hosting

    ReplyDelete
  2. Its helpful thanks for information...


    https://techmyeducation.blogspot.com/2019/05/how-to-become-web-developer.html

    ReplyDelete
  3. Wow, amazing blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your website is fantastic, let alone the content!

    3D animation Company
    Chatbot Development Company
    Android app development in Coimbatore

    ReplyDelete
  4. Download and install Vidmate App which is the best HD video downloader software available for Android. Get free latest HD movies, songs, and your favorite TV shows.

    ReplyDelete
  5. It is a really interesting content and Great work by you. Definitely, it will be helpful for others. I would like to follow your blog. Keep posting more in your future blog post.
    IAS Academy in Chennai | IAS Academy in Anna Nagar | Top 10 IAS Coaching Centres in Chennai | Top IAS Academy in Chennai | Top IAS Coaching in Chennai

    ReplyDelete
  6. Thanks for the information. It's very useful. If any businesses is looking for best web design & PSG Grant eCommerce website in Singapore click on the link.

    ReplyDelete
  7. Hiiii....Thanks for sharing Great info...Nice post...Keep move on...
    Python Training in Hyderabad

    ReplyDelete
  8. Nice blog, thank you so much for sharing such an amazing blog. Get the best Website Designing Services by our expert of OGEN Infosystem in Delhi, India.
    Web Design Company in Delhi

    ReplyDelete
  9. Wonderful blog post, thank you so much for the great information which you provided.
    https://rokucomlinks.org/

    ReplyDelete
  10. It is really helpful article please read it too my blog FACEBOOK IMAGES NOT LOADING.

    ReplyDelete
  11. It is really helpful article please read it too my blog FACEBOOK IMAGES NOT LOADING.

    ReplyDelete
  12. Wow!!! It was really an Informational Article which provide me with much Insightful Information. I would like to first thank the author for such an Insightful Content. If someone here is looking for a Website Designing Company in India, then look no further than Jeewangarg.com as we are the best website designing company in Delhi working in the arena for the last 8 years.
    Best website designing company in India
    website designing company in NCR

    ReplyDelete
  13. I would first like to thank the author for coming up with the insightful information every time. People if you are also looking for the best shimla tour packages | Best Rajasthan Tour Packages then reach out to Indian Travel Store as we are the best Travel Partners of yours.

    ReplyDelete
  14. I would first like to thank the author for coming up with the insightful information every time. People if you are also looking for the best indian dresses online | buy lehenga online then visit Panache Haute Couture, a leading Indian Designer House for Indian Dresses.

    ReplyDelete
  15. Wow!!! A great insightful & informative content on ACP Board. Virgo Group is the largest providers of best in class leading facade materials and more & having years of experience in manufacturing Premium ACP Sheet. We aim to deliver excellence and ensure maximum worth for our clients’ money and so we provide you with the best ACP Sheet Price.

    ReplyDelete
  16. Thanks For Sharing this post. this post is very useful for me. also here Are you Looking for Indian Designer Anarkali dress or Anarkali Salwar Kameez anarkali?

    We have Largest & latest Collection of Indian Designer Anarkali Suits which is avilable now at Best Discounted Prices.

    ReplyDelete
  17. Thank You for providing us with such an insightful information through this blog. However, if you are in the search of finding Cab or Taxi Services in Melbourne? Your Search Ends here…
    silver service cabs is your answer for availing best silver taxi service in Melbourne. Reach us for the best Silver Service Cab Melbourne.

    ReplyDelete
  18. A list of the best ACP sheets and acp sheet manufacturers in India who produces compact, strong and durable sheets those are best for your home décor, office or Industry etc. Aluminium Composite Panel

    ReplyDelete
  19. A list of the best ACP sheets and acp sheet manufacturers in India who produces compact, strong and durable sheets those are best for your home décor, office or Industry etc. Aluminium Composite Panel

    ReplyDelete
  20. Thanks For Sharing this post. this post is very useful for me. also here Are you Looking for Indian Designer Anarkali dress or Anarkali Salwar Kameez anarkali? We have Largest & latest Collection of Indian Designer Anarkali Suits which is avilable now at Best Discounted Prices.

    ReplyDelete
  21. Nice Information. Thanks for sharing this Post. Are you looking for web design and logo design for your company or business please contact Subraa your freelance website designer and logo designer in Singapore. Structure your business website and get your logo FREE.

    Click the below links know more the offers:

    Logo Design
    Logo Design Singapore
    Logo Designer Singapore
    Web Designer Singapore
    Digital Marketing Agency in Singapore
    Flyer Design Singapore
    Name Card Design Singapore

    ReplyDelete
  22. Hi I’m Gorge More is a professional service provider who is an experienced technician and has more than 5 years of hand on experience. If you are facing any kind of technical glitch in your Amazon gift card balance then it’s time that you must definitely consider us. We will help you to solve your query within minutes.
    More Info :
    Amazon Gift Card Balance Check | refund Amazon gift card | Amazon.com balance | check Amazon gift card balance | Amazon gift card activation | register Amazon gift card |Redeem Amazon Gift Card | Amazon Check Balance | Amazon Card Balance

    ReplyDelete
  23. Thankyou for this article this information is very useful for me. i have also information for you A list of the best ACP sheets and acp sheet manufacturers in India who produces compact, strong and durable sheets those are best for your home décor, office or Industry etc. Aluminium Composite Panel

    ReplyDelete
  24. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    data analytics courses in Mumbai

    data science interview questions

    business analytics courses

    data science course in mumbai

    ReplyDelete
  25. ftv is a Porn Training site. ftv is the largest Amateur porn training institute with the hottest selection Online and offline real life cam.
    sex video

    ReplyDelete
  26. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it.

    For more info:
    https://360digitmg.com/course/machine-learning-using-python-r
    https://360digitmg.com/course/artificial-intelligence-ai-and-deep-learning
    https://360digitmg.com/course/certification-program-on-big-data-with-hadoop-spark

    ReplyDelete
  27. Onlinebattery.co.in is No.1 car battery shop in Ballabhgarh, Faridabad under the aegis of Garg Trading Company, offering 100% genuine batteries with manufacturer warranty. We have the complete range of automotive, two wheeler, inverter, generator, solar batteries and water purifier. We sell all types of battery brands like Exide, Amaron, Luminous, Okaya, MtekPower, Su-Kam, Tata Green and Adwin.

    ReplyDelete
  28. Very interesting information and very useful topic. I have information regarding data science course in Chennai.
    data-science training
    Data-Analytics course
    business analytics -Python course

    ReplyDelete
  29. This is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environmen python training in vijayawada. , data scince training in vijayawada . , java training in vijayawada. ,

    ReplyDelete
  30. Really awesome blog!!! I finally found great post here.I really enjoyed reading this article. It's really a nice experience to read your post. Thanks for sharing your innovative ideas. Excellent work! I will get back here.
    Data Science Course
    Data Science Course in Marathahalli
    Data Science Course Training in Bangalore

    ReplyDelete
  31. Really Very helpful Post & thanks for sharing & keep up the good work.
    Oflox Is The Best Digital Marketing Company In Dehradun Or Website Design Company In Dehradun

    ReplyDelete
  32. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data science Interview Questions
    Data Science Course

    ReplyDelete
  33. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our Data Science course in Mumbai
    data science course in mumbai | https://www.excelr.com/data-science-course-training-in-mumbai

    ReplyDelete
  34. This is truly unique and excellent information. I sense you think a lot like me, or vice versa. Thank you for sharing this great article.
    Best Data Science training in Mumbai

    Data Science training in Mumbai

    ReplyDelete
  35. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our data science training in mumbai
    data science training in mumbai | https://www.excelr.com/data-science-course-training-in-mumbai

    ReplyDelete
  36. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
    data analytics course in Bangalore

    ReplyDelete
  37. Wonderful post, i loved reading it.
    Share more
    Gaudeo
    Kitsunemusicacademy
    Corejoomla

    ReplyDelete
  38. I'm not one of those readers that comments on articles often, but yours really compelled me. There's a lot of interesting content in this article that is interesting and bold.
    SAP training in Mumbai
    Best SAP training in Mumbai
    SAP training institute Mumbai

    ReplyDelete
  39. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data Science Course

    ReplyDelete
  40. I think SQL and REST are the most useful tools to provide information and find out solutions about complex database operations.

    SQL Server Load Rest API

    ReplyDelete
  41. I am looking for and I love to post a comment that "The content of your post is awesome" Great work!

    Correlation vs Covariance

    ReplyDelete
  42. Nice Post,keep blogging

    Data Science is the future of Artificial Intelligence. Therefore, it is very important to understand what is Data Science and how can it add value to your business.Data science has critical applications across most industries, and is one of the most in-demand careers in computer science.

    Best Data Science Online Training Institute

    ReplyDelete
  43. Very informative post! This post gives truly quality information. I find that this post is really amazing. Thank you for this brief explanation and very nice information.

    office.com/setup
    mcafee.com/activate

    ReplyDelete
  44. Reading this article gave me many things to think about. You have some quality information here that any reader would enjoy. I share many of your views in this article.
    SAP training in Kolkata
    SAP training Kolkata
    Best SAP training in Kolkata
    SAP course in Kolkata
    SAP training institute Kolkata

    ReplyDelete
  45. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance

    ReplyDelete
  46. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it.

    Data Science Institute in Bangalore

    ReplyDelete
  47. Your work is very good and I appreciate you and hopping for some more informative postsData Science Training in Bangalore

    ReplyDelete
  48. Much obliged to you, for giving us such significant data! You are wonderful, your article continually helping me to see any technique related subjects easily. It would be ideal if you continue doing this consistently.


    SEO services in kolkata
    Best SEO services in kolkata
    SEO company in kolkata
    Best SEO company in kolkata
    Top SEO company in kolkata
    Top SEO services in kolkata
    SEO services in India
    SEO copmany in India

    ReplyDelete
  49. This comment has been removed by the author.

    ReplyDelete
  50. Ok, i have check out on this sql server and information. Can you let me know how do i create a string for swimming lessons topic?

    ReplyDelete
  51. I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more....Data Analyst Course

    ReplyDelete
  52. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

    ReplyDelete
  53. This is my first time i visit here. I found so many entertaining stuff in your blog, especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the leisure here! Keep up the good work. I have been meaning to write something like this on my website and you have given me an idea.

    Data Science Course

    ReplyDelete
  54. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing.

    Data Science Training

    ReplyDelete
  55. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  56. very nice.We know how that feels as our clients always find themselves to be the top rankers. Its really easy when you consult that best SEO company in Chennai.

    best seo company in chennai|expert seo company in chennai|best seo analytics in chennai|seo specialist companies in chennai|top 10 search engine optimisation service providers in chennai

    ReplyDelete
  57. Thanks to you for suggestion me a top website to Buy Instagram Followers India at cheap price and 100% real followers and instagram promotion services.
    Buy instagram followers India

    ReplyDelete
  58. Great article and tips you shared.
    Looking for top and award winning Social Media Marketing Company in India than i would suggest go with this and Buy Real Instagram Followers Paytm

    ReplyDelete
  59. At the very least in order to program machines to simulate human mental processes, one needs to understand and clarify, how these processes function artificial intelligence training in hyderabad

    ReplyDelete
  60. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    ReplyDelete
  61. This is my first visit to your blog! We are a team of volunteers and new
    initiatives in the same niche. Blog gave us useful information to work. You
    have done an amazing job!

    artificial intelligence training in Bangalore

    ReplyDelete
  62. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data science course

    ReplyDelete
  63. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression
    data science interview questions

    ReplyDelete
  64. I would recommend my profile is important to me, I invite you to discuss this topic...data science certification

    ReplyDelete
  65. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  66. I finally found great post here.I will get back here. I just added your blog to my bookmark sites. thanks.Quality posts is the crucial to invite the visitors to visit the web page, that's what this web page is providing.
    360DigiTMG data science course
    business analytics course
    data analytics course

    ReplyDelete
  67. I have recently started read this blog, the info you provide on this post has helped me a lot. Thanks for all of your time & work.Learn best Data Science Course in Hyderabad

    ReplyDelete
  68. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.Learn best Business Analytics Course in Hyderabad

    ReplyDelete
  69. Attend The Data Analyst Course From ExcelR. Practical Data Analyst Course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analyst Course.
    Data Analyst Course

    ReplyDelete
  70. You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject!data science course

    ReplyDelete
  71. Incredible tips and straightforward. This will be exceptionally helpful for me when I get an opportunity to begin my blog. But when it comes down to voting, most will not come down to wild cards.

    If you ever need a recommendation on website design, you can check us out at the web design and development company in Singapore.

    And if you also happen to be looking for swimming lessons, you can check us out at friendly dolphin swim school, we provide swimming lessons for all. And this skincare expert to help you provide you with the best skin after swimming.

    ReplyDelete
  72. I have gone through your article and I have found that all the points are unique and imaginative in my opinion. Hope to read some more like this article.

    SEO services in Kolkata
    SEO company in Kolkata
    SEO in Kolkata
    Best SEO services in Kolkata
    Best SEO company in Kolkata

    ReplyDelete
  73. I'm not one of those readers that comments on articles often, but yours really compelled me. There's a lot of interesting content in this article that is interesting and bold.
    SAP training in Kolkata
    SAP training Kolkata
    Best SAP training in Kolkata
    SAP course in Kolkata

    ReplyDelete
  74. It's truly an honor to run across informational content like this. You are clearly knowledgeable on this topic and you have unique views to share.
    Data Science training in Mumbai
    Data Science course in Mumbai
    SAP training in Mumbai

    ReplyDelete
  75. Attend The Data Science Courses Bangalore From ExcelR. Practical Data Science Courses Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Science Courses Bangalore.
    Data Science Courses Bangalore

    ReplyDelete
  76. The writer is enthusiastic about purchasing wooden furniture on the web and his exploration about best wooden furniture has brought about the arrangement of this article.data science course in noida

    ReplyDelete
  77. awesome article. thanks for sharing.keep posting like this.Escape your daily routine at the best Massage centre in Coimbatore. Family Friendly with lovely amenities and friendly staff. Book your Spa Massage today.

    massage in coimbatore | body massage coimbatore | massage spa in coimbatore | body massage center in coimbatore | massage centre in chennai | body massage in chennai | massage spa in chennai | body massage centre in chennai | full body massage in chennai | chennai massage centre address

    ReplyDelete
  78. Very impressive and interesting blog found to be well written in a simple manner that everyone will understand and gain the enough knowledge from your blog being more informative is an added advantage for the users who are going through it. Once again nice blog keep it up.

    360DigiTMG Machine Learning Course

    ReplyDelete
  79. Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time
    sql dba training
    sql server dba online training

    ReplyDelete
  80. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!

    data science interview questions

    ReplyDelete
  81. Found valuable Article with great information thank you for sharing.

    Data Science Training in Hyderabad

    ReplyDelete

Post a Comment

Popular posts from this blog

Change Port on a Spring Boot Application when using intelliJ

Add Guava Cache to Spring Boot to Cache Method Calls