I’m getting the following error, while configuring the MS SQL server enterprise adapter(intelligent).
[Application] (085) The adapter process could not start up.
(10004) DB-Library error, Severity 9:
Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
(DB = MSSQL Server 2000)
(Drivers = Microsoft type IV jdbc drivers)
(platform = Windows 2000)
The DB is on the same server. I don’t have much experience with MSSQL server. On the SQL Server tab, what do i need to specify in the SQL server parameter: just the host name or the DB URL.
Anything else I might be overlooking.