Re: interface tools for MSDE

From: Jason (jafinck_at_pplweb.com)
Date: 09/17/03 

Date: Wed, 17 Sep 2003 08:26:23 -0700

I can connect to SQLServer instances using query
analyser..but when i try to get to a msde instance i get
this
Server Msg 17, Level 16, state 1
micrcosoft odbc SQL Server Driver DBNETLIB SQL Server does
not exist or access denied

>-----Original Message-----
>Yes you can use Enterprise Manager to manage an MSDE
>instance.
>For the connection issue, make sure it's not just a login
>timeout issue. You can change this setting in Enterprise
>Manager - go to the menu to Tools, to Options and on the
>Advanced Tab, there is a login timeout setting. Try
setting
>it to something greater than the default 4 secs.
>Can you connect to MSDE using Query Analyzer?
>
>-Sue
>
>On Tue, 16 Sep 2003 08:01:45 -0700, "Jason"
><jafinck@pplweb.com> wrote:
>
>>I read that MSDE has no interface tools, but that you
can
>>use SQLServer interface tools with it if licenced.
>>
>>So I need some clarifaction.
>>Does this mean that I can use SQL Server Enterprise
>>Manager configure an istallation of MSDE?
>>
>>I haven't had any luck getting the intallation of MSDE
to
>>connect with SS Ent Ed. I can register it..but when I
go
>>to log in it keeps saying that the database isn't
running
>>even though I know it is.
>>
>>Am i going down the wrong track with this?
>>
>>Thanks
>>-jason
>
>.
>

Relevant Pages

  • Re: MSAccess DB as a linked server - The provider ran out of memory
    ... Access database that has large BLOBs in it by using a linked server ... Is there some reason you can't query the Access database ... I am guessing that the reason MSDE is ...
    (microsoft.public.sqlserver.msde)
  • Re: Help with Master/Detail UI in ADPs
    ... No, MSDE is not limited to 5 concurrent users, it is limited to 5 concurrent ... The users whose connection to the server is idle at any moment don't count. ... and from the local temp table to the Detail table on the server for rows ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... how SQLServer-Browser resolves portnumber of MSDE named instance. ... Windows 2003 Server ships with SSEE preinstalled (for ... port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... Upgrade MSDE to SP4: not ok. ... Windows 2003 Server ships with SSEE preinstalled (for ... > port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: MSDE and IIS - Web Hosting
    ... sites getting over 3M hits per month and MOST of those hits were on ... when going to Windows 2003 Server and running very SMALL sites using ... coding for MSDE instead of Access because it's really our only option. ... but not as well as SQL Server who knows. ...
    (microsoft.public.sqlserver.msde)
Quantcast