Red Gate forums :: View topic - Profiled .NET Application cannot access Properties
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
ANTS Performance Profiler 6
ANTS Performance Profiler 6 forum

Profiled .NET Application cannot access Properties

Search in ANTS Performance Profiler 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Wyllyam



Joined: 14 Mar 2012
Posts: 5

PostPosted: Wed Mar 14, 2012 7:59 pm    Post subject: Profiled .NET Application cannot access Properties Reply with quote

System:
Using Performance Profiler 6.3 Professional.
.NET 4.0
Visual Studio 2010 Premium
Windows XP SP3 with recent patches (as provided by my employer)

Problem:
** Not a Web Application.
Attempting to profile an application to diagnose a slowdown that occurs either during, prior, or after a Sql Server 2008 procedure call to update a single row in a database table.

App starts in the profiler (using the VS 2010 menu for Performance Profiling). But then the app throws an error about not being able to find the server I use. I've confirmed that the app has the correct connection details.

The best guess I have is.. the connection string uses Windows Authentication (can only be used on an intranet) but the profiler might not be cascading those permissions to connect to the server.

Anyone else had issues with getting the profiled apps to connect to Sql Server using Windows Authentication?

Originally I thought the app wasn't getting access to the app.config but ruled that out with a message box.
Back to top
View user's profile Send private message
Wyllyam



Joined: 14 Mar 2012
Posts: 5

PostPosted: Wed Mar 14, 2012 8:19 pm    Post subject: Re: Profiled .NET Application cannot access Properties Reply with quote

Here is an extract of part of the error the app throws while profiling is active:

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
Back to top
View user's profile Send private message
Chris.Allen



Joined: 12 Mar 2009
Posts: 588

PostPosted: Thu Mar 15, 2012 2:00 pm    Post subject: Reply with quote

I am sharing your conclusion that it is a process-runs-under-different-permission-under-profiling problem.

Take a look, using Task Manager, at what account the profiled process is running under and see if this differs from usual.

One quick solution may be to simply run the profiler, explicitly, as administrator (right click on ANTS.UI.exe)
Back to top
View user's profile Send private message
Wyllyam



Joined: 14 Mar 2012
Posts: 5

PostPosted: Thu Mar 15, 2012 2:03 pm    Post subject: Re: Reply with quote

I just checked and it's running under my ID.
Back to top
View user's profile Send private message
Chris.Allen



Joined: 12 Mar 2009
Posts: 588

PostPosted: Mon Mar 19, 2012 2:40 pm    Post subject: Reply with quote

Any luck if you run the profiler, explicitly, as administrator (right click on ANTS.UI.exe)?
Back to top
View user's profile Send private message
Wyllyam



Joined: 14 Mar 2012
Posts: 5

PostPosted: Mon Mar 19, 2012 3:00 pm    Post subject: Re: Reply with quote

Chris.Allen wrote:
Any luck if you run the profiler, explicitly, as administrator (right click on ANTS.UI.exe)?


No luck. I don't have access to the Admin password on the machine.
Back to top
View user's profile Send private message
Wyllyam



Joined: 14 Mar 2012
Posts: 5

PostPosted: Mon Mar 19, 2012 3:07 pm    Post subject: Reply with quote

Just found the issue.

It's not with the ANTS Profiler but with the Firewall that the company I work for installed. the firewall is preventing the app from connecting to the local network.

now I just need to work out with local IT how to get this setting toggled.
Back to top
View user's profile Send private message
Chris.Allen



Joined: 12 Mar 2009
Posts: 588

PostPosted: Fri Mar 23, 2012 4:13 pm    Post subject: Reply with quote

Okey dokey- thanks for letting us know. Sounds like you have a highly secure environment. Just a thought but- if you can set up a virtual machine, you may enable yourself more freedom/privileges...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group