MSDE Problems

I am having sever troubles installing msde. I download the sql2kdesksp3 from microsoft and then I run it. Nothing is installed! I have to do statements in command prompt, statesment which I dont understand and im probably not doing them right either. After a lot of testing and trying I finally got it installed. But it didnt say MSSQL$NetSDK as it is showed in my book, it said MSSQL Server. And from on there Im stuck. I have tried to add a connection in vs.net as it says with (local)NetSDK but it just says it cant open a connection. My computer name is Kris, I think I should use that instead of (local) and I dont know at all what they mean by NetSDK.
Can anyone help me?

Regards Kristoffer

Windows XPI'm not an MSDE install expert by any means but I would go out to the command prompt (Start->Run->cmd->OK) and type in

osql -L

That will give you a list of all the Sql Server and MSDEs on your computer. Hopefully one will by Kris\SomeInstanceName. Try that name or whatever name turns up.

You might also check in the Setup.Ini file that is in the same directory as you installed MSDE from. If you open it in Notepad or equivalent tool look for the

INSTANCENAME=SomeInstanceName

That should correspond to one of the name returned by osql -L

(local) is an all purpose name that just means "use this server".sql

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 install problem

Hi,

My computer OS is win2000 +sp3, I download the MSDE setup file(sql2kdesksp3.exe), I followed the instruction of the microsoft web site to install the msde, but during the windows configure the SQL server desktop engine, it hangs up there. I checked the setup log file, it has no error, it goes to sqlredis.exe, and stop there.

Can any one help me for this?

I really appreciated!

zgWhat is the command line you are using to install msde?

-Kashif

MSDE hangs on Install

First off, let me say it took me nearly all day to get this working. When you download the sql2decksp3.exe you might think it install like any other program. No. This exe simply unpacks the setup files. The actual setup program, setup.exe must be run from a DOS command prompt... so you've got to look up the correct command line parameters in the sp3reademe.htm file. Something like:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

No problem so far, but then when I go to run the setup.exe with the correct parameters the install goes fine until the last 5 seconds. Then hangs. Again and again. The install program keep getting hung up just before the finish. Each time I had to uninstall and reinstall-- 6 times. When if it hangs you've got to break out with the Task Manager, then do an uninstall from the Control Panel... if... an entry there was created. It usually is.

I tried everything I could think of and then did a search here. There were a few messages. The only one who actually got past this problem said he deleted all references for "Microsoft SQL" in the registry. I tried that too. It didn't work for me. That setup hung in the very same place. Then instead of breaking out and starting again, I tried shutting the machine down, while the setup was hung, thinking that maybe after a restart the installation might continue AND and that point the install completed.

Hope these notes help the next person who runs into the same problem. I also tried putting the modem on standby and disabling Norton anti-virus. Alone that did help, but when I tried all this stuff together... finally at 4:34 PM, I was able to establish a connection, from both VB.NET and with a great FREE MS SQL Manager at http://sqlmanager.net/products/mssql/manager/download

Now I can start. For some reason, the way I think... I can't do any coding until the entire database spec is first set up. Then you write all the add, edit, display and sort form, windows. When designing web applications, you design the database first, then each web form preforms some unique operation or reference on the remote database. I think that's the way it works.

Hey! Hope this helps others.

Paul TownsendSometimes verbose logging can help to pinpoint installation problems:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd" /L*v c:\MSDEInstall.log

Terri

MSDE for 95 & NT

hi all,
Can u provide the link to download MSDE version 1 for Windows 95 & NT
Dil
hi,
Dil wrote:
> hi all,
> Can u provide the link to download MSDE version 1 for Windows 95 & NT
it is no longer available for direct download.. you can find it on Office
2000 cd, on MSDN, ...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.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,
I got MSDE from office 2000 CD. but it requires Access 9.0 or Office
server Extensions (OSE) has to b installed on same machine.
besides its an installshield setup utility, which allows Remote
installation also.
pls comment
Dil
|||hi,
Dil wrote:
> Hi Andrea,
> I got MSDE from office 2000 CD. but it requires Access 9.0 or Office
> server Extensions (OSE) has to b installed on same machine.
> besides its an installshield setup utility, which allows Remote
> installation also.
>
I'm not aware of such requirements in order to install MSDE 1.0 (msdex86.exe
installer package)..
the requirement I'm aware of is IE 4.0, and the release notes of the
msdex68.exe package, part of "MSDE for Visual Studio 6.0" distribution,
including SQL Server 7.0 Dev Edition does not list Office 2000 or OSE at
all...
and, AFAIK, the ISS script provided with it does not allow remote
installations...
you can somehow customize that script (say in order to change the TCP/IP
port used by the instance), but just little...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Exorcism

