SQLExpress cant see as Microsoft SQL Server

[andrewcw]

I am trying to use the NorthWind database or anything with SQLEXPRESS on VS
2005 RC. I can see SQLExpress started with the tool SQL Server Configuration
Manager. But when i select DataBase | New Connection | Data Source |
Microsoft SQL Server - I see other SQL servers but not SQLExpress. What
should I be doing... Thanks
--
Andrew

[Nicholas Paldino [.NET/C# MVP]]

Andrew,

The data source you want to use is ".\SQLExpress". The "." indicates
the local machine, while SQLExpress is the named instance on that machine.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"andrewcw" <an******@acw.com> wrote in message
news:5B**********************************@microsof t.com...

I am trying to use the NorthWind database or anything with SQLEXPRESS on VS
2005 RC. I can see SQLExpress started with the tool SQL Server
Configuration
Manager. But when i select DataBase | New Connection | Data Source |
Microsoft SQL Server - I see other SQL servers but not SQLExpress. What
should I be doing... Thanks
--
Andrew

[andrewcw]

It does not show up in the pull down list when I get to Add a Connection (
avail servers ). That just doesnt seem right - but I tried typing it in
anyway to see what would explode. I just get Master,Model,msdbdata ...> MSDB
but no northwind. So maybe there is some step - that loads some ?? northwind
MDF file ?? which I dont seem to have --- or recognize or know how to make
SQLExpress load. Any more ideas ??
Andrew
"Nicholas Paldino [.NET/C# MVP]" wrote:

Andrew,

The data source you want to use is ".\SQLExpress". The "." indicates
the local machine, while SQLExpress is the named instance on that machine.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"andrewcw" <an******@acw.com> wrote in message
news:5B**********************************@microsof t.com...

I am trying to use the NorthWind database or anything with SQLEXPRESS on VS
2005 RC. I can see SQLExpress started with the tool SQL Server
Configuration
Manager. But when i select DataBase | New Connection | Data Source |
Microsoft SQL Server - I see other SQL servers but not SQLExpress. What
should I be doing... Thanks
--
Andrew

[andrewcw]

I found this on a wrox site - apparently SQLExpress does not install the data
bases pub or northwind.

osql -S(local)\SQLExpress -E -i"c:\program files\microsoft SQl
Server\90\Tools\binn\instNWIND.sql"

BUT in my directory there are NO *.sql ... just other files. How can I get
them ??
--
Andrew
"Nicholas Paldino [.NET/C# MVP]" wrote:

Andrew,

The data source you want to use is ".\SQLExpress". The "." indicates
the local machine, while SQLExpress is the named instance on that machine.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"andrewcw" <an******@acw.com> wrote in message
news:5B**********************************@microsof t.com...

I am trying to use the NorthWind database or anything with SQLEXPRESS on VS
2005 RC. I can see SQLExpress started with the tool SQL Server
Configuration
Manager. But when i select DataBase | New Connection | Data Source |
Microsoft SQL Server - I see other SQL servers but not SQLExpress. What
should I be doing... Thanks
--
Andrew