Dreamweaver - SQL Server Connetion/Connection String

Posted on 2014-08-29
Last Modified: 2014-09-07
I've done this before, with ODBC, but having an issue configuring with SQL express.

In Dreamweaver, it gives you the following to setup your connection string:
Persist Security Info=False;                  
Data Source=[serverName];
Initial Catalog=[databaseName];
User ID=[username];

I assume serverName is my local workstation - i.e., localhost
My test databaseName is simply TestDB
Unsure about Persist Security?
Re: username and pw - Do I need this?

Any help that can be provided would be great!
Question by:edalzell
    LVL 82

    Assisted Solution

    by:Dave Baldwin
    Here are lots of connection strings for SQL Server.  SQL Express can use ODBC also thru the SQL Native Client.  If you are on the same machine as the SQL Express Server, then SQL Native Client is installed with it.  If you are on a different machine, then you need to download it and install it.  For what it's worth, I have never seen an SQL Server connection string using 'localhost'.  I don't believe you can set up 'localhost' in the SQL SErver configuration.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    SQL Server Express uses a named instance so the sever becomes something like this:

    Assisted Solution

    This helps a lot - but, silly question re: the 'User ID=myDomain\myUsername;Password=myPassword' section.
    Do I need to apply this security to the database in SQL express? Thanks!
    LVL 75

    Accepted Solution

    This helps a lot - but, silly question re: the 'User ID=myDomain\myUsername;Password=myPassword' section.
    This cannot be correct.  If you are using myDomain\myUserName, then you are using a Trusted (Windows Authentication) Connection and the password is not neccesary.  If on the other hand you are using SQL Server Authentication than the myDomain\ would not apply.

    So first you need to ask yourself what type of Login in SQL Server you have created.  Second as previously suggested go to the following link to build a valid connection string:

    Author Closing Comment

    Works, thanks! :-)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now