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 |
|
Culbert
Starting Member
5 Posts |
 Posted - 2004-08-01 : 02:44:26
|
OK, I was finally able to install MSDE successfully. I activated the service and now I get the little icon in my system tray. YAY! I'm very happy so far. Now, I'm reading on this page here [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdeforvs.asp[/url] how to convert my access database from JET to SQL (or MSDE in my case). I choose to create a new database after starting the Upsize wizard. Then I choose the server, which shows up in the drop down box. Then it asks me for a username and password that has "CREATE DATABASE" privileges on the server. So I put my administrator user name and password in, then choose the name of my new MSDE database, but then I get this error message.  I've Googled this and came to this site here [url]http://www.banmanpro.com/support/sql2k.asp[/url] and I thought I had it licked, but I can't find this admin area anywhere and I'm afraid that since this is MSDE I don't have this admin area.Anyone? Please help!  |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 22:30:36
|
| Try it without a username and password.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Culbert
Starting Member
5 Posts |
Posted - 2004-08-02 : 01:07:40
|
| Unfortunately I did try that too. I read in the instructions that you can try to have windows authenticate you by not using a username and password, but I get the same error except it says "null" for my username. Any other ideas??? |
|
|
|
|
|
|
Upsising my Access database error