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.

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.