SQLExpress SP2 on Vista RTM = RemoteConection problems.  
Author Message
ewingate





PostPosted: Top

SQL Server >> SQLExpress SP2 on Vista RTM = RemoteConection problems.

Hello to everybody. :D

I have a problem with SQL remote conections when the app is executed by
a standar user on Windows Vista. (No errors occurs in WinXP SP2).

Test machine has Windows Vista RTM + SQLServer Express SP2 (to ensure
Vista compatibility).

I have a desktop application (build on C# VS2005). DataAccess is via
WebService (build on ASP.NET w/C# again VS2005).

WebService, database, and applicatión is on the same machine.

When i run my app with an admin user, it works perfect. But when
executed by an standar user, it throws the following error:

"An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections."

So i have used Surface Area Configurator to allow remote connections,
let ServerBrowser to run automatically, and everything else stated on
MSDN and other pages. I have excluded SQL app in the firewall. But
nothing has solved the error.

Take in count:

(My problems are in WinVista RTM and just in WinVista)

1) Admin User executes app = everything works.
2) Standar User executes app = SQL throws an error.
3) Standar User opens session, and executes the app "as administrator" =
SQL throws the exception: "no connection could be made because the
target machine actively refused it"

Any advice is well received.

Thanks a lot for read this topic.

SQL Server28