Need help - SQL Express 2005 (Beta 2) - where to start ?

Hi,
I downloaded and installed SQL Express 2005 (Beta 2). I want to create
tables and see whether I can get the data from the trivial windows based
application or web application I will be building in C# using Visual Studio
2003.
Question :
Where can I get the details regarding how to create tables in SQL 2005 and
how to get it connected with my application? Any suggestions regarding any
websites or good books that I can use to learn as well as use it as
reference in future.
Thank you for your time and willingness to help.
Best Regards,
Likhith
Download the Books Online for SQL Express 2005 and then just select Help on
the menu. If you want to get a lot deeper, there's already a really good
book out on SQL 2005. "A First Look At SQL Server 2005 For Developers" is
available from MS Press. I have it and would highly recommend it to anyone.
"Likhith Areekkal" <li_areekkal@.sympatico.ca> wrote in message
news:L4ucd.24$JG5.21616@.news20.bellglobal.com...
> Hi,
> I downloaded and installed SQL Express 2005 (Beta 2). I want to create
> tables and see whether I can get the data from the trivial windows based
> application or web application I will be building in C# using Visual
Studio
> 2003.
> Question :
> Where can I get the details regarding how to create tables in SQL 2005 and
> how to get it connected with my application? Any suggestions regarding any
> websites or good books that I can use to learn as well as use it as
> reference in future.
> Thank you for your time and willingness to help.
> Best Regards,
> Likhith
>
>
sql

Need help - SQL Express 2005 (Beta 2) - where to start ?

Hi,
I downloaded and installed SQL Express 2005 (Beta 2). I want to create
tables and see whether I can get the data from the trivial windows based
application or web application I will be building in C# using Visual Studio
2003.
Question :
Where can I get the details regarding how to create tables in SQL 2005 and
how to get it connected with my application? Any suggestions regarding any
websites or good books that I can use to learn as well as use it as
reference in future.
Thank you for your time and willingness to help.
Best Regards,
LikhithDownload the Books Online for SQL Express 2005 and then just select Help on
the menu. If you want to get a lot deeper, there's already a really good
book out on SQL 2005. "A First Look At SQL Server 2005 For Developers" is
available from MS Press. I have it and would highly recommend it to anyone.
"Likhith Areekkal" <li_areekkal@.sympatico.ca> wrote in message
news:L4ucd.24$JG5.21616@.news20.bellglobal.com...
> Hi,
> I downloaded and installed SQL Express 2005 (Beta 2). I want to create
> tables and see whether I can get the data from the trivial windows based
> application or web application I will be building in C# using Visual
Studio
> 2003.
> Question :
> Where can I get the details regarding how to create tables in SQL 2005 and
> how to get it connected with my application? Any suggestions regarding any
> websites or good books that I can use to learn as well as use it as
> reference in future.
> Thank you for your time and willingness to help.
> Best Regards,
> Likhith
>
>

Nebie connection problems with SQL Server 2005 Express and VS 2005

I downloaded SQL Server 2005 Express and some sample databases (incl. Adventureworks_data.mdf), but when I try to Add Connection in VS 2005 to point to this db and use the Test Connection button, it gives the error:

Microsoft Visual Studio

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I've tried setting the data source as either "Microsoft SQL Server Database File" or "Microsoft SQL Server", but get the same error.

Any tips on verifying SQL Srv Express is installed correctly? Any ideas on how to solve this problem?

Thanks in advance.

What happens if you set the source=(local)?