How to connect to SQL server express edition software?

Asked By Nicholas B Davis 10 points N/A Posted on - 03/22/2013

Hi. I have developed a project using ASP.NET, PHP, C# and connected to SQL server xpress edition software but when I execute project, it does not accept default user name and pass. I have checked all files and coding but user account does not work. Please help me as everything of project is working properly.

• Status: Open
• Question Views: 644
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Lorraine P Goodman 30 points N/A #130151

How to connect to SQL server express edition software?

 

Hi Emileekeila

Good day!!

The following code fragment opens a new SqlConnection, displays the connection string in the console window, and then closes the connection when exiting the using code block. You can follow this step.

private static void OpenSqlConnection()

{

    // Retrieve the connection string.

    string connectionString = GetConnectionString();

    using (SqlConnection connection = 

        new SqlConnection(connectionString))

    {

        connection.Open();

        Console.WriteLine("ConnectionString: {0}", 

             connection.ConnectionString);

    }

}

Thanks 

Sincerely,

Lorraine P Goodman

About Lorraine P Goodman

Questions
25

Answers
97

Best Answers
17

• Vote Up 0 Vote Down

• Posted on - 04/18/2013
• Question Category: MS SQL Server