SqlConnection.Open() Hang

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am using .NET 2 (beta2) and are having problems with using a SqlConnection.

I have created a test application that opens a sql connections, gets some
basic data and then closes the connection.

When i run this application as the administrator it works fine. However if
i run the application as a standard user the application hangs indefinatly on
SqlConnection.Open().
I dont get any time out, no exceptions nothing. It just hangs there.

I have tested this on many computers and the same happens.

My main issue is getting this to work on Windows2000 Server (Sp4).

thanks

Arran
 
Although u'v not mentioned, i guess u'r using Windows account informations.
If its not an issue try SQL-Server login info. If you can't change login
procedure then u'v to look into the permission stufs of the windows users
who'r being restricted.
 
Sorry i forgot to say, for the connection i am using SQL Auth not windows auth.

The test application works fine for a administrator just not for a normal
user. I have tried to give the normal user full access to the Register &
File system (just as a test) and that did not work.

I also made the user a Power User and that did not work either. If i make
the user a administrator it works fine.
 
Back
Top