Justin's questions

I am trying to install elasticsearch and kibana on a single Ubuntu 18 vm per the docs. Elasticsearch Installation and Kibana Installation

NOTE: - I set the ES_HEAP_SIZE env var to half the memory of the VM OS - I set netplan for a static IP on the VM: 10.1.2.10 or whatever - I set the ulimits to unlimited so Lucene can have free reign over documents - I add the Elasticsearch service to start on reboot - I configure the yml file: network.host: 0.0.0.0

Elasticsearch works fine once it has been installed and configured per the docs.

After installing Kibana, enabling the service, starting the service, configuring the yml, restarting the service, etc

the service will not run

I have tried combinations like the following for the kibana.yml file:

server.host: "localhost"

server.host: "localhost"
elasticsearch.hosts: ["localhost:9200"]

server.host: "localhost:5601"
elasticsearch.hosts: ["localhost:9200"]

server.host: "0.0.0.0"
elasticsearch.hosts: ["localhost:9200"]

server.host: "10.1.2.10"
elasticsearch.hosts: ["10.1.2.10:9200"]

server.host: "10.1.2.10:5601"
elasticsearch.hosts: ["10.1.2.10:9200"]

server.host: "0.0.0.0"
elasticsearch.hosts: ["10.1.2.10:9200"]

etc, etc, etc

Can anyone please help with this config? Everything I can find seems to leave things "localhost" but I am assuming because I am running this on vm and accessing from another this is the problem with config/Kibana. As I said I am able to access the 10.1.2.10:9200 message that Elasticsearch returns from that other machine just fine.

Thanks

I have tried to download SQL Server 2005 Express edition about 4 times trying to find the correct version that has business intelligence studio and reporting services in it?

Every time I try to unhide the advanced configuration during install, it's never there...

Can anyone point me to the correct download?

Looking for 2005 (not 2008) because my work SQL server that I am trying to learn this for is 2005, and the training material I have is for 2005 and VS 2008 does not want to integrate with SQL2008 express.

not sure I understand this but I am going to throw my assumption out there:

SQL Server 2008 Standard & Enterprises editions are for running full database services on server (not just but for comparative sake),

and SQL Server Developer Edition is what, an IDE for developing programs around SQL Server???

not sure I understand?

So SQL express in hosted on a machine, and I am assuming that SQL Enterprise or Standard is hosted on a dedicated server or something??

So I am a total rookie at this and am looking for learning resource for the host/connection/server side of this.....

Can anyone point me in the right direction please?

Thanks

So SQL Server 2005 Express edition has the following connection string by default, which enables user instances instead of Concurrrent Multi-User Access:

Data Source=.\SQLExpress;
   AttachDbFileName=|DataDirectory|\dash.mdf;
   Integrated Security=True;User Instance=True

So my question is just simply is this the same for SQL Standard, or SQL Enterprise?

I know the database development aspect, but implementing on a server, I am a rookie.

So on that note, any learning resources you can offer would be highly appreciated!!

Thanks