Re: User connection problem; tried everything

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

What kind of backup? A backup from another machine, from a full
reinstallation of MSDE or simply a small restoration to the exact same
installation of MSDE only to go back in time with the data?

I suppose that the master database has changed and that you forgot to use
sp_change_users_login (see
http://msdn2.microsoft.com/en-us/library/ms174378.aspx ) in order to remap
the SIDs between the master database and your database for each user
account.

If you still have problem, this kind of question would be best answered in
mp.sqlserver.security or mp.sqlserver.server. You should also make some
connection tests with the sa account to be sure that you are really trying
to connect at the right place and with the right parameters.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don" <don.rea@xxxxxxxxx> wrote in message
news:da16ce6b-edca-4136-b3ed-f63871375bc4@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Well, I've tried everything I can think of so far, anyway. I have a
database in an MSDE instance with users attached. I know I have the
right passwords for them, because I just reset the passwords. They are
attached to the database - if I try running sp_grantdbaccess I get an
error message telling me that they already exist in the database. I
can see them and the roles they're assigned to in the tree view of
database objects. And yet, when I try to connect to the server as one
of those users by any means - ODBC or OLEDB from an application, or
using the query analyzer, or through osql - I get some variation of
the "Login failed for user" message.

This began happening immediately after I restored the database from a
backup, so I guess that could have something to do with it. But I
can't think of what, or what else to try. Anybody?


.

Relevant Pages

  • Re: how to do backup of msde?
    ... I can't give you a complete answer as there are others better suited to explain however in general terms when you detach a database the logs files are flushed, statistics updated and completed transactions committed to the database. ... In my experience most backup regimes involve stopping the server processes, backing up all MDF & LDF database files required and then restarting the server processes. ... >we use Protection Pilot, it installs a MSDE that it uses ...
    (microsoft.public.sqlserver.msde)
  • Installing MSDE - User Security Issues...
    ... replicating a SQL Server 2000 database as an MSDE database in a seperate ... using oSQL to restore the database to an MSDE install on a machine. ... It's done in two steps - installing MSDE and restoring the backup. ...
    (microsoft.public.sqlserver.security)
  • Backup/Restore from MSDE 1.0 to MSDE 2000
    ... backup copy of my database in MSDE 1.0 and restore it to MSDE 2000. ...
    (microsoft.public.sqlserver.msde)
  • Re: sbs server reboots
    ... MS "may" be able to fix AD but restoration ... fact that your most recent successful backup seems to have been 3 weeks ... Initiating INTEGRITY mode... ... Database: TEMPINTEG3188.EDB ...
    (microsoft.public.windows.server.sbs)
  • Random Problem with ADO opening secured mdb
    ... I do regular backup of mydata which is present in MSDE database to mdb ... i read the version info by connecting to this mdb file from my VB ...
    (microsoft.public.vb.database.ado)