Got some problems installing the MSDE I downloaded it from
http://www.microsoft.com/sql/msde/do...s/download.asp
and ran the setup with the following command:
setup SAPWD="testpw" INSTANCENAME="test"
It installs, however, the server is never visible by the SQL Server
Service Manager (although I can type it in manually, but starting it
just tells me It's already started). Nor is it visible by Enterprise
Manager (I installed the client tools to test this). It's not visible
from a Data Link dialog but I can type the name in and connect to it
Plus, here's some additional madness.
From the datalink manager, I can connect only if I use NT integrated
security. If I try something silly like the "sa" and "testpw" which I
passed to setup, I get the error: "Test connection failed because of an
error in initializing provider. Logon failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection."
Trying to connect from another machine is fruitless.
I've tried numerous things, reversing the parameters passed to setup,
checking the MDAC version 2.7 Re(something or other). Reinstalling,
rebooting, Standing on my head. prayers, Voodoo, stuffed animal
sacrifice. Nothing works.
Any pointers?
-- xavier
Hi Xavier,
Most likely you don't have network protocols enabled. Try running
svrnetcn.exe (from Start>Run) and check that tcp/ip is enabled. If not,
enable it and restart the MSDE/SQL service.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Xavier Pacheco" <xavier@._nospam_xapware.com> wrote in message
news:%23po8a%23ZhEHA.2340@.TK2MSFTNGP11.phx.gbl...
> Got some problems installing the MSDE I downloaded it from
> http://www.microsoft.com/sql/msde/do...s/download.asp
> and ran the setup with the following command:
> setup SAPWD="testpw" INSTANCENAME="test"
> It installs, however, the server is never visible by the SQL Server
> Service Manager (although I can type it in manually, but starting it
> just tells me It's already started). Nor is it visible by Enterprise
> Manager (I installed the client tools to test this). It's not visible
> from a Data Link dialog but I can type the name in and connect to it
> Plus, here's some additional madness.
> From the datalink manager, I can connect only if I use NT integrated
> security. If I try something silly like the "sa" and "testpw" which I
> passed to setup, I get the error: "Test connection failed because of an
> error in initializing provider. Logon failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection."
> Trying to connect from another machine is fruitless.
> I've tried numerous things, reversing the parameters passed to setup,
> checking the MDAC version 2.7 Re(something or other). Reinstalling,
> rebooting, Standing on my head. prayers, Voodoo, stuffed animal
> sacrifice. Nothing works.
> Any pointers?
>
> -- xavier
|||And on top of that, if you want to log in with SQL Server authentication,
you have to chance the registry key
HKEY_local_machine\SOFTWARE\Microsoft\MSSQLSERVER\ MSSQLSERVER\LoginMode to 0
(or 2).
You can enable SQL Server authentication when you install MSDE, if you
provide the SECURITYMODE=SQL with setup.exe, together with the sa password.
Jacco Schalkwijk
SQL Server MVP
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23Pg%23EVehEHA.1888@.TK2MSFTNGP10.phx.gbl...
> Hi Xavier,
> Most likely you don't have network protocols enabled. Try running
> svrnetcn.exe (from Start>Run) and check that tcp/ip is enabled. If not,
> enable it and restart the MSDE/SQL service.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Xavier Pacheco" <xavier@._nospam_xapware.com> wrote in message
> news:%23po8a%23ZhEHA.2340@.TK2MSFTNGP11.phx.gbl...
>
|||Greg Low [MVP] wrote:

> Most likely you don't have network protocols enabled.
Bingo! That did it. Thank you very much. . Where do I send the
check? Oh wait, no, you're an MVP, you get no money. Thanks!
- x
Xavier Pacheco
Xapware Technologies Inc
www.xapware.com
Author - Delphi for .NET Developer's Guide
http://www.amazon.com/exec/obidos/ASIN/0672324431/
|||Yup, I had already done that. Thanks for the tip.
- x
Xavier Pacheco
Xapware Technologies Inc
www.xapware.com
Author - Delphi for .NET Developer's Guide
http://www.amazon.com/exec/obidos/ASIN/0672324431/

MSDE Examples?

Does MSDE have the PUB database example in it? Just wondering before I download it.I guess all I need to know is instpubs.sql included during the install? Could someone do a quick search of their harddrive that has MSDE installed? If not, I guess I can stop being lazy and download it.|||Ok, since no one answered I went and installed MSDE. I found it doesn't have the pubs automatically but you can easly download the scripts from Microsoft. The installtion was easy and I found a really cool way to build the pubs sample database. I will share the instructions which I got from Peter Wright. Author of ADO.NET Novice To Pro, From Apress Inc.

-------------

That's a problem isn't it, and one that caught me out initially. MSDE is a great tool, since it's basically a cut down SQL Server, for free, but without a user interface how on earth do you do anything?

The solution lies in Visual Studio, and hopefully this applies as much to the standard editions as it does to the Enterprise edition I have here.

Click on File, and then on New Project. When the project type browser appears, click on "Other Projects", and you should see an entry that says Database Projects. Click it, and call your project PubsDatabaseSetup.

You'll instantly get presented with the Data Link dialog, a dialog asking you to basically build up the connection string to talk to your database server. Now we're getting some where - Visual Studio wants access to your MSDE database, so key in your username, machine name (localhost) and so on to let it have access. The dialog will also ask you for a database name - leave it blank.

When the project has been created you'll notice in the Solution explorer that you have folders for Change Scripts, Create Scripts and Queries. Drop your InstPubs.sql script file into the Create Scripts folder - you can do this by right clicking on the FOlder and choosing add existing item from the list that appears.

Finally, to run the script, right click on it and Choose RUN.

Your database will be created, but more useful than that is the fact that you now have a project that can be used to maintain the database. If you want to add any new stored procedures you can do so with this project. If ever you need to rebuild the database y ou can use this project to do just that.

Database projects in Visual Studio are a very powerful tool indeed. Have fun exploring them
------------