OLAP

Yes, Visual studio comes bundled with a copy of SQL express edition which gets installed during visual studio installation.

These steps are required to create database with SQL express bundled with Visual Studio. So guys, I request you all to please perform these steps while reading this article.

Click on at least one image to start the slideshow

Refer Slide 1,To view the SQL express,Click on ‘View’ -> ‘Server Explorer’.

Refer Slide 2, Right Click on ‘Servers’ and select ‘Add a Server’.

Refer Slide 3, Write Server Name in the Dialog, In this case, you have to write your machine name.

Refer Slide 4,To create a database,Right Click on Data Connections and select “Create SQL server database”.

Refer Slide 5, In the dialog box, select  server name from the list, select the authentication you want to use and provide a new database name.

Refer Slide 6, To create a connection,Right Click on Data Connections and select “Add Connection”.

Refer Slide 7,In “Choose Data Source” dialog box, select “Microsoft SQL Server”, data provider will get filled simultaneously.Click continue.

Refer Slide 8, Fill Connection properties in the dialog box, select server name from the list. Once server is selected, “Connect to database” section gets activated,  select database and click “Test Connection”.

Comments awaited!

Author: hershey

A passion for knowledge drives me to do programming, A passion for programming drives me to create something different, A passion for creation drives me to spread the knowledge.

Share This Post On

0 Comments

  1. nice superb explaination

    Post a Reply
  2. thanks for the tutorial
    I am having a problem.
    The feature “Create SQL server database” isn’t available , I can’t select it.
    Can you help, please ?

    Post a Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

More from CodeSpread:

  • How to create a MVC 2 Project in VS2010?How to create a MVC 2 Project in VS2010?How to create a MVC 2 Project in VS2010? 1. Open VS2010. 2. Select File -> New Project. 3. Select Visual C# -> Web -> ASP.NET MVC 2 Empty Web Application. Name it as MyMvcApplicat...
  • SQL Tables,Temporary Tables,Table VariablesSQL Tables,Temporary Tables,Table VariablesSQL provides a variety of Tables. Lets summarize each one of them. Permanent Tables: Why do we require it? It is required for data persistence across the database. Once tables are created ...
  • Windiff saved my effort. How it is useful?Windiff saved my effort. How it is useful?While working with TFS [Team foundation server],we get used of the compare feature to compare the 'local version', 'server version','workspace version'. We had some similar situation when we rec...
  • How to change the target .net framework in Visual Studio?How to change the target .net framework in Visual Studio?There are many ways to set the target .net framework. Few are listed below. When we add a project , we can set the target .net framework. Refer the screenshot. We can change the framework...
  • Best Practices: Does Professional Database exists?Best Practices: Does Professional Database exists?What is Database? Database is a structured set of data, which facilitates storage,search and retrieval. Databases revolves around tables and relationships between them. Imagine you have a truck lo...
  • IIS- Still learning!IIS- Still learning!Whenever we receive some error which is related to IIS, we just jump on internet as we lack the basic concepts of IIS and i can definitely say that we almost ignore IIS and focus ourselves on devel...
  • Unused Useful Tools in Visual StudioUnused Useful Tools in Visual StudioBack from a vacation is always a great and refreshing feeling. A small break always adds a new dimension to the thoughts. Lets see what we have today which we can call ‘new’ . We are good workin...
  • Visual Studio 2013 CountdownVisual Studio 2013 CountdownIt's quite amazing to see people everywhere talking about the launch of visual studio 2013. We thought, even we should also get the feel of the new version. First thing, which I noticed, was the co...