SqlConnection.Open() Hang (Repost at MS Request)

[arran.pearce]

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 am using SQL Authentication.

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

[Kevin Yu [MSFT]]

Hi Arran,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that SqlConnection.Open method hangs when
you login as a standard user. If there is any misunderstanding, please feel
free to let me know.

Since .NET framework 2.0 hasn't been released yet, it's still a beta
version. We are still working to fix problems in it. For .NET framework 2.0
questions, besides posting here, you can also post in the following
newsgroup. It's dedicated in ADO.NET 2.0 questions.

http://forums.microsoft.com/msdn/Sho...spx?ForumID=45

Also, I will help you to report this to the development groups. Thanks for
your feedback!

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[arran.pearce]

Yeah thats correct. If the application runs as the administrator then it
connects fine, however if its run as another user the .Open() hangs
indefinatly.

I get the impressing this is not a bug as i have found out that it also
happens with some other services. Such as WebService calls.

Could this be a permission thing? Something new in .NET v2? Something to
do with CAS?
"Kevin Yu [MSFT]" wrote:

Hi Arran,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that SqlConnection.Open method hangs when
you login as a standard user. If there is any misunderstanding, please feel
free to let me know.

Since .NET framework 2.0 hasn't been released yet, it's still a beta
version. We are still working to fix problems in it. For .NET framework 2.0
questions, besides posting here, you can also post in the following
newsgroup. It's dedicated in ADO.NET 2.0 questions.

http://forums.microsoft.com/msdn/Sho...spx?ForumID=45

Also, I will help you to report this to the development groups. Thanks for
your feedback!

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Kevin Yu [MSFT]]

Hi Arran,

As I stated, the .net framework 2.0 is still in beta version. The features
might change in the future. So we are also not quite sure about it. Thanks
for your understanding.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Sean]

I am getting the same results using .Net Framework 1.1 when the remote server
I'm connecting to is not responding, and I am running as administrator. When
SQL Server is stopped, it times out and I get an exception, but when the
physical server is turned off, the script just hangs at SqlConnection.Open().

Is there a way around that, or do I need to add in a check for the server
before connecting to the database?

Thanks,
Sean

"Kevin Yu [MSFT]" wrote:

Hi Arran,

As I stated, the .net framework 2.0 is still in beta version. The features
might change in the future. So we are also not quite sure about it. Thanks
for your understanding.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."