Enterprise Manager No Longer connects

Hi,
After an install of visual stiudo team 2005 beta 2 I can no longer connect
to any SQL Server in my enterprise manager (But showes SQL Server running)
and I get a connection error when I try to edit an SP from query analyzer.
this is the error I see in both places.
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
pack?
don
Silly question, but did you reboot your computer ? Did you uninstall all
further installation (perhaps another prerelase) there is an article about
that:
http://download.microsoft.com/downlo...ilCTPNotes.mht
http://www.sqlserver2005.de
HTH, Jens Suessmeyer.
"donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
> Hi,
> After an install of visual stiudo team 2005 beta 2 I can no longer connect
> to any SQL Server in my enterprise manager (But showes SQL Server running)
> and I get a connection error when I try to edit an SP from query analyzer.
> this is the error I see in both places.
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
> pack?
> --
> don
|||Hi,
I had no other pre-relase of VS 2005 on this system and have rebooted many
times since I had this problem.
"Jens Sü?meyer" wrote:

> Silly question, but did you reboot your computer ? Did you uninstall all
> further installation (perhaps another prerelase) there is an article about
> that:
> http://download.microsoft.com/downlo...ilCTPNotes.mht
> http://www.sqlserver2005.de
> HTH, Jens Suessmeyer.
> "donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
>
>

Enterprise Manager No Longer connects

Hi,
After an install of visual stiudo team 2005 beta 2 I can no longer connect
to any SQL Server in my enterprise manager (But showes SQL Server running)
and I get a connection error when I try to edit an SP from query analyzer.
this is the error I see in both places.
[Microsoft][ODBC Driver Manager] Data source name not found and no d
efault
driver specified
do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
pack?
donSilly question, but did you reboot your computer ? Did you uninstall all
further installation (perhaps another prerelase) there is an article about
that:
AprilCTPNotes.mht" target="_blank">http://download.microsoft.com/downl...rilCTPNotes.mht
http://www.sqlserver2005.de
HTH, Jens Suessmeyer.
"donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
> Hi,
> After an install of visual stiudo team 2005 beta 2 I can no longer connect
> to any SQL Server in my enterprise manager (But showes SQL Server running)
> and I get a connection error when I try to edit an SP from query analyzer.
> this is the error I see in both places.
> [Microsoft][ODBC Driver Manager] Data source name not found and no
default
> driver specified
> do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
> pack?
> --
> don|||Hi,
I had no other pre-relase of VS 2005 on this system and have rebooted many
times since I had this problem.
"Jens Sü?meyer" wrote:

> Silly question, but did you reboot your computer ? Did you uninstall all
> further installation (perhaps another prerelase) there is an article about
> that:
> 4/AprilCTPNotes.mht" target="_blank">http://download.microsoft.com/downl...rilCTPNotes.mht
> http://www.sqlserver2005.de
> HTH, Jens Suessmeyer.
> "donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
>
>

enterprise manager doesn't load

me bad - i installed visual studio (with sql express) then put the patches on
and sp2 for sql express.. then loaded the development version -- now
enterprise manager for sql 2005 won't load --
how do i make it - it doesn't give an error - just isn't there.
Do you mean Management Studio?
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.
|||yes - it turns out that you have to have IIS installed to allow the
management studio to work - seems stupid to me - but it is what it is.
"Aaron Bertrand [SQL Server MVP]" wrote:

> Do you mean Management Studio?
>
> "Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
> news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
>
>
|||> yes - it turns out that you have to have IIS installed to allow the
> management studio to work - seems stupid to me - but it is what it is.
Well, that's not true because I use Management Studio on several systems
without IIS configured. But maybe you tripped something else when you
installed IIS. <shrug>
|||You don't need to have IIS installed to run SQL Server 05 or any of it's
tools.
Your issue may be caused by conflicts with .NET framework 2.0. Try
uninstalling the 2.0 framework and then reinstalling the latest copies from
Microsoft.
Search MS knowledge base and you'll find that many users have had problems
with sql server 05 and .NET 2.0
Sincerely,
John K
Knowledgy Consulting, LLC
www.knowledgy.org
Atlanta's Business Intelligence and Knowledge Management Experts
"Sandy Ryan" <SandyRyan@.discussions.microsoft.com> wrote in message
news:0E4A4E64-3F11-44AF-A302-0041D7E59135@.microsoft.com...
> me bad - i installed visual studio (with sql express) then put the patches
> on
> and sp2 for sql express.. then loaded the development version -- now
> enterprise manager for sql 2005 won't load --
> how do i make it - it doesn't give an error - just isn't there.