InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 22:20:51 GMT20http://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxThanks 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!CThu, 15 Nov 2012 12:42:57 GMTcraigvincenthttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxThanks greatly for the speedy reply! I'll experiment with that method later.Best wishes to you,Craig :-)Wed, 14 Nov 2012 15:03:17 GMTcraigvincenthttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspx[quote][b]craigvincent (11/14/2012)[/b][hr]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:-)[/quote]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 connectionEdit: - and run Perfom under this accountThis worked for meWed, 14 Nov 2012 13:05:49 GMTDaxesh Patelhttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxHi 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:-)Wed, 14 Nov 2012 10:32:01 GMTcraigvincenthttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxI think I found the issue (not the solution)odbc does not store sql login information (UID & PWD), and user needs to supply uid and pwd while using the odbc.Only windows authentication works when PerfMon uses odbc to store data in SQL serverI think I cannot send Perfmon data to a different domain sql server since I cannot use windows authentication in this case.I need to find out some workaroundWed, 23 May 2012 14:23:43 GMTDaxesh Patelhttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxServer properties looks fineIt is single instance (default only) SQL serverMixed mode (using sql logins since long time on this server)Login which I am using in odbc is active and it works fine when I am connecting using SSMSOnly it does not work when perfmon tries to use odbc (remote sql)That's why I asked, has anybody setup perfmon writing counter data to remote sql server? any special setting required for that? And yes, I verified with our network admin, nothing is blocking at firewall sideTue, 22 May 2012 17:06:32 GMTDaxesh Patelhttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxOnly thing I can suggest at this point is to double check your server properties.Tue, 22 May 2012 14:37:10 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxThanks Lynn,I have attached word doc with screen shotsTue, 22 May 2012 14:30:38 GMTDaxesh Patelhttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspx[quote][b]Daxesh Patel (5/21/2012)[/b][hr]I am trying to do following task and I donot know it is possible in this setup or not?I am trying to setup performance counter on a non-domain server (Server1)All the performance counter values I want to capture in other sql server (Domain\Server2)In this task I donot want to establish any kind of connectivity from Server2 to Server1 (sql or windows), but I want to push data from Server1 to Server2. - I have a sql login (monitoruser) in Server2 with sysadmin role - and created a ODBC connection (perfmon) in Server1 using monitoruser (successfully tested) - created a datacollector set on Server1 running as local administrator (localMachine\sqlmon)When I an trying to start this collector set, it throws "Error: Call to SQLAllocConnect failed with %1" on Server1On Server2 Eventlog says, Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: xx.xx.xx.xx]I have both the server running in mixed mode (I also restarted sql services on both)I can connect Server2 from Server1 using SSMS with monitoruser loginWhat else I am missing here?Thanks in advance[/quote]How do you have the ODBC connection configured? Can you show it to us?Tue, 22 May 2012 14:04:31 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxOK I tried to setup on both the server in same domain, still it gives me same error.Anybody has tried to store perfmon data into [u]remote SQL server[/u] using [u]odbc [/u](and [u]sql login[/u])?Tue, 22 May 2012 14:02:13 GMTDaxesh Patelhttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxThank you RBarryYoungNo, there is no other sql instance, only default instanceTue, 22 May 2012 04:06:39 GMTDaxesh Patelhttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxAre there any other SQL Server instances on these two servers? Is it possible that you are actually connecting (or trying) to one of them and that SQL instance has Windows-only authentication.Mon, 21 May 2012 21:39:43 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic1303434-1526-1.aspxI am trying to do following task and I donot know it is possible in this setup or not?I am trying to setup performance counter on a non-domain server (Server1)All the performance counter values I want to capture in other sql server (Domain\Server2)In this task I donot want to establish any kind of connectivity from Server2 to Server1 (sql or windows), but I want to push data from Server1 to Server2. - I have a sql login (monitoruser) in Server2 with sysadmin role - and created a ODBC connection (perfmon) in Server1 using monitoruser (successfully tested) - created a datacollector set on Server1 running as local administrator (localMachine\sqlmon)When I an trying to start this collector set, it throws "Error: Call to SQLAllocConnect failed with %1" on Server1On Server2 Eventlog says, Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: xx.xx.xx.xx]I have both the server running in mixed mode (I also restarted sql services on both)I can connect Server2 from Server1 using SSMS with monitoruser loginWhat else I am missing here?Thanks in advanceMon, 21 May 2012 08:59:17 GMTDaxesh Patel