Connect to SQL on same machine! help

[darXstar]

Hi. I've this question: I have IIS (and dot net environment) and MS SQL msde on same machine (MS Windows 2000 server). For security reason I've switched off all network protocols of Sql. (sql is listening on shared memory) Is it still possible to connect to sql (not using odbc) ?? I nedd to modify my ADO.NET connection string? Could someone showme an exemple? thanks to anyone.

[Colin Angus Mackay]

darXstar wrote: Is it still possible to connect to sql (not using odbc) ?? I've never tried that configuration, but it should be possible. darXstar wrote: I nedd to modify my ADO.NET connection string? darXstar wrote: I nedd to modify my ADO.NET connection string? I wouldn't think so, why not just try it? I've got loads of apps lying around that were just to try out something where the docs didn't give a complete explanation or I just wanted to see how something worked in isolation. darXstar wrote: Could someone showme an exemple? Of what? Connecting to a SQL Server database using ADO.NET.

string connectionString = "server=(local);database=myData;uid=a;pwd=b";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "myStoredProcedure";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
SqlReader reader = cmd.ExecuteReader();
while(reader.Read())
{
// Do stuff to process the information being returned from
// the database
}

Does this help?

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[darXstar]

Hi, and thanks for reply. You have right. Why don't try? The truth is that I was almost sure this configuration was working on my test server... but today doesn't work anymore... While I keep switched off TCP protocol of sql server, I can not access it from asp.net web applications. the result is "Server doesn't exist or access denied". I am little bit confused... I can't tell if this configuration should work or not... About connection string I was asking someone if there are a specific one using "Shared Memory" access mode. anyone is experienced? thanks again