SQL Express - Creating Tables etc using Visual Studio.

Hi,

I am new to sql server.

I downloaded sql server express edition and created a database. I now have the default SQLExpress instance and the new one I created. I looked up online and found that I could do most activities like creating tables, views, stored procedures etc. from within Visual Studio (where a SQL Servers node is displayed). I don't see this node. All I see is Crystal report services, Event logs........and Services.

I have tried going under Tools->Connect To Database->Microsoft sql server-> Add connection (picked server name). The drop-down for Select or enter database name is blank. When I type it in I get an error indicating the connection failed (an error has occured while establishing a connection to the server....the failure may be caused because under the default setting sql server does not allow remote connections....).

Any help in getting me started here will be appreciated.

Thanks.



Answer this question

SQL Express - Creating Tables etc using Visual Studio.

  • CJ1983

    How do you specified the server when you typed it in, and what was the complete text of the error

    When using SQL Express the server should be specified as

    .\SQLEXPRESS

    Also make sure that the SQL Express service is running.



  • stevenng

    Hi Peter,

    I have confirmed the service is running by opening sql server configuration manager. Is there something I need to set for "Protocols for JVSQLEXPRESS (name of my DB) - like setting Shared memory, named pipes, TCP/IP and Via

    And yes, I typed in .\JVSQLEXPRESS when trying to connect. Continue to see the same error.

    Thanks.


  • SQL Express - Creating Tables etc using Visual Studio.