Re: MSDE connection problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 13:09:29 +0100

hi,
"Trond" <trond_wahlstrom@hotmail.com> ha scritto nel messaggio
news:dcddc680.0411020014.323051bd@posting.google.com
> I'm new to MSDE and having a problem connection remotely to my MSDE
> instance.
>
> Locally this connection string works well:
>
> value="server=ne14;uid=Support;pwd=Support;database=Support"
>
> But when I move my web site to a remote server this will not work. But
> it do work if I use SQL Server.
> I use mixed mode authentication on the MSDE instance.
>
> Any suggestions someone?
>
> Thanks a lot in advance!

can you please post the exception you are reported?

> value="server=ne14;uid=Support;pwd=Support;database=Support"
"Support" is not very understandable... standards connection strings are
listed at http://www.able-consulting.com/ADO_Conn.htm 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.9.1  -  DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • Re: MSDE questions for SharePoint and Project Server
    ... "xfile" ha scritto nel messaggio ... I do think SharePoint installs it' own instance of a modified MSDE ... your own strong password for the special SQL Server account known as "sa", ... if you want to set a strong password for your "sa" login, ...
    (microsoft.public.sqlserver.msde)
  • Re: reporting..
    ... "dev_kh" ha scritto nel messaggio ... > Do you mean making sure that the MSDE is set to startup automatically.. ... > but now when the service is on the central machine then will anything ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: How can I secure a MSDE database for users who have SQL Server?
    ... "dev" ha scritto nel messaggio ... I am using my own instance of msde. ... >administrator login etc..Andrea pointed out that that can cause problems in ... a SQL Server sysadmin is god in SQL Server... ...
    (microsoft.public.sqlserver.msde)
  • Re: OSQL is Unable to see SQL Server and MSDE 2000 on the same machine
    ... "Surya Yadav" ha scritto nel messaggio ... > I have installed SQL Server and MSDE 2000 on my laptop under Windows XP. ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: Connection string
    ... Connection string is sent from client application, it is not stored in MSDE ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.connect)