MSDE SQL Service Manager is not installed

I am installing MSDE from the SQL Server 2000 CD on a W2K
Pro environment. No errors in installation. There is no
service installed to start SQL Server. Any ideas?
hi Rick,
"Rick" <rsexauer@.avayle.com> ha scritto nel messaggio
news:cde901c48a55$bb29d270$a601280a@.phx.gbl...
> I am installing MSDE from the SQL Server 2000 CD on a W2K
> Pro environment. No errors in installation. There is no
> service installed to start SQL Server. Any ideas?
actually, Service Manager should be present in the tray area...
can you please confirm, browsing the installed services in the control
panel->services applet that MSDE is properly installed?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Service Manager on XP Pro SP2

I recently installed MSDE 2K on a Windows XP SP2 system. Everything appears
to be working fine, with the exception of the service manager. For some
reason, it will not find the system on the local network and will not
connect to it if I type the name in the server name area. Is this normal or
am I just missing something? Thanks in advance.
hi David,
"David Young" <cdyoung@.uta.edu> ha scritto nel messaggio
news:eBToEMg3EHA.3840@.tk2msftngp13.phx.gbl
> I recently installed MSDE 2K on a Windows XP SP2 system. Everything
> appears to be working fine, with the exception of the service
> manager. For some reason, it will not find the system on the local
> network and will not connect to it if I type the name in the server
> name area. Is this normal or am I just missing something? Thanks in
> advance.
actually, for local instances connections, WinXP sp2 should not be a
problem, but only for remote connections :D
as regard the Service Manager not showing the instance name, this is a known
issue when network protocols are disabled (default setting) as you can see
in http://support.microsoft.com/default...b;EN-US;814132
as regard directly typing in the instance name... did you provide the name
in the ComputerName\InstanceName format ( or just (local)\InstanceName) ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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

MSDE service manager just stops???

HI every one
I hope i dont sound too dumb here but i am having some problems with MSDE
I have it installed on my local machine and SQL server 2000 is also installed as i use the Enterprise manager to work on my database.
I dont have server software as my OS is win XP pro.
The problem i have is that after a while the MSDE service manager just stops and i cant get it to restart. and the only way is to uninstall it and reinstall.
i have tried to get the 2000 MSDE installed but i seem to not be able to get that working.
It is frustrating as i am developing a databse at home for a client (work experience) but i spend so much time keeping my shonky system running i loose time in developing.
is there somewhere i can learn to set my system up so i can develop a sql DB at home, or am i flogging a dead horsse.
any help greatly appreciated
Greg
Have you looked in the event log for errors?
"GREGO" wrote:

> HI every one
> I hope i dont sound too dumb here but i am having some problems with MSDE
> I have it installed on my local machine and SQL server 2000 is also installed as i use the Enterprise manager to work on my database.
> I dont have server software as my OS is win XP pro.
> The problem i have is that after a while the MSDE service manager just stops and i cant get it to restart. and the only way is to uninstall it and reinstall.
> i have tried to get the 2000 MSDE installed but i seem to not be able to get that working.
> It is frustrating as i am developing a databse at home for a client (work experience) but i spend so much time keeping my shonky system running i loose time in developing.
> is there somewhere i can learn to set my system up so i can develop a sql DB at home, or am i flogging a dead horsse.
> any help greatly appreciated
> Greg
|||Do you mean the windows event log?
i cant access the SQL server log as it is shut down and i cant access it
regards
greg
"Nigel Rivett" wrote:
[vbcol=seagreen]
> Have you looked in the event log for errors?
> "GREGO" wrote:
|||The SQL Server log is just a text file under the SQL Server directory,
normally in the LOG directory. Load the most recent one into Notepad and see
if there are any errors.
Jim
"GREGO" <GREGO@.discussions.microsoft.com> wrote in message
news:B074205A-A3A6-48DB-8EBB-350E3118AFDE@.microsoft.com...[vbcol=seagreen]
> Do you mean the windows event log?
> i cant access the SQL server log as it is shut down and i cant access it
> regards
> greg
> "Nigel Rivett" wrote:
MSDE[vbcol=seagreen]
installed as i use the Enterprise manager to work on my database.[vbcol=seagreen]
stops and i cant get it to restart. and the only way is to uninstall it and
reinstall.[vbcol=seagreen]
to get that working.[vbcol=seagreen]
(work experience) but i spend so much time keeping my shonky system
running i loose time in developing.[vbcol=seagreen]
sql DB at home, or am i flogging a dead horsse.[vbcol=seagreen]

MSDE Seems to Install - Service Manager Loads - No Connection

Hi,
I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
..net Standard Edition and tried to reinstall MSDE. The installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I have since uninstalled
Developer Edition to no avail. I am running Windows XP Pro.
Regards
Barry-Jon
hi Barry-Jon,
Microsoft wrote:
> Hi,
> I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
> Edition. I then found I could not use Developer Edition with Visual
> Basic .net Standard Edition and tried to reinstall MSDE. The
> installation seems to go fine but when the Service Manager loads is
> tells me "Not Connected - \\" no servers are in the Server drop-down
> and no services are listed in the Services drop-down. I am very new
> to all of this and would very much appreciate any help/advice you
> could offer. I have since uninstalled Developer Edition to no avail.
> I am running Windows XP Pro.
> Regards
> Barry-Jon
please have a look at
http://support.microsoft.com/default...b;EN-US;814132 ...
you can modify this behaviour enabling the desired/required network protocol
by running the Server Network Utility (svrnetcn.exe)...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Microsoft" <barryjonoconnell_spam_no@.yahoo.co.uk> wrote in message
news:ucCLTwKEFHA.1188@.tk2msftngp13.phx.gbl...
> Hi,
> I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
> Edition. I then found I could not use Developer Edition with Visual Basic
> .net Standard Edition and tried to reinstall MSDE. The installation seems
> to go fine but when the Service Manager loads is tells me "Not Connected -
> \\" no servers are in the Server drop-down and no services are listed in
> the Services drop-down. I am very new to all of this and would very much
> appreciate any help/advice you could offer. I have since uninstalled
> Developer Edition to no avail. I am running Windows XP Pro.
> Regards
> Barry-Jon
I posted this in the vb group as well, but just in case...
I'm not sure you're doing anything wrong, but perhaps the instructions we
use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003
will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior
MSDE installation attempts hanging around. The place to check is: C:\Program
Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL
Server, delete it and its contents!
2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your
MSDE download is). This step will extract the contents of the file to a
designated folder. Make a note of the destination folder. You'll need it
later. This step does not install MSDE (although the dialogs seem to hint
that it does)!
4. Navigate to the folder you created in Step 2. In that folder, you will
find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing
SETUP.EXE will install MSDE.
5. To execute SETUP.EXE correctly, you must supply an instance name and a
system administrator password as part of the command: i.e. the command must
be:
SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
where yourSAPassword is your actual system administrator password. This
password is needed only to install MDSE, not to use it. Access to MSDE is
controlled by normal "NT Security" which should allow users access based on
network logon and password. It is very important the the INSTANCENAME
parameter be NetSDK, as this name will enable you to generate the sample
databases automatically instead of having to run SQL scripts from the
command line.
6. Once installation is complete, you must reboot the PC before you will
see MSDE. After the reboot, you should see the MSDE icon in SysTray.
7. You now must execute the file: ConfigSamples.exe to configure sample
applications and MSDE system databases. This step will also create user
databases in the following location: C:\Program Files\Microsoft SQL
Server\MSSQL\Data.
</quote>
If you have trouble locating the ConfigSamples.exe, it's a small file
(56k) and I can send it to your email if needed.
Hope this helps.
Peter [MVP Visual Developer]
Jack of all trades, master of none.
|||Thanks Peter - that looks pretty much like what I did in the end. Saved
your post in case I ever forget :-)
"Peter van der Goes" <p_vandergoes@.toadstool.u> wrote in message
news:edfqWhQEFHA.3592@.TK2MSFTNGP15.phx.gbl...
> "Microsoft" <barryjonoconnell_spam_no@.yahoo.co.uk> wrote in message
> news:ucCLTwKEFHA.1188@.tk2msftngp13.phx.gbl...
> I posted this in the vb group as well, but just in case...
> I'm not sure you're doing anything wrong, but perhaps the instructions we
> use for classroom/lab installs of MSDE to work with Visual Studio .NET
> 2003 will be helpful:
> <quote>
> 1. Before you begin, check the PC to ensure there are no remnants of
> prior MSDE installation attempts hanging around. The place to check is:
> C:\Program Files\Microsoft SQL Server. If you locate a folder named
> Microsoft SQL Server, delete it and its contents!
>
> 2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your
> MSDE download is). This step will extract the contents of the file to a
> designated folder. Make a note of the destination folder. You'll need it
> later. This step does not install MSDE (although the dialogs seem to hint
> that it does)!
>
> 4. Navigate to the folder you created in Step 2. In that folder, you will
> find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing
> SETUP.EXE will install MSDE.
>
> 5. To execute SETUP.EXE correctly, you must supply an instance name and a
> system administrator password as part of the command: i.e. the command
> must be:
>
> SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
>
> where yourSAPassword is your actual system administrator password. This
> password is needed only to install MDSE, not to use it. Access to MSDE is
> controlled by normal "NT Security" which should allow users access based
> on network logon and password. It is very important the the INSTANCENAME
> parameter be NetSDK, as this name will enable you to generate the sample
> databases automatically instead of having to run SQL scripts from the
> command line.
>
> 6. Once installation is complete, you must reboot the PC before you will
> see MSDE. After the reboot, you should see the MSDE icon in SysTray.
>
> 7. You now must execute the file: ConfigSamples.exe to configure sample
> applications and MSDE system databases. This step will also create user
> databases in the following location: C:\Program Files\Microsoft SQL
> Server\MSSQL\Data.
> </quote>
>
> If you have trouble locating the ConfigSamples.exe, it's a small file
> (56k) and I can send it to your email if needed.
>
> Hope this helps.
>
> --
> Peter [MVP Visual Developer]
> Jack of all trades, master of none.
>

MSDE prototyping

