MSDE kicking my...

[bri189a]

MSDE is really getting me... you think they would've made this a little more dumby proof.... I installed MSDE according to the documentation that came with it on the command line setting the password. I downloaded a web based program from MSDN for managing the databases... forget the name... this is on my home machine... regardless, using that or any other tool I'm constantly getting unknown username/bad password error... which is understandable because I'm just assuming the user name is sa and the password is what I typed when installing it. I didn't see anything in the MSDE documnetation when setting it up for giving a username unless you were upgrading from an earlier version. It shouldn't be this hard... I know I'm doing something stupid in either my installation of MSDE or something else really obvious, but I'm also sure no-one out there has probably had the best experiance setting that thing up... so any pointers would be appreciated...

 

Thanks!

[samsmithnz]

MSDE can be a real b**** to install can't it!

 

Try sa with no password. Also check that you haven't configured it for windows integration security. Oh and check that your caps lock isn't on :D

[bri189a]

The installation went well... it's using the program from MSDN (Web Data Administrator) that is giving me the problems.... why would they make it so difficult?! b**t**ds! The Web Data Administrator requires user name and password... but I am correct in thinking sa is the default username? Is there a MMC snap it for conifuring MSDE or something like that? Something besides what you do at set up and starting and stoping the service?

[hog]

OK this is from memory long ago:(

 

I had awful trouble with it then found that there was a text file or something in the MSDE folder which requires you to enter a username/password I think.

 

There was also a text help file detailing this.

 

Not sure if this helps but I'm sure it was this that solved my problem...

[Nerseus]

As you mentioned, you should have specified the password on the command line when you installed MSDE. Or, as hog mentioned, you can use a config file (I used a shortcut with the command line option).

 

I use Visual Studio's Server Explorer to do most of the work in MSDE. The website http://www.msde.biz also has a free Query tool you can use. I even used it to restore a backup made with SQL Server 2000.

 

To log in, regardless of the tool used, you should be able to use userid="sa" and whatever password you specified during setup. If you chose to turn on mixed security, then you can setup your Windows users to be SQL users as well. I'm not 100% sure, but you might be able to login using your Windows "Administrator" account (it's password).

 

-nerseus

[Answer]

You need to reinstall from the command line

 

give it something like this...

 

 

setup.exe INSTANCENAME=VSDotNET SAPWD=password SECURITYMODE=SQL

 

That last parameter is important!!!!

 

second, if you are trying to access the database from a computer other then the one it is installed on or over the network you may have to run a small utility that is installed at runtime to install the tcp/ip pipes and adjust the ports etc...i know i had to do this, but i dont recalll of the top of my head exactly how i did it. It was small program located in the server directory after install.

[LordNader]

If you need to automated the installation of MSDE in a setup application for Visual .NET, you can download a document I wrote that details that

 

visir godotnet.com and search the samples database base for "Embedding MSDE SQL" and you shoudl get a word doc.

 

it will eplain everything for you

 

Nader Hamzei

[bri189a]

You need to reinstall from the command line

 

give it something like this...

 

 

setup.exe INSTANCENAME=VSDotNET SAPWD=password SECURITYMODE=SQL

 

That last parameter is important!!!!

 

second, if you are trying to access the database from a computer other then the one it is installed on or over the network you may have to run a small utility that is installed at runtime to install the tcp/ip pipes and adjust the ports etc...i know i had to do this, but i dont recalll of the top of my head exactly how i did it. It was small program located in the server directory after install.

this is exactly what I typed when re-installed, I XXXX out the real password:

 

setup.exe INSTANTCENAME="VSDotNET" SECURITYMOD=SQL SAPWD="XXXXXXXXXXXXXX"

 

After figuring out that I know need to connect using \\MYCOMPUTER\VSDOTNET\ I was able to get the notify icon as I have in the past. It say SQL Server is running and SQL Server Agent (what is that by the way)... I tried stopping the Agent to see if would make a differance, doubt it would, and it didn't.

 

I'm logged on as the administrator of the computer so I can't see any problems there. For giggles I tried the adminstrator user name and password to no avail.

 

The error I get is 'SQL Server does not exist or access is denied' when using ServerExplor er or 'Invalid username and/or password, or server does not exist. Also, please ensure that SQL Server Authentication is enabled on the server.' when using Web Data Administrator (from MSDN).

 

I'm putting SA or sa as the user name, the password above for the password, and have tried \\localhost\VSDotNet for the server, which I imagine is what it shoud be, but I've also tried \\ComputerName\VSDotNet even though its the same thing... what the heck right? And I've tried just \\localhost and \\ComputerName... again what the heck...

 

Nothing works.

 

Thanks for ideas so far, please keep them coming.

[bri189a]

If you need to automated the installation of MSDE in a setup application for Visual .NET, you can download a document I wrote that details that

 

visir godotnet.com and search the samples database base for "Embedding MSDE SQL" and you shoudl get a word doc.

 

it will eplain everything for you

 

Nader Hamzei

That file is corrupted or something. Just downloads as FILE and opening in word pad it almost looks like a program but too small.

[LordNader]

That file is corrupted or something. Just downloads as FILE and opening in word pad it almost looks like a program but too small.

 

 

 

bri - I just downleaded it. unzipped the package and opened it in Word and Wordpad and it worked.

 

Did you unzip it?

 

Nader Hamzei

[bri189a]

Yes I unzipped it... like I said, all that is in the zip file is one file called MSDE with no file extension. I'm using WinZip 8.1.

 

Maybe you can just email it me...I'll pm you an email address

[bri189a]

And it continues with MSDE...

 

So I spent the day researching... downloaded SQL Server 2000 Books OnLine (Updated 2004), and found that there is this OSQL utility. With that I was able to create a database, create users, create tables in the database... yet when using Server Explorer (and that other program I mentioned before)

 

Error: Server does not exist or access is denied.

 

Why is this?

 

I don't have to logon with this OSQL utility... I guess it sees I'm an administrator and let's me do what I want... am I using the wrong driver in Server Explorer maybe? I'm using the obvious one... SQL provider or whatever it is named.

 

I'm really stumped... did anyone else have to use this utility to create users or databases?

 

I'm going to keep researching and I hope either myself or you have an answer for future MSDE newbies having problems.

[bri189a]

Finally figured it out

 

There had to of been something hosed with my registry from previous attempts. I went and bought a new backbones (severe upgrade) for my computer (MB/PROC/RAM) and thus reformatted and reloaded the OS... got to the point of trying MSDE again, and first time no problems installing it. Works wonderfully. Now for learning how to use that instead of Access.... thanks again everyone for all your help!