Connect Dreamweaver 2019 to Microsoft SQL Server 2008 r2 Express

Dreamweaver 2019 CC
Win 10, 64 Bit, all patches current
Microsoft SQL Server 2008 r2 Express
SSMS installed using window for credentials
Apache installed

Installed is a software I sell and support for the Point of Sale industry.
Use localhost via Chrome to log into a "Back Office" usually used for reports for the end user / customer. I / we also use it for adding items ect.
1. Fully functioning installation.
2. Successfully login via Chrome "localhost" using default user name and password
##
Goal:
Use Dreamweaver to edit webpages display - padding fonts and adjust some of the tabular displays.

Problem:
No matter the page I chose - in Live Mode (NOT LIVE PREVIEW) displays the login page.

Live preview did ask for login - but then displays the page. I'd really prefer to not work in this manner - but if this is the only solution.

Kindly help me out. Thank you.
R/
Vincent.

See my settings below.

Dreamweaver-settings.png
LocalTesting.png
BasicConnection.png
AdvancedConnection.png
ServerChoices.png
Vincent MillsFounderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CDRetiredCommented:
you need to use sql authentication vs Windows authentication for non windows products or sql server on a different server
Scott FellDeveloper & EE ModeratorCommented:
It has been a long time since I used DreamWeaver and have not loaded the latest version.  Dreamweaver is one of the last Development tools that have a live preview as you work as an all in one product. In the past, the rendering in the preview was not very accurate and more of an approximation.  Now the page can be rendered in Live view which is a chrome browser. You can still use Design View which is the old way. I remember being able to edit password protected pages then. The difference is the representation of the page in Design View will not exactly match Live View.  If you are just using it to add padding and  margin, it will  help give you the approximation. It would be interesting to know if that view works.  

Either way, it is a work around. If you use Live View you have to log in and the other may work without logging in but will not be an exact representation.

Another option you can use if you are just worried about adjusting css files is to view the source of some of your logged in pages, copy and paste the rendered html to your local machine and edit the css (that uses the same css file) for those pages in live view.  Then it is just a matter of uploading the css to the live site/server.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vincent MillsFounderAuthor Commented:
Mr. Johnson and Mr. Fell,

Thank you both for your input and guidance.
Mr. Johnson, using another machine to host the DB and the project is a excellent idea.

To both; I think as I'm only working on aesthetics at this point, I'm going to use the  Live View for now. Not exactly what I wanted but as Mr. Fell mentioned it is a work around.

Thank you again.
Regards,
Vincent.
Vincent MillsFounderAuthor Commented:
Thank you Mr. Johnson and Mr. Fell for your assistance.
Kindly,
Vincent.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.