Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

NPM Setup SQL Problem

bhuraque

Hi all,

I am trying to install NPM my setup is Windows 2008 R2 Ent. SQL Server 2008 R2 and Turkish CI-AS

It'a new installation OS and SQL when I try to install NPM on existing SQL server I get following error:

Error while executing script- Invalid object name 'information_schema.tables'.

If I query database with INFORMATIN_SCHEMA.TABLES it success

Currently I am running Orion with SQL compaq database

I am looking for any advise.

Thanks

Find more posts tagged with

npm_10_sql

Accepted answers

kevin2me

Hello,

This is a Known Issue with that Collation:
We actually do not support Turkish CI-AS

SELECT * FROM Information_SCHEMA.columns

Information_schema.columns is used, during the config wizard,
as part of our checking to see if the DB schema needs upgrading (additional columns added, changes made to constraints).

Please reinstall with a fresh SQL Instance with the following collation SQL_Latin1_General_CP1_CI_AS and should have no issues.

Kev

All comments

Hi,

[Turkish CI-AS] is collation of database or server? What's database and server collation?