Hi,

I am trying to connect to a local SQL Server on the Network using the
following code in Beta2(System.Data.SqlClient).

#####

string sConn = "User ID=sa;Pwd=;Database=lib;Server=rukku;Integrated
Security=false";

string sCommand = "SELECT max(book_id)from book_details";
SqlCommand myCommand = new SqlCommand(sCommand);
myCommand.Connection = new SqlConnection(sConn);
myCommand.Connection.Open();

#####

But I am getting a SecurityException.

Do I need to setup special permission on the SQL Server before executing
these statements, because I am getting some Permission problems.The error is occurring at the Open() statement. Can anyone help !


Regds,
Mahabeer