Error in Sqlconnection

Smart Lucky

Hi

can any one help me why is error occured .....?

And i am using conneciton in this way..

SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionStringNew"]);

Cannot open database "aTestingDB" requested by the login. The login failed.
Login failed for user 'KBBALOCH-PC\KBBALOCH'.

And

I am using dataset and update the dataset column like below and when i call it , it show th updated result in gridview . but it is not updating the database why can nay one help me....?

ds.Tables[0].Rows[9]["name"] = "Khuda bux";

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
check this article to find actual connection string:

Find Database Connection and Generate Connection String using Visual Studio
0
Abhimanyu K Vatsa15y ago
[Login failed for user 'KBBALOCH-PC\KBBALOCH'.]

it seems like there is no proper security setup.

You have SQL Server set up to use Windows Authentication. Unless you are using Windows Authentication exclusively throughout your web site, you should have SQL Server set up to authenticate using mixed mode - this allows support for Windows Authentication AND passing credentials via clear text (e.g. a connection string from ASP.net). To make sure SQL Server is set up to be in mixed mode:
Open Enterprise Manager;
Expand a server group;
Right-click a server, and click Properties;
Click the Security tab;
Under Authentication, click SQL Server and Windows.
Now, make sure you have a valid user set up to access your tables, views and procedures.

hope this helps
0
15y ago
1) Please check the user has the permission to access the database.
2) After ds.Tables[0].Rows[9]["name"] = "Khuda bux"; this statement, have you called , ds.Tables[0].AccessChanges()?
0
Krishna Garad15y ago
either database name is incorrect or Data source is incorrect or credentials are not valid in your connection string.
0