Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anomie
Starting Member
16 Posts |
 Posted - 2009-01-18 : 12:49:47
|
| Hi all,Im experiencing a problem using visual web developer 2008 express. I am trying to build an ecommerce website through guidance of a book named "beginning ASP.NET e-commerce in C# 2005". So far, i have created a web user control, included in the master page and created a default.aspx page. I am at the stage of creating an sql server databse. In my visual web developer project, in my databse explorer window, i am instructed to right-click the "Data onnections" entry, then select "create new sql server database". The problem is, when i do this the option to create a new sql server database isnt availible to click on (when i right-click, the menu box appears. i can see the option but it is in light grey so i cannot click it to select it).Can anyone explain why this is, and if possible, explain how i can get around this?Many thanx,Anomie |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-18 : 12:52:03
|
| can you check if database engine services are running in surface configuration manager? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-18 : 12:55:43
|
| Can you post the error ? |
|
|
|
anomie
Starting Member
16 Posts |
Posted - 2009-01-18 : 13:10:24
|
| To make it more clear i have uploaded a screen dump with the problem highlighted in red. It can be accessed here:http://intasp.bcuc.ac.uk/20527796/visual_web_dev_error.jpgI am fairly new to visual web developer. In response to visakh16, how do i access the configuration manager?Regards,Anomie |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-18 : 13:14:37
|
| Type SQLServerManager.msc in Run and check whether SQL Server is running or not. |
|
|
|
anomie
Starting Member
16 Posts |
Posted - 2009-01-18 : 13:17:21
|
| I have typed SQLServerManager.msc in Run but windows cannot find it. I get an error message. Do i need to install an extra component? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-18 : 13:22:05
|
| Are you able to connect to SQL Server you are trying to access? |
|
|
|
anomie
Starting Member
16 Posts |
Posted - 2009-01-18 : 13:31:45
|
| Its cool guys, ive figured it. I created it another way. I solved it as such:Solution Explorer - right click on App_Data.Selected 'Add New Item'.Chose SQL Server Database.Clicked "Add" (to create a database with the name Database.mdf").not sure why the instructions that were given told me to go through the Database Explorer. |
|
|
|
|
|
|
|
|
unable to create new sql server database