I haven't used MSDE yet. Does it run with an Enterprise Manager & Sql analyser interface?
I'm working on an asp.net vb project using sql2000. Users request me to create a protype for their review and training use. Can I deploy my project with only dlls forthe front end and an MSDE backend created from a script of the original Sql2000 database? Is there any potential discrepacy or problem with my prototyping plan? How can I copy my original database from sql2000 to msde?

Thanks for any help.Yes, Enterprise Manager and Query Analyzer can be interfaces to MSDE.

Yes, you can use MSDE as the back end for development but deploy to a SQL Server 2000 database.

When I mean "can" I mean "technically possible". I am not 100% sure of "legally possible". The licensing information for MSDE is fairly confusion, IMO.

The SQL Server 2000 Developer's edition is made specifically for situations like yours. It is $49.95 US and would give you the EM and QA tools plus the database. SeeDevelopment Edition Licensing.

I think the best way to transfer the data and schema would be to restore a backup.

Terri

MSDE on SBS2003

Hi, I'm about going to be using a database on the MSDE installed with
Windows SBS 2003. The problem is that in the service manager there are no
servers or services listed. Do I have to reinstall? Thanks.
Message posted via http://www.droptable.com
Supposed to be based on a security update.
"
Known issue, it doesn't matter. SQL/MSDE is actually running, and if you
want, you can delete the link to the SQL Manager in Start Menu -> All
Programs -> Startup, if you don't want to see the icon"
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Ben Harrison via droptable.com" <forum@.nospam.droptable.com> schrieb im
Newsbeitrag news:fb473d43c11745b68136ae18440f2383@.droptable.co m...
> Hi, I'm about going to be using a database on the MSDE installed with
> Windows SBS 2003. The problem is that in the service manager there are no
> servers or services listed. Do I have to reinstall? Thanks.
> --
> Message posted via http://www.droptable.com
|||hi Ben,
Ben Harrison via droptable.com wrote:
> Hi, I'm about going to be using a database on the MSDE installed with
> Windows SBS 2003. The problem is that in the service manager there
> are no servers or services listed. Do I have to reinstall? Thanks.
MSDE installs by default disabling network protocols and remote connections,
and this can prevent instances to be enlisted in the service manager combo,
as described in
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

msde not starting

Hallo Guys

I am running MSDE with Sage Taxation Suite v10. However when I try to start MSDE with SQL Server Service Manager, it will not start, it tries to start, but then stops.

Why might this be happening and is there a possible fix for this problem.

Thank you

Pls provide the error log details and event viewer details as it will be easy to trouble shoot the problem

MSDE manager?

Hi there,
Does anyone know of any good software I can use for managing MSDE database?
Regards/
Jtanfor msde tools chcek the following :
shusheng - has a nice asp solutions that works quite well.
- look on the web for a download site
DbaMGR2K - a simple but nice db manager, the links is :
www.asql.biz/dbamgr.shmt

I'll think these tools should get you on your way!

Regards|||Check out dbWidget by Yazoo Software at
http://www.yazoosoft.com

dbWidget is a client database tool that works with MSDE,
SQL Server, Sybase, MySQL, and Oracle databases, all from
one product.

info@.yazoosoft.com|||A free tool can be found here:

http://www.aspenterprisemanager.com/

Anyway should be a lot of this kind of tool here:

http://www.sourceforge.net

MSDE Manager Toolkit

