Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maniraji
Starting Member
1 Post |
 Posted - 2004-02-24 : 00:59:32
|
| Hi,I am a new user of MSDE 2000. I am facing the following problems in installing MSDE on my computer (P-IV: 2.2 GHz, Windows XP Home Edition). I downloaded it form Microsoft web site.1. There was only one way that I could install it: with a blank password and without any instance. At the command prompt of the MSDE folder, I typed:Setup.exe BLANKSAPWD=1It worked only with this command. When I restarted my computer, the database started running with Server as "FAMILY" and Services as a list comprising of "Distributed Transaction Coordinator", "SQL Server" and "SQL Server Agent".2. When I tried the other ways of installing, the first step (initial installation) went on without any error. But when I restarted my computer, the icon in the system try displayed "Not Running" message when the mouse cursor was placed over it. When I opened the SQL Sever Service Manager, both the Server and the Services drop-down boxes were empty. This was the case when I typed any command other than the above one. The following were a few of the commands I tried.Setup.exe INSTANCENAME=VSDOTNET SAPWD="(mypassword)"Setup.exe INSTANCENAME=VSDOTNET BLANKSAPWD=1Setup.exe SAPWD="(mypassword)"It didn't work with any one of these commands. Can anyone tell me what the problem was? Did I use any syntactically wrong command?Thank you.Mani. |
|
|
raybutleratge
Starting Member
1 Post |
Posted - 2004-02-25 : 13:11:55
|
| I ran into the same thing as well. I don't know if there is a better solution, but I found that using the DISABLENETWORKPROTOCOLS=0 setting seems to make a named instance visible to the SQL Server Agent. Without this flag, the server was actually started, but was not visible in the agent. It can, however, still be accessed programmatically. |
 |
|
|
|
|
|
|
|
Installation of MSDE 2000