I have a simple C# 2.0 app that performs a simple query.
SqlConnection oSqlCon=new SqlConnection(strConnectStr);
SqlCommand oSqlCmd=new SqlCommand("select Name from Person",oSqlCon);
I has been working fine. A client recently installed SQL2005 (their old version is SQL2000). When executing the above code on a machine other than the server no rows are returned. The connection uses sqlserver authentication, not integrated authentication.
To summarize: the above code works against the old sql instance from both the server machine and other local network machines; works against the new sql instance only from the new server; does NOT work against the new sql instance from local network
There are no errors reported; the query simply acts as though the table has no rows. I believe this to a security/permission issue but the two slq instances appear to be configured identically.
Any ideas or suggestions would be appreciated.
View Complete Post