SqlConnection.Open() Hang

[arran.pearce@online.nospam]

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.O pen().
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

[Atanu]

RE: SqlConnection.O pen() Hang

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.

--
Regards
Atanu


"arran.pearce@o nline.nospam" wrote:
[color=blue]
> 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.O pen().
> 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[/color]

[arran.pearce@online.nospam]

RE: SqlConnection.O pen() Hang

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.

"Atanu" wrote:
[color=blue]
> 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.
>
> --
> Regards
> Atanu
>
>
> "arran.pearce@o nline.nospam" wrote:
>[color=green]
> > 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.O pen().
> > 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[/color][/color]