Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating an Msde database through Access 2000
Message
 
 
À
21/04/2005 16:36:53
Information générale
Forum:
Visual Basic
Catégorie:
SQL Server
Divers
Thread ID:
01007250
Message ID:
01007281
Vues:
16
Hi, Gary.

Check this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322336

Also, you may prefer to use a better tool to manage MSDE than Access (maybe it is MY bias against Access {g}). you may try this one which is also free and provided by Microsoft itself:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

Check if you can make it work on Win98, or what you need to do it. In any case, if you have a chance, I strongly recommend you to upgrade to a newer version of Windows to do development work.

Best luck,

>
>I am trying to create a Msde database using microsoft access and I am having troubles.
>
>First I go into microsoft access, I select from the file menu "New" and on the General Tab, I select Project (New Database).
>
>The "File New Database" dialog box is displayed, I type in the name of my new database and press the create button.
>
>The Microsoft SQL Server Database Wizard is displayed next, it prompts me for "What SQL Server I would like to use for this database" and defaults to the name of my computer.
>
>The next to prompts are for the Login ID and Password of an account with CREATE DATABASE privileges on this server.
>
>I tried inputting "sa" for the Login ID and then press the Next button
>
>I then get a message that states:
>
>Connection Failed
>SQLState: '28000'
>SQL Server Error: 18452
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server Connection.
>
>Then I press the OK button and another dialog box displays with the title
>"SQL Server Login"
>
>For "Server" it displays the name of my computer in a drop-down box
>and a checked CheckBox that says "Use Trusted Connection".
>
>Since I an using Windows98 which I believe does not use trusted connections, I Unchecked the CheckBox and presses and then I was prompted for a login ID and a password.
>
>The login ID default to my login ID that I use when I login to my computer.
>When I press the OK button, I got the following error message.
>
>Connection Failed
>SQLState: '28000'
>SQL Server Error: 18452
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'garyh'.
>
>I press the OK button again and I was back to the prompt, so I put in "sa" for the login ID and pressed OK and got the following error message.
>
>Connection Failed
>SQLState: '28000'
>SQL Server Error: 18452
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
>
>Can someone please help me with this?
>
>Thank You
>
>Gary
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform