SQLExpress cant see as Microsoft SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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.
 
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 said:
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]
- (e-mail address removed)

andrewcw said:
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
Click to expand...
Click to expand...
 
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 said:
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]
- (e-mail address removed)

andrewcw said:
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
Click to expand...
Click to expand...
 
Back
Top