cant upsize from access to MSDE 2000 (urgentish :p)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dan Nash (dan_at_musoswire.co.uk)
Date: 08/07/04 

Date: Sat, 7 Aug 2004 02:13:02 -0700

Hi guys

Having a problem with MSDE. I'm trying to upsize an Access database to MSDE.
I'm fairly new to all this SQLServer malarkey, so bear with me.

I've setup MSDE with the default Instance name (what is the default instance
name?) and a good SAPWD. Used to the /qb+ switch to install from the command
line - if I don't, the installation just seems to die half way through.

Now then, when I try and upsize my access db, i tell it to "create a new
database" and then it gives me a new dialog with Which server, login,
password etc. I'm not entirely sure what to put in here though. What's the
LoginID? I haven't created one (as far as i know).

I've tried MSSQL and 80 (both directories in Prog Files\SQL Server), but i
keep getting the same error (18452), telling me that login failed for user.
Reason: not associated with a trusted SQL server connection.

What am I doing wrong? Have I missed something? Any help greatly appreciated!

Cheers

Dan

Relevant Pages

  • Re: MSAccess DB as a linked server - The provider ran out of memory
    ... Access database that has large BLOBs in it by using a linked server ... Is there some reason you can't query the Access database ... I am guessing that the reason MSDE is ...
    (microsoft.public.sqlserver.msde)
  • Re: Access project vs. linked tables to MSDE
    ... .asp or an Access .mdb, then the answer is, .mdb. ... copy of the Developer's Edition of SQL Server. ... >Currently developing an application using MSDE as backend, ... >tables from within an Access database, whether appending to an Access table ...
    (microsoft.public.sqlserver.msde)
  • How to Attach MS Access Database to MSDE
    ... I have a program installation setup that comes with a default MS Access Database. ... How do I attach this default database into MSDE on my server? ...
    (microsoft.public.sqlserver.msde)
  • Re: Help with Master/Detail UI in ADPs
    ... No, MSDE is not limited to 5 concurrent users, it is limited to 5 concurrent ... The users whose connection to the server is idle at any moment don't count. ... and from the local temp table to the Detail table on the server for rows ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... how SQLServer-Browser resolves portnumber of MSDE named instance. ... Windows 2003 Server ships with SSEE preinstalled (for ... port information to your client. ...
    (microsoft.public.sqlserver.connect)