Login Failed for user ‘sa’.Reason:Not associated with a trusted SQL connection

How to connect to a remote SQL database using c# windows application?

1.First Ensure that Mixed mode authentication is enabled on your SQL Server.

To Enable Mixed Mode authentication Open ENTERPISE MANAGER

a)Right Click the Server under the SQL Server Group node                                (eg. (Local (Windows NT)) and select Properties

b) Under the Security tab Select SQL Sever and Windows and click ok.

2.Create a new login

a) Open Enterprise Manager

b)Open SQL Server Group->Server (Local)(Windows NT)

->Security->Login

c)Right Click Login and Select New Login

d)In General Tab Enter a Login Name & Select SQL Server Authentication and enter a password

e)Under Server Roles tab check all the Roles

f)Under Database Access tab Select the database u want to access remotely and select all database roles except denydatareader & denydatawriter.

g)Click ok to finish.

3.Change the Firewall Settings

a)Goto Control Panel and Select Windows Firewall

b)Under the exceptions tab click Add Program button.

c)In the Add a Program dialog click Browse button and select ProgramFiles ->Microsoft SQLServer->MSSQL1.1->MSSQL->Binn->sqlservr.exe

also select ProgramFiles ->Microsoft SQLServer->90->Shared->sqlbrowser

4.In the client machine goto Control Panel & Select Administrative Tools

a)Select Data Sources(ODBC)

b)In the dialog box that opens click ADD button & select SQL Server & Finish

c)Enter the Database name in the name txtbox and enter the server name & click Next

d)Select SQL Server Auth & Click Client configuration Button.In the Dialog box that opens select Named Pipes radiobutton and click Ok.

e)Enter Login ID & Password u created in step 2 and click Next

5.Use the Follwing Connection String in ur c# appln

connectionString=”Data Source=ServerName;Initial Catalog=DatabaseName;User ID=ssss;password=ssss;”

To find ServerName Goto Programs->MicrosoftSQLServer->ServiceManager

Give the User id and password you created in step 2

Now Run the application

Udhaya

Pisquare

How to bind Combobox to a table field?

Binding ComboBox to a table using Stored Procedure

SqlDataAdapter da = new SqlDataAdapter(“StoredProcedureName”,Connection);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(new SqlParameter(“@Param1”, Value for @Param1));
DataSet ds = new DataSet( );
da.Fill(ds, “TableName”);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = “TableName”;

Binding ComboBox to a table using Command

Connection.Open();

SqlDataAdapter da = new SqlDataAdapter(“select Uname from Table1”, Connection);

DataSet ds = new DataSet( );

da.Fill(ds, “Table1”);
comboBox1.DataSource =ds.Tables[0];
comboBox1.DisplayMember = “Uname”;

Connection1.Close();

Udhaya

PiSquare Soft Solns

How to use DataGrid in C# .Net?

First place the DataGridView Control in the form.In the coding add the namespasce

using System.Data.SqlClient;

then initialize SqlConnection to ConnString as public (i.e)next to public Form1( ) {InitializeComponent( );}

SqlConnection con = new SqlConnection(“Your Connection String”);

DataSet ds;

Inside any event such as Form_load or button1_click add the code

SqlDataAdapter da=new SqlDataAdapter(“select * from table1”,con);

ds=new DataSet();

da.Fill(ds,”table1″);

dataGridView1.DataSource=ds;

dataGridView1.DataMember=”table1″;

By

Udhaya