165 reputation
17
bio website
location
age
visits member for 2 years, 3 months
seen Aug 6 at 17:34

May
14
comment ODBCs by Application
@tegbains A few days ago, yes. They are slow to get the ball rolling for this case, but they did tell me yesterday via email that they want to create an advisory case to pursue this (I initally reported via PartnerSource as a break-fix issue). I don't know where MSFT is or what they are doing at this point, but eventually they will probably help.
May
12
comment ODBCs by Application
As an administrator, it is easy to lock-down which GP application can be launched by which user. And user DSNs can be specified to limit which users can access which SQL instances/ODBCs/DSNs. However, in the case of a user with access to multiple GP applications and multiple SQL instance (ex. a power user), why should he/she be able to run "GP application A" with "SQL instance B"? I should not be able to do this. GP A should match up with SQL A, GP B with SQL B, and so forth...a 1:1 relationship.
May
12
comment ODBCs by Application
A GP instances requires (1) a unique GP installation directory and Dynamics.exe application, and (2) a unique SQL instance (not database, I truly mean SQL instance--as in a unique install of SQL). If a user launches a GP application on a server, when they attempt to login, they will be prompted to select to which "Server" (meaning SQL instance/ODBC) they want to connect.
Apr
22
comment Name Mismatch - Incorrect Remote Computer Name
Well, how come there is no issue with a mismatch related to the other servers--none of which have an explicit listing within the certificate which includes their private IP addresses? I've taken the same approach for all servers, but four of them work fine, and one of them gives this name mismatch warning/error.
Apr
22
comment Name Mismatch - Incorrect Remote Computer Name
My only concern is that, while your solution will get rid of the problem, I am still lost as to why one server on the network handles the certificate just fine...while this server has the mismatch issue. I am just not sure if there is something else wrong with the server, like some other reference to the old domain. I have never done a domain rename before, and never worked with W2012 either, so I am hesitant to implement workarounds when a more fundamental problem might be looming.
Jan
27
comment Fast Compression of Database Backups
My results with this were not as good as yours. It was still many more hours than 2 for me.
Jan
3
comment Fast Compression of Database Backups
SQL 2008R2 64bit. 7zip has been able to compress to about 15% of the original file size, in my experience. This is really good, in my opinion, but I would be willing to sacrifice some compression for quicker compression times (or less demanding compression processes). 7zip does not seem to improve its compression times much with lesser compression levels in my experience.
Jun
13
comment Access Denied for Specific FTP Client
When I did netstat -np TCP | find "20", I was able to get two ESTABLISHED connections listed. When I tried the same command on 21, 22, and 990, I did not get any listings. I don't know if this was the right test or what these results mean either. I think it means 20 is open, but I don't know about the others.
Jun
6
comment Access Denied for Specific FTP Client
2008 R2 boxes, Filezilla software. I edited post to include.
Feb
11
comment Performance Counters in Perfmon/Server 2008 R2
Thank you. That is a very important revelation about which counter to use. Since % Committed Bytes is the correct counter for what I really want, how should I interpret the graph information related to that counter? I assume using the Line Graph reporting format and having a scale of 1.0 leaves me with about 11% of memory usage, as I indicated above. If I do "Report" as my format, I just receive a single number of 10.368.