Where can I download a Tool for manager MSDE Data Bases?
Hi,
What I understand from your question is that you are looking for a front
end for MSDE 2000 to manage your databases.
You can download SQL Server Web Data Administrator from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
If you were looking for MSDE Deployment toolkit, a plug-in to Microsoft
Visual Studio that automates the process of creating an integrated package
with both the application and the MSDE database, it can be downloaded from
http://www.microsoft.com/downloads/d...403-c4ba-4d98-
bb0b-2c9d6414071f&DisplayLang=en
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Marley,
We've got a free personal one at our site, plus ocx's and .net user
controls, etc. for MSDE management.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Marley" <m_noleto@.hotmail.com> wrote in message
news:38E9685E-126D-48FC-8BF8-2EB88A7A04CE@.microsoft.com...
> Where can I download a Tool for manager MSDE Data Bases?
|||> Where can I download a Tool for manager MSDE Data Bases?
You can try myLittleAdmin (http://www.mylittletools.net/mla_sql)
You will find a live demo here
http://www.mylittletools.net/livedemo/mla_sql
and you can download a free trial version
((http://www.mylittletools.net/mla_sql)
You will find other products here :
http://www.microsoft.com/sql/msde/partners/default.asp
hth
el.c.

msde manager

I have installed msde on W2K pro and I am looking for an msde manager, something similar to sql enterprise manager. Does anyone have any suggestions?There are several tools you can use to administer MSDE:

ASP.NET Enterprise Manager, an open source SQL Server and MSDE management tool.

ASP.NET WebMatrix (which includes a database management tool) from this web site (click on the Web Matrix tab at the top of this page).

Microsoft's Web Data Administrator is a free web-based MSDE management program written using C# and ASP.NET, and includes source code.

You can also access MSDE using Access.

Don|||Thanks for the info donkiely! Just what I needed|||The Microsoft's Web Data Administrator MSDE Manager has moved it's URL. you get a redirect at the link provided by donkiely. however, in case that link redirect gets taken away the new URL is: http://msdn.microsoft.com/library/default.asp?url=/downloads/list/aspnet.asp

Farewell,
Quilnux|||Got it! Thank You!

MSDE Management Tools

Hi all
Has anyone used the MSDE Manager Program from Vale Software? I am chasing
any reviews, thoughts and praise/criticism of the software. I have the
trial version and it appears to be ok, just wondering if there are any known
bugs etc.
Also, are there many other SQL Server/MSDE management tools (similar to
Enterprise Manager) on the market. I am developing some off the shelf
software and was hoping to make use of MSDE to lower costs (current software
version implemented in Access but looking for a client/server
implementation). Unfortunately due to the nature of our clients we need
something nice to manage the database/s, specifically a tool that includes
the maintenance plan wizard/feature of Enterprise Manager.> Also, are there many other SQL Server/MSDE management tools (similar to
> Enterprise Manager) on the market.
http://www.aspfaq.com/2442

MSDE Maintanence Problem

I am trying to create a maintanence plan for a MSDE database using
Enterprise Manager. Under my MSDE SQL Server/Management, Database
Maintenance Plans icon does not show up. In my three other SQL Servers (1
MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
database and choose Maintenance Plans under all tasks. I am doing this via
an Enterprise Manage remotely. When I physically view the Enterprise
Manager I can setup Maintenance Plans however the plans do not work. When I
view the properties, none of the schedule shwos up and I get an error. Is
my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
Thanks
hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
> I am trying to create a maintanence plan for a MSDE database using
> Enterprise Manager. Under my MSDE SQL Server/Management, Database
> Maintenance Plans icon does not show up. In my three other SQL Servers (1
> MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
> database and choose Maintenance Plans under all tasks. I am doing this via
> an Enterprise Manage remotely. When I physically view the Enterprise
> Manager I can setup Maintenance Plans however the plans do not work. When
I
> view the properties, none of the schedule shwos up and I get an error. Is
> my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
> Thanks
>
that's weird... never heard about :-(
but, FWIW, you are not allowed to manage MSDE instance with the regular SQL
Server client tools like Enterprise Manager and/or Query Analyzer...
you shoul'd resort on third party tools..
a list of some tools can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
licenses for SQL Server.
Thanks
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2m81boFjj6hjU1@.uni-berlin.de...[vbcol=seagreen]
> hi George,
> "George" <george@.noemail.com> ha scritto nel messaggio
> news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
(1[vbcol=seagreen]
via[vbcol=seagreen]
When[vbcol=seagreen]
> I
Is
> that's weird... never heard about :-(
> but, FWIW, you are not allowed to manage MSDE instance with the regular
SQL
> Server client tools like Enterprise Manager and/or Query Analyzer...
> you shoul'd resort on third party tools..
> a list of some tools can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:Od%23dg7$bEHA.384@.TK2MSFTNGP10.phx.gbl...
> Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
> licenses for SQL Server.
there's an open thread about it in Microsoft it self =;-D
a little extract of such a "flame" is a position by a Microsoft
representative like
"...
The tricky part here is the bit about using MSDE in conjunction with a
properly licensed copy of SQL Server 2000 and the fact that we don't go
into detail about exactly what that means. XXXX (name) has stated many times
in
the private SQL MVP newsgroup that that requires a bunch of lawyers and
a white board. It's almost never the case. In my opinion, we simply need
to tell folks that right now you cannot do it with MS tools at them
moment, here's a bunch of 3rd-party tools you can look at, and we'll be
providing tools with SQL Express and here's how you get a sneak preview
of that...
..."
dev/test environments can be managed with SQL Server Dev edition at will, as
test requires MSDE management too, but production enviroments seem not to be
legitimated...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE login problem

After installing MSDE 2000 in mixed mode local access worked fine.
Accessing through network with enterprice manager at first didn't work.
Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties.
But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.

Anyone know why?

thanks in advanceAfter that login by SQL user and password is denied after restart local MSDE machine

With this I mean access from other machines on the network. Local login is working ok.|||Solution found!

Install MSDE again with DISABLENETWORKPROTOCOLS=0.
Changing it afterwards with SQL Server enterprice manager doesn't work.

just for those who are having the same problem

MSDE instance registration in Enterprise Manager

Hi All,
I'm trying to register an instance of MSDE on a remote machine using EM on my desktop. The remote machine has 2
named instances of MSDE running. I am able to register 1 instance with no problems. I had to register it using
"RemoteServer1\InstanceName" rather than just the remote machines name.
For the life of me I can not get the other instance to register. I get the "SQL Server does not exist or access
denied" error. I've tried just registering the 2nd instance without the first with the same results. I can see
no difference in the way either of the 2 instances were set up or in their properties. I am a machine admin on
the remote machine and am connecting using Windows Auth.
What am I missing and how can I register that 2nd instance?
Thank you.
gdr
Gary D. Rezek
University Networking Systems and Services
South Dakota State University
hi Gary,
Gary D. Rezek wrote:
> Hi All,
> I'm trying to register an instance of MSDE on a remote machine using
> EM on my desktop. The remote machine has 2 named instances of MSDE
> running. I am able to register 1 instance with no problems. I had to
> register it using "RemoteServer1\InstanceName" rather than just the
> remote machines name.
this is normal as a named instance full qualified name is
ComputerName\InstanceName...

> For the life of me I can not get the other instance to register. I
> get the "SQL Server does not exist or access denied" error. I've
> tried just registering the 2nd instance without the first with the
> same results. I can see no difference in the way either of the 2
> instances were set up or in their properties. I am a machine admin on
> the remote machine and am connecting using Windows Auth. What am I
> missing and how can I register that 2nd instance?
at least 1 difference must be present... the name... MSDE/SQL Server 2000
can be installed as a default instance or a named instance... but only a
default instance can be present, wit up to other 15 named instances per
computer...
as you already saw, a default instance is available as ComputerName, where a
named instance will be as ComputerName\InstanceName...
you can inspect your (remote) services for MSSQLSERVER and
MSSQL$InstanceName to see what is going on...
MSDE installs by default disabling network protocols, thus not allowing
remote connections... please verify using the Server Network Utiliy
(svrnetcn.exe) that the "failing" instance has enabled network protocols...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Thanks for your answer. It eventually led me to http://tinyurl.com/8q95s this post. In that post I found this
quote...
"You need to look for a line in the error log which states:
"SQL server listening on TCP, Shared Memory, Named Pipes.
"If you only have Shared Memory on this list, then only local connections are allowed."
In the instance I have been trying to connect, Shared Memory is the only thing listed in the errorlog, so no
TCP/IP or Named Pipes. I asked the individual who is responsible for the application which created this instance
of MSDE (and also the one who asked me WHY can't he connect through EM), I learned that this is the way it
should be. :^/ I've worked with MSDE very, very little, but I still should have looked at the ErrorLog to
begin with.
Thank you very much for your help
gdr
Gary D. Rezek
University Networking Systems and Services
South Dakota State University
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:3jg2rjFpnmhnU1@.individual.net...
> hi Gary,
> Gary D. Rezek wrote:
> this is normal as a named instance full qualified name is ComputerName\InstanceName...
>
> at least 1 difference must be present... the name... MSDE/SQL Server 2000 can be installed as a default
> instance or a named instance... but only a default instance can be present, wit up to other 15 named instances
> per computer...
> as you already saw, a default instance is available as ComputerName, where a named instance will be as
> ComputerName\InstanceName...
> you can inspect your (remote) services for MSSQLSERVER and MSSQL$InstanceName to see what is going on...
> MSDE installs by default disabling network protocols, thus not allowing remote connections... please verify
> using the Server Network Utiliy (svrnetcn.exe) that the "failing" instance has enabled network protocols...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface)
> -- remove DMO to reply
>
|||h Gary,
Gary D. Rezek wrote:
> Hi Andrea,
> Thanks for your answer. It eventually led me to
> http://tinyurl.com/8q95s this post. In that post I found this quote...
> "You need to look for a line in the error log which states:
> "SQL server listening on TCP, Shared Memory, Named Pipes.
> "If you only have Shared Memory on this list, then only local
> connections are allowed."
you always have to verify (on the server using Server Network Utility
[svrnetcn.exe] and on the client using Client Network Utility
[cliconfg.exe]) that a common network protocol is available for the client
and the server to dialog...

> In the instance I have been trying to connect, Shared Memory is the
> only thing listed in the errorlog, so no TCP/IP or Named Pipes. I
> asked the individual who is responsible for the application which
> created this instance of MSDE (and also the one who asked me WHY
> can't he connect through EM), I learned that this is the way it
> should be. :^/
if Shared Memory is the only protocol that "must" be enabled, then no remote
connections will be available... but it can be ok in local scenarios ..
MSDE will then actually be used as a local desktop database..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation on a XP Professional WS.

Hello,
I'm experiencing 2 problems after MSDE installation on a XP Pro workstation
on a network.
1. The SQL Service Manager don't show the default instance. If I put
manually is OK, but on every reboot it lose the instance name and show me
nothing.
2. it's impossible to login from an external computer or create any kind of
connection (ODBC or .udl file).
For information the setup was make:
with an .ini file containing
[Options]
INSTANCENAME=fgsoftware
SAPWD=xyzxyz
SECURITYMODE=SQL
The computer is SP2 full patched.
After the first problems I deactivated the windows firewall.
Help me!!!
TIA
Francesco Garganese
FG software
Can't help you with 1 unfortunately - it has happened to me but I've never
quite worked out why...
To log in from an external computer you need to have set the
DISABLENETWORKPROTOLS flag to false when installing. See the readme that
comes with the installer for more details on command line switches.
Also, MSDE from Service Pack 3a onwards, installs in Windows Authentication
mode only by default. see the following kb article for more info:
http://support.microsoft.com/default...;EN-US;Q325022
If you're trying to access it from another machine that is not logged in as
a *domain* user on the same domain (i.e. you must be running a Windows 2003
Server Domain Controller somewhere) then you can only connect using Mixed
Mode Authentication, which as the above article will tell you is disabled by
default.
"Francesco Garganese" <FrancescoGarganese@.discussions.microsoft.com> wrote
in message news:CD18E7C6-6E32-4D27-974D-C744C580C820@.microsoft.com...
> Hello,
> I'm experiencing 2 problems after MSDE installation on a XP Pro
> workstation
> on a network.
> 1. The SQL Service Manager don't show the default instance. If I put
> manually is OK, but on every reboot it lose the instance name and show me
> nothing.
> 2. it's impossible to login from an external computer or create any kind
> of
> connection (ODBC or .udl file).
> For information the setup was make:
> with an .ini file containing
> [Options]
> INSTANCENAME=fgsoftware
> SAPWD=xyzxyz
> SECURITYMODE=SQL
> The computer is SP2 full patched.
> After the first problems I deactivated the windows firewall.
> Help me!!!
> TIA
> --
> Francesco Garganese
> FG software
|||Thank you very much Ben, adding DISABLENETWORKPROTOLS=0 in the paramenters
and reinstalling both problems are resolved!
Sincerely
Francesco Garganese
FG software

MSDE installation messes up Query Analayzer and Enterprise Manager

Does anyone out there know how to fix the problem with the SQL tools and MSDE?
I have found that if you install MSDE after installing SQL Server's Tools
the tools don't work anymore. Any help or suggestions here would be
appreciated.
Try reapplying latest service pack.
"jdehne" <jdehne@.discussions.microsoft.com> wrote in message
news:8E64752E-84F1-462D-A614-2E6CCF943300@.microsoft.com...
> Does anyone out there know how to fix the problem with the SQL tools and
> MSDE?
> I have found that if you install MSDE after installing SQL Server's Tools
> the tools don't work anymore. Any help or suggestions here would be
> appreciated.

MSDE installation hangs up

Hello,
I am having problems with an installation of MSDE. The computer alraedy has
an instance of MSDE installed with Outlook for the Contact Manager and I
have no problems with that instance. A new application I have installed also
uses an instance of MSDE for a database. During the installation of this
application (Sony Media Manager) the MSDE installation hangs up an dnever
completes. The only way out is to use task manager.
Examining the log file it appears to be sqlredis.exe that is hanging. I have
searched the web and MS knowledge-bases and found nothing that fixes this
problem. We really need this element of the application to work so that we
can efficiently access our media database. Any advice on how to proceed
would be much appreciated.
Sid.
hi Sid,
sidprice@.softtools.com wrote:
> Hello,
> I am having problems with an installation of MSDE. The computer
> alraedy has an instance of MSDE installed with Outlook for the
> Contact Manager and I have no problems with that instance. A new
> application I have installed also uses an instance of MSDE for a
> database. During the installation of this application (Sony Media
> Manager) the MSDE installation hangs up an dnever completes. The only
> way out is to use task manager.
> Examining the log file it appears to be sqlredis.exe that is hanging.
> I have searched the web and MS knowledge-bases and found nothing that
> fixes this problem. We really need this element of the application to
> work so that we can efficiently access our media database. Any advice
> on how to proceed would be much appreciated.
setupre.exe installs/checks MDAC stack on the installed machine...
there's a dirty trick to solve this... when the installation hangs, via Task
Manager kill the setupre.exe process and the setup will proceed and complete
successfully..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you for the suggestion, however, when I try to kill setupre.exe I get
an error the access is denied.
Sid.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:453olnF4aq7jU1@.individual.net...
> hi Sid,
> sidprice@.softtools.com wrote:
> setupre.exe installs/checks MDAC stack on the installed machine...
> there's a dirty trick to solve this... when the installation hangs, via
> Task Manager kill the setupre.exe process and the setup will proceed and
> complete successfully..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Sid,
sidprice@.softtools.com wrote:
> Thank you for the suggestion, however, when I try to kill setupre.exe
> I get an error the access is denied.
unfortunately this is the only dirty (and not supported) workaround I'm
aware of... and usually it succedes..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I tried one more thing, I uninstalled my Norton AV and your trick then
allowed the MSDE to continue. However, the installer reported an "unknown
error" after I killed the exe and the application is still unable to access
the database.
Any other suggestions please?
Sid.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:454008F4qlbrU1@.individual.net...
> hi Sid,
> sidprice@.softtools.com wrote:
> unfortunately this is the only dirty (and not supported) workaround I'm
> aware of... and usually it succedes..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Sid,
sidprice@.softtools.com wrote:
> I tried one more thing, I uninstalled my Norton AV and your trick then
> allowed the MSDE to continue. However, the installer reported an
> "unknown error" after I killed the exe and the application is still
> unable to access the database.
> Any other suggestions please?
> Sid.
actually not
BTW, it 's usually recommended to define exceptions in the the AV programs
for "*.Mdf" , "*.Ndf" and "*.Ldf", but this is another story...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The dirty trick that Andrea describes is certainly a good workaround.
However, the root cause may be described in Microsoft’s Knowledge Base
article 841061:
http://support.microsoft.com/default...b;en-us;841061
They suggest there that your bootstrap program may be causing the hang by
not responding to a synchronous message broadcast to all top level windows.
If that doesn’t apply, you may be in the situation I’ve just solved, after
several hours’ detective work! :-) I discovered another application on the
machine was causing the hang. In this case, it was “Citi Virtual Account
Numbers” made by Orbiscom, distributed by CitiBank. I’m sure there are other
possible culprits. My guess is that this program is not responding to the
synchronous message broadcast to all top level windows. It has an icon in the
tray at the bottom right.
Perhaps Microsoft could comment on why setupre.exe needs to broadcast
synchronous messages, seeing as it’s the real cause of this hassle.
"sidprice@.softtools.com" wrote:

> Hello,
> I am having problems with an installation of MSDE. The computer alraedy has
> an instance of MSDE installed with Outlook for the Contact Manager and I
> have no problems with that instance. A new application I have installed also
> uses an instance of MSDE for a database. During the installation of this
> application (Sony Media Manager) the MSDE installation hangs up an dnever
> completes. The only way out is to use task manager.
> Examining the log file it appears to be sqlredis.exe that is hanging. I have
> searched the web and MS knowledge-bases and found nothing that fixes this
> problem. We really need this element of the application to work so that we
> can efficiently access our media database. Any advice on how to proceed
> would be much appreciated.
> Sid.
>
>

MSDE Install Issues

Hi all I hope someone can help, I have managed to install MSDE on
Windows 2003 Server, however after a reboot I open up the SQL Serve
Service Manager and Under Server I have the server name, but under
services, it is all blank, as such its not working at all, any ideas on
how to add a service to get this working?
I have tried a reinstall, same issue.
Thanks
donaldsmarshall@.gmail.com wrote:
> Hi all I hope someone can help, I have managed to install MSDE on
> Windows 2003 Server, however after a reboot I open up the SQL Serve
> Service Manager and Under Server I have the server name, but under
> services, it is all blank, as such its not working at all, any ideas on
> how to add a service to get this working?
> I have tried a reinstall, same issue.
> Thanks
>
Sounds like you don't have network protocols enabled.
Run SVRNETCN, enable network protocols and shutdown/restart MSDE.
|||Hi Paul thanks for the reply, For some reason I have 2 instances listed
SERVERNAME and SERVERNAME/SERVER
SERVERNAME had nothing showing but the other one did, added all 3
network components and rebooted, changed to SERVERNAME\SERVER and it
showed a database, now to figure out how to remove SERVERNAME one
Thanks Paul, Much Appreciated

MSDE in Enterprise manager: strange number with managed tasks...

Without having read the manual (just assuming it should work), I have a
problem with MSDE and using the Enterprise Manager to create a database
maintenance plan.
I have a desktop machine with SQL2K(sp3) and a portable with MSDE
(msderela.exe). I am testing (developing) an application that should
bee able to pull a subscription-db (portable in this case) from the
main-server (desktop in this case). I've setup all directories needed
(repldata) and the installation-log for MSDE (installed with /L*v)
didn't gave me any error... I've attached a DB (for testing purposes)
and (using the Enterprise manager) it seems to return everything I want
it to return (data that is).
But, when I was trying to setup a maintenance plan on the laptop (so
that user has a backup in case he's traveling and would like to revert
to a backup-file), I run into some very strange errors. Although I can
create a plan (either using the wizard or 'plain'), certain values are,
well, let's say damaged...
For example, the "complete backup" tab. On the right side of the
checkbox "Remove files older then" you have a combo with 'days',
'weeks', etc. For some reason, this combo is empty.
Having skipped this functionality completely, I've setup a complete
plan and saved it. Backup every 1 days at 18:00 (there's more, but for
the example's sake I don't include all settings).
Now, when I open that plan again, I see that the every 1 days is
changed to 366 days (not only for this one, but for all where I've set
it to every 1 day). I can't save the plan anymore (errors complaining
about having the wrong value-types). When I change it back to 1 day,
save it and re-open it, it comes back with the 366 days again...
Any ideas on what's going on here?
Thx,
GB
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
Are you sure you're properly licensed to manage MSDE with Enterprise
Manager?
http://www.aspfaq.com/
(Reverse address to reply.)
"Gijs Beukenoot" <gijs.beukenoot@.wanadoo.nl> wrote in message
news:mn.8c937d4b9fda54cf.22563@.wanadoo.nl...
> Without having read the manual (just assuming it should work), I have a
> problem with MSDE and using the Enterprise Manager to create a database
> maintenance plan.
> I have a desktop machine with SQL2K(sp3) and a portable with MSDE
> (msderela.exe). I am testing (developing) an application that should
> bee able to pull a subscription-db (portable in this case) from the
> main-server (desktop in this case). I've setup all directories needed
> (repldata) and the installation-log for MSDE (installed with /L*v)
> didn't gave me any error... I've attached a DB (for testing purposes)
> and (using the Enterprise manager) it seems to return everything I want
> it to return (data that is).
> But, when I was trying to setup a maintenance plan on the laptop (so
> that user has a backup in case he's traveling and would like to revert
> to a backup-file), I run into some very strange errors. Although I can
> create a plan (either using the wizard or 'plain'), certain values are,
> well, let's say damaged...
> For example, the "complete backup" tab. On the right side of the
> checkbox "Remove files older then" you have a combo with 'days',
> 'weeks', etc. For some reason, this combo is empty.
> Having skipped this functionality completely, I've setup a complete
> plan and saved it. Backup every 1 days at 18:00 (there's more, but for
> the example's sake I don't include all settings).
> Now, when I open that plan again, I see that the every 1 days is
> changed to 366 days (not only for this one, but for all where I've set
> it to every 1 day). I can't save the plan anymore (errors complaining
> about having the wrong value-types). When I change it back to 1 day,
> save it and re-open it, it comes back with the 366 days again...
> Any ideas on what's going on here?
> Thx,
> GB
> --
> Dit is een automatische handtekening van MesNews.
> Site : http://www.mesnews.net
>
|||Aaron [SQL Server MVP] drukte met precisie uit :
> Are you sure you're properly licensed to manage MSDE with Enterprise
> Manager?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
I fail to see what the licensing has to do with this problem...
But anyway, I have at least three developer licenses (7 and 2x2K); two
standard licenses (7 and 2K) and one Enterprise license (2K) (all
processor); I also have one dev lic with with Office-xp-dev and I have
an MSDN universal... But from memory (I used to have @.microsoft.com
behind my (not-mentioned-here-due-to-spam)-address although that is a
few years ago), having just one valid SQL license is enough to do what
I want to do.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> I fail to see what the licensing has to do with this problem...
Maybe trying to push you to create jobs legally using the stored procedures
in MSDB, instead of Enterprise Manager, which (a) you are having problems
with, and (b) is not likely abiding by licensing agreements.

> But anyway, I have at least three developer licenses (7 and 2x2K); two
> standard licenses (7 and 2K) and one Enterprise license (2K) (all
> processor); I also have one dev lic with with Office-xp-dev and I have
> an MSDN universal... But from memory (I used to have @.microsoft.com
> behind my (not-mentioned-here-due-to-spam)-address although that is a
> few years ago), having just one valid SQL license is enough to do what
> I want to do.
I would consult with a Microsoft licensing rep before having confidence in
such a statement. MSDE has very strict limitations on how you can use SQL
Server tools for management, regardless of how many licenses you have for
other editions. And there are very few cases that I've heard of where it's
legal to manage MSDE with Enterprise Manager, sorry.
|||Aaron [SQL Server MVP] drukte met precisie uit :

> I would consult with a Microsoft licensing rep before having confidence in
> such a statement. MSDE has very strict limitations on how you can use SQL
> Server tools for management, regardless of how many licenses you have for
> other editions. And there are very few cases that I've heard of where it's
> legal to manage MSDE with Enterprise Manager, sorry.
Aaron,
Can I point you to the website?
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
To be precise :
<cut>
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the
How to Buy page for information on obtaining a valid SQL Server
license.
Note: The tools and services included with SQL Server Developer Edition
may not be used to manage production server environments.
<paste>
And this is exactly what I'm doing...
Sent me a private message if you're still think I am doing something
wrong.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> And this is exactly what I'm doing...
I thought the same thing too, but apparently there's much more to it than
that single paragraph, and relying on that paragraph has proved detrimental
in the past.

> Sent me a private message if you're still think I am doing something
> wrong.
Not really my job to prove to you that you are doing something wrong; you
might not be, I don't know because I am neither a lawyer nor a Microsoft
licensing rep. Just reminding you that the onus is on YOU to be sure YOU
are abiding by the licensing agreement(s).
|||Aaron [SQL Server MVP] gebruikte zijn klavier om te schrijven :
> I thought the same thing too, but apparently there's much more to it than
> that single paragraph, and relying on that paragraph has proved detrimental
> in the past.
>
> Not really my job to prove to you that you are doing something wrong; you
> might not be, I don't know because I am neither a lawyer nor a Microsoft
> licensing rep. Just reminding you that the onus is on YOU to be sure YOU
> are abiding by the licensing agreement(s).
Good. Can we go back to the original question then?
Anybody any ideas why the before mentioned method is giving me these
strange numbers?
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net

MSDE EnterPrise manager

I am using MSDE enterprise manager and when I downloaded it, I cannot log onto the SQL Server, which is on my computer, I used the server name defined in the SQL Server Service manager, and it cannot connect. I was trying to set the conection up with the ODBC manager, although I am not even sure if this is the right way. Someone please help me out.Depends on how you installed it. If it's in native Windows authentication mode, you'll need to ask it to connect as the current logged on user. If you've enabled mixed authentication, you can connect using the current user or using a SQL Server user (sa is the "administrator" of SQL Server which you'll have specified a password for during the installation if you enabled mixed auth).

Best way to test the connectivity is by using the SqlConnection class and try to connect that way. The errors you get on invoking the "Open" method will explain what's wrong.

Check out my other post on managing MSDE as well onthis forum. This can be seen as a kind of replacement for the Enterprise Manager of SQL Server.