MSDE 2000 connectivity problem

Hi,
I have installed MSDE 2000 into my desktop machine.I can
connect from other machines to my desktop and accessing
databases using Query Analyser, Enterperise manager,
Profiler.but I didn't connect from ASP.NET application
using as "connectionstring".
Earlier it was worked.now its not working.
Send me your valuable reply ASAP.
Thanks and regards,
RafiqHow does your connection string look like?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rafiq" <anonymous@.discussions.microsoft.com> wrote in message
news:088801c3a9ab$02032c50$a401280a@.phx.gbl...
> Hi,
> I have installed MSDE 2000 into my desktop machine.I can
> connect from other machines to my desktop and accessing
> databases using Query Analyser, Enterperise manager,
> Profiler.but I didn't connect from ASP.NET application
> using as "connectionstring".
> Earlier it was worked.now its not working.
> Send me your valuable reply ASAP.
> Thanks and regards,
> Rafiq

MSDE

How does MSDE handle data mangement? Does it come with sql analyser or some sort of database manager?
Thanks.I don't believe it comes with anything. I think the general idea is that you develop it using the tools you mention and then ship the MSDE like you would an runtime Access database.|||pkr hit it on the nose. If you are using MSDE in conjunction with ASP.NET Web Matrix, you would use Web Matrix's built-in database management tool. If you are using MSDE with Microsoft Access you would use Accesss for the database management.

Some other options for managing MSDE:
-- using the built-in OSQL command line utility:HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

--ASP.Net EnterpriseManager

--Web Data Administrator

--ASP.NET Web Matrix includes a database management tool

-- SQL Enterprise Manager and Query Analyzer -- the SQL Server 2000 client tools (note that there are licensing requirements)

-- there are other 3rd party tools such as "MSDE Manager" and "MyLittleAdmin"

Terri|||My main need is maintaining data tables, stored procs, triggers, udf etc...
What tool would allow me to edit stored procs, triggers, udf specifically?
Thanks again.|||You would have to investigate that to see which tool met your needs.

To the best of my knowledge, only SQL Enterprise Manager and Query Analyzer would enable you to everything you are looking for.

Terri|||Query Analyzer and Enterprise Manager are really what you're looking for. I know you can now buy SQL Server Developer Edition for $49 and it comes with both Query Analyzer and Enterprise Manager.

If you don't want to spend the money you can go with the open source, Query Analyzer like tool called SqlBuddy. Here's the link, http://sqlbuddy.sourceforge.net/.

Good luck.