Re: MSDE login problem - URGENT.

Tech-Archive recommends: Speed Up your PC by fixing your registry

"Aykut Canturk" <aykut.canturk@xxxxxxxxxxxxxxx> wrote in message
news:Oi7lltbpGHA.4408@xxxxxxxxxxxxxxxxxxxxxxx

I cannot connect to MSDE with this connectionstring:
Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User
ID=sa;Initial Catalog=uruntakip;Data Source=server

it happens after I started to use MSDE2000 SP3. I use VB 6.0.

Enterprise manager on my notebook can connect to MSDE.

And the server is registered in EM with sa / 123 as opposed to using Windows
Authentication?

But Icannot connect
from my application using above connection string. nor locally on the
computer with MSDE.

You mean you cannot connect with Enterprise Manager locally but you can
connect remotely (your laptop)?

PS: Also when I use ADO conponent of VB, It can succesfully sonects to
MSDE.
After I build the connection string, I use it in my VB code, and still
gettind the same error message.:
-2147217843 Login failed for user 'sa'.

In MSDE setup, Use the following ini file:

[Options]
SAPWD=123
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0

In Enterprise Manager, right-click on the registered server (from your
laptop, I guess) and go into Properties, then select the Security tab. Make
absolutely certain that the authentication mode is SQL Server and Windows.


.

Relevant Pages

  • Re: SQL Mobile and MSDE
    ... The only fully supported Oracle synchronization solution I know of is use to Oracle Lite on the device. ... with RDA and sync the laptop to the server. ... I' am trying to determine if i should use CF 1.x with SQL CE 2.0 and MSDE for a new application or CF 2.0 with SQL Mobile and MSDE. ... I was told that the solution MUST use MSDE since the client already has an application using this but with laptop computers. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Memory Usage / Hog
    ... Since this is MSDE, we don't have Enterprise Manager. ... sql server will grow to use whatever memory is ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Replication with MSDE
    ... If you have the Enterprise Edition tools (i.e. Enterprise Manager) you can ... However, when you put MSDE on other machines, you will ultimately need to ... run the distributor script for that machine and then the publication ... > SQL Server 2000 Enterise installed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Permission denied error 2nd Post
    ... developed to allow many SQL Server and MSDE design and administration tasks ... > New user of SQL ... > I was able to find a trial version of the Enterprise Manager. ... > One false move and your server and data could be toast. ...
    (microsoft.public.sqlserver.msde)
  • Re: Permission denied error 2nd Post
    ... developed to allow many SQL Server and MSDE design and administration tasks ... > New user of SQL ... > I was able to find a trial version of the Enterprise Manager. ... > One false move and your server and data could be toast. ...
    (microsoft.public.sqlserver.tools)