I am trying to create repositoy connection using Pentaho Data Integration 3.2.0 to MS SQL Server 2008 and I can’t connect due to below reasons.
Need some help here.
MS SQL Server 2008 : Locally installed and host name dev-02007
Instance Name: MSSQLSERVER
What you need to do is create a new db in SQL Server 2008, i.e. “MyPDIRepository”
Once the datbase is created you must use PDI to use this “empty” db as your repository. PDI will then go and create all the tables it requires.