Error in connecting to Sql Server 2014 database

Question

1.00/5 (1 vote)

See more:

SQL-Server-2014

I have a database in SQL Server 2014 and want to fill a ComboBox from one column from one of the tables in the database. Here is the code with which I did it:

C#

string connectionString = null;
        SqlConnection connection;
        SqlCommand command;
        SqlDataAdapter adapter = new SqlDataAdapter();
        DataSet ds = new DataSet();
        string sql = null;
connectionString = "Data Source=IMRAN-PC;Initial Catalog=MyFirstSqlDbDataSet;Integrated Security=true";
            sql = "select * from CourseInfo";

            connection = new SqlConnection(connectionString);

            try
            {
                connection.Open();
                command = new SqlCommand(sql, connection);
                adapter.SelectCommand = command;
                adapter.Fill(ds);
                adapter.Dispose();
                command.Dispose();
                connection.Close();

                cboCourse.DataSource = ds.Tables[0];
                cboCourse.ValueMember = "ID";
                cboCourse.DisplayMember = "[Course Number and Name]";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Connection Error");
            }

The problem is, when I run the application, the following error is given:
"Cannot open database "MyFirstSqlDbDataSet" requested by the login. The login failed.
Login failed for user 'imran-PC\Anas'."

Can anyone tell me the reason for this problem and the possible solution for this problem?
I also want to know which username and password have to be entered in connection string if using Sql Server authentication. Thanx in advance for help.

Posted 7-Jul-14 6:06am

Anas Tasadduq

Add a Solution

Comments

[no name] 7-Jul-14 12:14pm

If you want to use SQL Server authentication then you would need to put the username and password in your connection string. What those are we could not tell you since you would have been the one that created them.

Anas Tasadduq 7-Jul-14 12:51pm

And how can I create this username and password?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Answer 1 · 2014-07-07T07:13:00

1.For creating DB user credentials (user name and password) you have to use SQL Management Studio and first create a SQL Server login account (user for the entire SQL server), then go into the Security Section of your database an use the created login account to create a user of your database, finally give DBO rights to the created DB user.

2.The next step is to change the connection string for the new created DB user credentials like in the next example:

C#

connectionString = "server=ServerName;database=MyFirstSqlDbDataSet;user=Anas;password=ChangeMe123!";

You can see above that the "ServerName"is the value for your SQL Server Instance (and could be also given as IP in your LAN), the DB user name is "Anas" and its psssword is "ChangeMe123!".

3.To create the DB login account and DB credentials you can use also SQL commands like in the next example:

SQL

CREATE LOGIN [Anas] WITH PASSWORD=N'ChangeMe123!', DEFAULT_DATABASE=[MyFirstSqlDbDataSet], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [MyFirstSqlDbDataSet]
GO
CREATE USER [Anas] FOR LOGIN [Anas] WITH DEFAULT_SCHEMA=[dbo]
EXEC sp_addrolemember 'db_datareader', 'Anas'
EXEC sp_addrolemember 'db_datawriter', 'Anas'
GO