Hey Russ,

Which version of SQL Server?  I gather that bob12 is actually in SQL Server?
Did he ever have access to this database?  I have seen issue like this when
a database has been restored from another SQL Server instance or from a
different domain.

Has it recently been restored?

N

 

-----Original Message-----
From: Snake Hollywood [mailto:[EMAIL PROTECTED] 
Sent: 23 February 2004 11:27
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] SQL Server user corruption

I have one particular database on our server that is causing me problems,
lets call it "devildb" other people when logging into their own databases
keep getitng errors relating to this one.
E.G.
user bob12 is not a valid database user in database 'devildb'

No bob12 is not a user in that db, nor is he meant to be, nor is he
connecting to that db or doing anything with it anyway.

Anyone ever had this issue or aware of a nice easy fix.

I have made a new copy of the offending database and imported everything
form the old one and created a new user, but that didn't help.

Russ


--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED] For human
help, e-mail: [EMAIL PROTECTED]
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com

-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to