[dbca]

Trying to update record in SQL Server database and having trouble making the connection to the database:

            SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();

            builder.DataSource = @".\SQLEXPRESS";
            builder.InitialCatalog = "database";
            builder.IntegratedSecurity = true;

            SqlConnection linkToDB = new SqlConnection(builder.ConnectionString);
            linkToDB.Open();

            using (linkToDB)
            {
                commandWrapper.Connection = linkToDB;
                commandWrapper.ExecuteNonQuery();
            }

When I execute the code I receive the following error:

Cannot open database "database" requested by the login. The login failed.
Login failed for user 'computername\username'.

Line 151:
Line 152: SqlConnection linkToDB = new SqlConnection(builder.ConnectionString);
Line 153: linkToDB.Open();
Line 154:
Line 155: using (linkToDB)


The error is at Line 153 ->
How can I open the connection to the database? Any ideas?

[h4nnib4l]

Check out www.connectionstrings.com for help setting up the parameters of your connection string. I don't know which version of SQL Server you're using, but there is plenty of examples for SQL Server Express at the bottom of the SQL Server 2008 entry, for example. This has some good information about connection strings to help.

[rgfirefly24]

You need to make sure that the user that is trying to access the database actually has rights to do so. if you download Sql Server Management Studio and connect to your SQL express instance you are able to dive into the database security to find out which logins have access to the database.