Create New SQL Server Database

Create New SQL Server Database

• Montana16

  hi,

  i don't have anything in database explorer to creat a database i use express edition too but when i want to creat a database i use project menu and chose add new item then i select database and i go through the config. of my database.

  or i right click on my project nameon solution explorer and select add new item and do the same steps

   

  
  
  

• YT

  Well, you're not alone. It took me a few clicks to find the menu you were referring to. I finally found it when I right clicked the Data Connections icon. The "Create New SQL Database" option is also greyed out in my program. My version is 2.0.50727.

   

  
  

• Torsten Pietrek

  When the Database Explorer window is open, there are three icons at the  top. Click the one to the right, the orange cylinder representing a database connection. When you hover your mouse over it, the tool tip will show "Connect to Database". A new window will open. The cursor will be in a box and the box label says "Database file name(new or existing). To create a new db, browse to the folder you want it to be in and then type in the name you want it to have and when you exit the box the OK button will be available. Click it and a msgbox will tell you the database doesn't exist and asks if you want to create it. Click Yes and it will appear in the Database Explorer window.
  

• grnfvr

  Hello,

  Mine is also greyed out.

  However, the free book from MS (after installing VWD 2005 express edition), titled "Build a Website Now" clearly shows that this should not be greyed out. It should be an available shortcut menu option.

  What could be going on here Weird.

  
  

• jstacy

  hi,

  for me its the same in grey color, may be it will be active in other editions of vb like the standered edition or the prof. edition

  
  
  

• ShawnSantana

  I was trying to figure out how to use the SQL Express version and everything... when I saw this tut about making a personal web page using the VWD...
  On VB and C++ the same item was greyed out..
  What I did was unistall everything, then install VB.NET and then the SQL express server... now it works...
  Maybe its in the order you install things or something
  Try it out just unistalling everything then installing the VS version you want and then the SQL server you want...
  *shrugs*
  Now im trying to figure out how to execute procedures and all.. =D
  ...
  Cya...
  

• Xin Zhang

  Hi

  Thanks for replying.

  I know how to create a new database, that is not my actual question.

  My question is how come when I right click in the database Explorer window the "Create New SQL Server Database' is greyed out when other peoples is not I have seen on the official Microsoft tutorials them use this option.

  What is different about my version or install of VB Express or SQL Express. I am using the released editions etc.

  Really what I am trying to determine is why is mine different, because if it is different here it could have other problems that I have not yet found.

  Regards.

  Larry_t.

   

   

   

  
  
• Create New SQL Server Database