puppetlabs-sqlserver

[Ryan Vande]

Here is my puppet module list --all

/etc/puppetlabs/code/environments/production/site

├── puppetlabs-ntp (v6.0.0)

├── puppetlabs-sqlserver (v1.1.5)

└── puppetlabs-stdlib (v4.15.0)

/etc/puppetlabs/code/environments/production/modules (no modules installed)

/etc/puppetlabs/code/modules (no modules installed)

/opt/puppetlabs/puppet/modules

├── puppetlabs-pe_accounts (v2.0.2-6-gd2f698c)

├── puppetlabs-pe_concat (v1.1.2-7-g77ec55b)

├── puppetlabs-pe_console_prune (v0.1.1-9-gfc256c0)

├── puppetlabs-pe_hocon (v2016.2.0)

├── puppetlabs-pe_infrastructure (v2016.4.0)

├── puppetlabs-pe_inifile (v2016.2.1-rc0)

├── puppetlabs-pe_java_ks (v1.2.4-37-g2d86015)

├── puppetlabs-pe_nginx (v2016.4.0)

├── puppetlabs-pe_postgresql (v2016.2.0)

├── puppetlabs-pe_puppet_authorization (v2016.2.0-rc1)

├── puppetlabs-pe_r10k (v2016.2.0)

├── puppetlabs-pe_razor (v1.0.0)

├── puppetlabs-pe_repo (v2016.4.0)

├── puppetlabs-pe_staging (v2015.3.0)

└── puppetlabs-puppet_enterprise (v2016.4.1)

The modules in bold are what im trying to work with.

I cannot get the sqlserver module/classes to identify. I cannot work with sqlserver, says can't find the module.

I can work with puppetlabs-ntp with no problem.

Does anyone have experience with puppetlabs-sqlserver that I may speak with.

My goal is to install sqlserver on my windows 2012 server, which is a puppet node for the record. For the life of me this module will not load and calling the class ends with :

Error: Could not retrieve catalog from remote server: Error 500 on SERVER: Server Error: Evaluation Error: Resource type not found: Mssql_instance at /etc/puppetlabs/code/environments/production/manifests/site.pp:45:17 on node winsql.attlocal.net                                                                          

[Martin Alfke]

There is not type mssql_instance in the module:
https://forge.puppet.com/puppetlabs/sqlserver/types

Did you follow the setup description?
https://forge.puppet.com/puppetlabs/sqlserver/readme#setup

> --
> You received this message because you are subscribed to the Google Groups "Puppet Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/ecc27be9-ea78-4c90-bf6e-51bacc5c4ad8%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

[Ryan Vande]

It says to include in your manifest 

"sqlserver_instance{ 'MSSQLSERVER':

    features                => ['SQL'],

    source                  => 'E:/',

    sql_sysadmin_accounts   => ['myuser'],

}

which I did , the error I got back was " Evaluation Error: Resource type not found: Mssql_instance"

What I did was place the following code in site.pp under the node definition for winsql.attlocal.net :
sqlserver_instance{ 'MSSQLSERVER':

    features                => ['SQL'],

    source                  => 'E:/',

    sql_sysadmin_accounts   => ['myuser'],

}

Either way, The only sql classes I see when trying to designate the appropriate classes to the classification in the console is postgressql 

Doesn't seem this class is loading 

Im new so please correct me where im wrong 

[Martin Alfke]

I can not test the sqlserver module as I don’t have PE with a valid license at hand right now.
Maybe you want to contact PE support:
https://puppet.com/support-services/customer-support?_ga=1.240191875.1487149708.1460034961

> To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/a882181d-f52c-41b0-9c42-446cb4932d36%40googlegroups.com.