HTTPS Orion Database Error

Replace all of the ’ with '. For some reason the single quote does not always cleanly come across the browser, so it modified all of my '.

Thank you!

I don't understand what you replaced a single quote with... What key is that? I would love to resolve my issue of the same cause -_-

The single quote characters basically comes in two varieties.

One is directional (e.g. left single quote and right single quote):

‘  ’

Another is non-directional (e.g. straight quotes):

' '

Microsoft Office is a big pain for me a lot of times for this because it defaults to the directional quotes, which they call "smart quotes". You can disable this in Options > Proofing > AutoCorrect Options > AutoFormat.

Half of the time, I paste my query into a simple text editor and just re-type the quotes... just in case

hrm, I have typed the exact query into the table, pasted from notepad and wordpad. Still no luck! I receive the same message

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near "SSLEnabled".

I'm about to give up for the day...

Try this:

USE OrionDB
UPDATE dbo.Websites 
SET ServerName='xxx', Port=443, SSLEnabled=1 
WHERE Type='primary'

Obviously make necessary substitutions for OrionDB and xxx.

Commas are missing from the example given (and the quotes are some funny character)

If you don't understand SQL I'm kind of reticent to give this kind of instruction because mistakes could break a lot of stuff

I would go into the database manager on the server and use the editor

because you can change the values cell-by-cell and know you're not messing anything up.

Just to be certain that I've completed the steps outlined in the linked guide in the OP. If I edit the table one cell at a time would I then need to change the query statement as well? #notadatabaseguru

I understand your apprehension in not giving advise about editing the SQL database but it is on a VM and I can revert it, not to mention it is still in testing/setup phase.

If you edit the table using the Database Manager then you don't need to execute the query statement. RichardLetts​ is right, if you're not comfortable with T-SQL, then using the provided GUI (or the Edit Rows feature in SQL Management Studio) is probably your best bet.