RE: VSnet.ide cannot see local SQL db, but Enterprise Manager can

Hi Gary -
I now have the new instance connecting in VS. How? -In Enterprise Manager, I
added a new login for the new MSDE instance, choosing SQL Server
Authentication instead of Windows, then under DatabaseAccess tab, selected
databases and made this user "owner".

In VS, I unregistered my new instance of MSDE and then re-registered it, and
immediately it became available. I thought it was going to ask me for login
and pw, but it didn't.

Try as I might, I cannot get the connection to my SQLServer instance working.

Do you think I should try re-installing SQLServer, instead of reinstalling
SP2?
Gwenda

"gwenda" wrote:

> Hi Gary, I installed MSDE with the options suggested on the page you sent me
> to:
> Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR
> SA PASSWORD>
>
> I can register this instance in Enterprise Manager, but cannot connect to
> it from VS, altho a connection automatically appeared in VS.
>
> I just noticed that SQLServer no longer in my System Tray, altho its status
> is STARTED in Services Manager.
>
> I'm going to try reinstalling SP2 for Windows XP.
> Gwenda
>
> ""Gary Chang[MSFT]"" wrote:
>
> > Hi Nina,
> >
> > I suggest you first install the latst MDAC, if it doesn't work, then try
> > the MSDE package...
> >
> >
> > Thanks!
> >
> > Best regards,
> >
> > Gary Chang
> > Microsoft Community Support
> > --------------------
> > Get Secure! ¡§C www.microsoft.com/security
> > Register to Access MSDN Managed Newsgroups!
> > http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
> > &SD=msdn
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
.

Relevant Pages

  • RE: missing Enterprise Manager after installation of MSDE
    ... Including it in release files generated by InstallShield Developer presupposes that it comes with MSDE. ... Can someone confirm that it Enterprise Manager does come with MSDE? ... > Or does there exist another method, to set up the connection? ...
    (microsoft.public.sqlserver.msde)
  • Re: missing Enterprise Manager after installation of MSDE
    ... EM does *not* come with MSDE. ... You get a database without much interface. ... > I didnt think MSDE came with Enterprise Manager at all. ... >> Or does there exist another method, to set up the connection? ...
    (microsoft.public.sqlserver.msde)
  • RE: missing Enterprise Manager after installation of MSDE
    ... "Rudolf Hennemuth" wrote: ... > InstallShield Developer 8, which installs the MSDE. ... > But after executing the setup I cannot find the Enterprise Manager. ... > Or does there exist another method, to set up the connection? ...
    (microsoft.public.sqlserver.msde)
  • Crystal Deployment - Integrated Security
    ... MSDE, I don't use integrated security on any of these reports. ... settings for each report, this has worked time and time again. ... faced with the dreaded login dialog upon display of the report. ... connection settings upon running the report. ...
    (microsoft.public.dotnet.languages.csharp)
  • How to connect to msde on an other server?
    ... I tried to connect to a msde on an other server via the enterprise manager. ... Unable to establish connection. ... Server unknown or access denied! ...
    (microsoft.public.sqlserver.msde)