You should configure the ColdFusion service to run under a Domain account specifically for ColdFusion, and make sure that same Domain account has been granted the correct permissions within SQL Server. By default, the ColdFusion service will run under the "Local System" account, which will be unable to login to a SQL Server database on a remote server. The Cold Fusion is 9 on a Windows 2008 Standard configuring a ColdFusion SQL Server data source, if you don't specify a username and password, ColdFusion will attempt to authenticate to the database using the credentials of the account the ColdFusion service is running under. The database server is a Windows 2008 Standard Edition. Where in development SQL Server or on the development Windows Server (for SQL Server) is it pointing to ANONYMOUS LOGON? I have looked on the development SQL Server and everything is pointing to Windows Authentication. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. When I logged into the development Cold Fusion admin and try to connect to the development database, I am receiving the following message:Ĭonnection verification failed for data source: DEV I created a development database on the server. SQL server was installed on a the development server (a seperate server). The production sever is able to connect to the production datbases. The production Cold Fusion server was completely backed up and was placed on a development server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |