471,338 Members | 1,221 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,338 software developers and data experts.

SqlConnection.Open() Hang

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
Jul 21 '05 #1
2 4098
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
"ar**********@online.nospam" wrote:
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

Jul 21 '05 #2
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:
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
"ar**********@online.nospam" wrote:
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

Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Donnie Darko | last post: by
4 posts views Thread by The Coolest Dolphin | last post: by
4 posts views Thread by Steve Richter | last post: by
2 posts views Thread by arran.pearce | last post: by
4 posts views Thread by Victor | last post: by
5 posts views Thread by fniles | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.