Make sure you have a SQL Server login with the same name under Security. Then, make sure your database's user points to that login.
Moving databases from one server to another tend to break SQL Server-based logins, however, domain (Windows-based) logins will still work. M!ke -----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 10:15 AM To: CF-Talk Subject: SQL Server User Problems We've transferred a copy of our database to a new server and are trying to log in as a particular user. It seems that for some reason, we cannot connect to the default database. This was working fine on the old system, but since we've copied things across it seems that a particular user account does not work. I've tried removing it and recreating the user all with the same dismal results. Has anyone else experienced this or know of a possible solution? Cheers! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
