Start a new topic
Answered

installing and configuring SQL on Windows

 Is there a guide for installing and configuring SQL on Windows? I thought there was one on the old forum but I can't find it. In any event I was hoping for something for SQL Express 2016.



1 person has this question

Hi,


SQL Express 2016 is pretty straightforward to install. I think you can just follow the installation guide by clicking Next until it has been installed.


Now you can start Helium 12 and create a new database from the Database Management dialog (CTRL-D). 


  1. Go to the Sql Server tab.
  2. Click New.
  3. Type .\sqlexpress (a dot, a backslash and sqlexpress) in the Sql Server instance name box.
  4. Leave Options at Windows authentication.
  5. Type a database name (anyone you like) in the Database box.
  6. Leave the Image cache folder blank.
  7. Press OK.
Let us know if you run into any difficulties.


1 person likes this
Which package do I need.... Express Core, Express Advanced, or LocalDB. I'd like to install just what's needed for Helium.

 


1 person likes this

@Carl:

You can connect to a SQL Server Express database if you know it's instance name (most likely SQLEXPRESS unless you changed it)


Connect to SERVERNAME\INSTANCENAME e.g. MYSERVER\SQLEXPRESS.


You need to have SQL server authentication enabled as well as a username and password also.

Express Core is enough.

Hey,


What if I have SQLServer Express on my server? What should I do to connect to it?


/Carl

Login or Signup to post a comment