Error connecting to Client Sys. DB

Question

Hi

i am trying to create Datasource in my my localhost for the
client's database.
i am able to connect to through the SQL Server Enterprise
Manager, but when i am creating datasource i am getting following
error:

Connection verification failed for data source: dev1
java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][Macromedia][SQLServer JDBC Driver]The requested instance is
either invalid or not running.
The root cause was that: java.sql.SQLException:
[Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC
Driver]The requested instance is either invalid or not
running.

LL20_2 · Answer

This assumes you have CFMX 7.01 and SQL Server 2000 installed on Windows 2000/XP/2003
This may help:

• Install SQL2000 SP3 ( or latest patch)
• Create an ODBC DSN within the Microsoft ODBC Manager to make certain the connections are working at this level.
• Create a new SQL2000 user with administrative permissions, go to the user/admin properties and allow permissions at all levels for the applicable database (not all dbs).
• Create the JDBC DSN in Coldfusion, use the server name that is listed in the Enterprise Manager.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded