Sorry for the OT. I am at my wits end with this issue. I know there are a
few expert SQL admins out there.
Just upgraded form SQL 7 to SQL 2000. Restored the database into SQL 2000.
CF on the same box can talk to the SQL server happily using a trusted
connection. (but not a username/pass) IF I use Enterprise manager from the
server using a trusted connection, I can admin it. I have added several
admin accounts in both windows and SQL, but I can not login with a username
and password. I keep getting a message "Connection failed:SQLState:'28000'
SQL Server Error 18452 Login failed for usernamehere. Reason: Not
associated with a trusted SQL Server connection."
I have tried (and failed):
Switching the authentication to windows and SQL.
Adding admin account in windows.
Adding admin accounts in SQL
Using the sa account to log in.
Any idea what the problem might be? Some New security is SQL 2000? Issue
with the upgrade?
Thanks
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
