Your problem is due to SIDs. Even though you have the same user name on each box, they each have a different ID. Or possibly, that user does not have a login assigned.
-----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 8: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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207043 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
