Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Error while logging Performance Monitor counter to sql server Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 1:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:52 AM
Points: 114, Visits: 991
craigvincent (11/14/2012)
Hi Daxesh,

I've been trying to do a similar thing to you - logging performance data to SQL for two separate machines, which were not part of a domain and have come to the same conclusion that you're unable to use SQL Server Authentication.

Was just wondering if you had come across a workaround in the meantime?

Thanks,

Craig


Hi Craig,

Sorry I didnot update this post after I resolved the issue

- I added entry for remote domain machine in hosts file (C:\WINDOWS\system32\drivers\etc\hosts)

- then created a windows account in both the machin with same UID + Password (as local administrator)
- created SystemDSN for this connection
Edit: - and run Perfom under this account
This worked for me
Post #1384827
Posted Wednesday, November 14, 2012 3:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 29, 2013 4:22 AM
Points: 3, Visits: 11
Thanks greatly for the speedy reply! I'll experiment with that method later.

Best wishes to you,

Craig
Post #1384893
Posted Thursday, November 15, 2012 12:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 29, 2013 4:22 AM
Points: 3, Visits: 11
Thanks again Daxesh, got that setup and working! It's kind of a shame that it can't be done using SQL Server Authentication, but am just glad it's working!

C
Post #1385319
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse