Cant Find MS SQL SERVER in DataSource

hi..

i am using C# eXpress edition 2005..and i have downloaded the SQL Express Edition..

the problem is that i cant find "Microsoft SQL Server" in data sources..

there are only two items listed

-> Microsoft Access DataBase File

-> Microsoft SQL Server Database File

Where do i get "Microsoft SQL Server" ?

hi,

Visual Studio Express editions designers are "designed" to use only "file based" connections and thus User Instances features... you can connect to the "traditional" SQLExpress engine, but only by code and not via the designers..

regards

|||thankXX a lot mate..

Can't create new datasource

I installed analysis services this last week and now when I try to add a new
data source in reporting services I get an error that says The OLE DB
provider SQLOLEDB has not been installed or is not valid. Do you wan tto
reset the connect string? It has a cancel and an OK button but no matter
which one you push it does nothing. It was working before I did the install
and when I did the install I just took the defaults and loaded up the latest
service pack. Any suggestions?
Thanks,
MelissaMy guess is that MDAC is messed up. One thing you might try is re-installing
the service pack for SQL Server. Either that or try re-installing the
appropriate version of MDAC.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Melissa" <Melissa@.discussions.microsoft.com> wrote in message
news:70F08879-5220-4681-9E31-852F7D542D4D@.microsoft.com...
> I installed analysis services this last week and now when I try to add a
new
> data source in reporting services I get an error that says The OLE DB
> provider SQLOLEDB has not been installed or is not valid. Do you wan tto
> reset the connect string? It has a cancel and an OK button but no matter
> which one you push it does nothing. It was working before I did the
install
> and when I did the install I just took the defaults and loaded up the
latest
> service pack. Any suggestions?
> Thanks,
> Melissa