Home / user-4839

Jeremy Stein's questions

Martin Hope
Jeremy Stein
Asked: 2010-10-19 13:04:00 +0800 CST
  • 0

We upgrade BizTalk 2006 R2 to BizTalk 2009, upgrading SQL Server 2005 in-place to SQL Server 2008 at the same time.

The BizTalk admin console is excessively slow. After making some change (say, adding a receive port), just refreshing the view can cause a timeout error:

BizTalk Server 2009 Administration Console

Failed to load Group [ServerName:BizTalkMgmtDb] data providers. (Microsoft.BizTalk.Administration.SnapIn)

ADDITIONAL INFORMATION:

Failed to load Group [ServerName:BizTalkMgmtDb] data providers. (Microsoft.BizTalk.Administration.SnapIn)

Instance of the WMI class is not found. (WinMgmt)

BizTalk Server cannot access SQL server. This could be due to one of the following reasons:

  1. Access permissions have been denied to the current user. Either log on as a user that has been granted permissions to SQL and try again, or grant the current user permission to access SQL Server.

  2. The SQL Server does not exist or an invalid database name has been specified. Check the name entered for the SQL Server and database to make sure they are correct as provided during SQL Server installation.

  3. The SQL Server exists, but is not currently running. Use the Windows Service Control Manager or SQL Enterprise Manager to start SQL Server, and try again.

  4. A SQL database file with the same name as the specified database already exists in the Microsoft SQL Server data folder.

Internal error from OLEDB provider: "Timeout expired"

or sometimes the internal error is:

Internal error from OLEDB provider: "[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation."

Sometimes, just expanding the Applications node, I get this error:

Exception has been thrown by the target of an invocation. (MMCEx)

ADDITIONAL INFORMATION:

ExecuteReader requires an open and available Connection. The connection's current state is connecting. (System.Data)

Any suggestions as to how I can debug this?

sql-server-2008 biztalk-2009
Martin Hope
Jeremy Stein
Asked: 2010-05-05 10:20:18 +0800 CST
  • 3

Suppose my PATH is C:\WINDOWS\system32\;C:\Program Files\Important\

SET NEW_PATH=C:\My\Dir\
SETX PATH "%PATH%;%NEW_PATH%"

Results in a path of:

C:\WINDOWS\system32\;C:\Program Files\Important\;C:\My\Dir"

Notice the quotation mark at the end of the path. It's as though the backslash at the end of %NEW_PATH% escaped the final quote mark. I need the quotation marks because I have spaces in my path, but I don't want backslashes to be interpreted as escape characters.

What's the right way to include my PATH in the call to SETX?

windows-server-2003 environment-variables batch-file
Martin Hope
Jeremy Stein
Asked: 2010-05-01 05:17:21 +0800 CST
  • 1

I use a VM through RDP. When I'm done for the day, I just disconnect the session and reconnect in the morning. That allows me to pick up what I was doing and not close all the applications. As I'm the only user, this generally works well.

Today, I can't reconnect to my session from yesterday. When I RDP, I get a new session. When I run query user, I can see my other session:

 USERNAME   SESSIONNAME   ID  STATE   IDLE TIME  LOGON TIME
 me         rdp-tcp#82     1  Active      15:00  4/22/2010 9:00 AM
>me         rdp-tcp#91     2  Active          .  4/30/2010 9:00 AM

If I try to use Terminal Services Manager to remote control the other session, I get this error:

Session (ID 1) remote control failed
(Error 7044 - The request to control another session remotely was denied. )

Is there any way to reconnect to this session, or do I need to just kill it?

windows-server-2003 rdp
Martin Hope
Jeremy Stein
Asked: 2009-08-06 07:02:42 +0800 CST
  • 0

We have a SQL Server 2005 database that is used by various programs developed over the years. Most of these programs access the database using the sa login. My job is to figure out what system uses the database for what purpose so we can start creating logins with appropriate permissions or otherwise manage access.

I want to know, for a given connection, what IP logged in and what statements were executed. How can I get this information, and can I do it without significantly slowing the database server?

sql-server-2005
Martin Hope
Jeremy Stein
Asked: 2009-07-20 21:28:16 +0800 CST
  • 1

My client is running Tomcat 5.5 and is using SSL. Their certificate is about to expire and they have purchased a renewal. I was given a .cer file and asked to update Tomcat.

The existing server.xml contained the following connector:

<Connector port="443" maxHttpHeaderSize="8192"
           maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
           enableLookups="false" disableUploadTimeout="true"
           acceptCount="100" scheme="https" secure="true"
           clientAuth="false" sslProtocol="TLS"
           keystoreFile="companyname.keystore" keyAlias="tomcat2" />

I ran %JAVA_HOME%\bin\keytool -list -keystore companyname.keystore

Keystore type: jks
Keystore provider: SUN

Your keystore contains 3 entries

root, Aug 7, 2007, trustedCertEntry,
Certificate fingerprint (MD5): 8F:5D:77:06:27:C4:98:3C:5B:93:78:E7:D7:7D:9B:CC
tomcat, Jun 12, 2007, keyEntry,
Certificate fingerprint (MD5): 33:80:6F:75:5A:B4:BC:C7:7A:7D:4F:3F:FA:C0:95:2F
tomcat2, Jun 14, 2008, keyEntry,
Certificate fingerprint (MD5): 0A:9B:73:6A:EE:2F:18:99:61:49:28:F3:CD:1E:DF:96

SSL still works if I delete the entry with the alias "tomcat". I'm assuming that's an artifact from a previous expired certificate.

%JAVA_HOME%\bin\keytool -import -keystore companyname.keystore -alias tomcat3 -file 2009cert.cer

I updated server.xml to set keyAlias to tomcat3. When I restart Tomcat, I see this in the log:

SEVERE: Error initializing endpoint
java.io.IOException: Alias name tomcat3 does not identify a key entry
    at org.apache.tomcat.util.net.jsse.JSSE14SocketFactory.getKeyManagers(JSSE14SocketFactory.java:143)
    (etc.)

When I re-run the keytool -list command:

Keystore type: jks
Keystore provider: SUN

Your keystore contains 4 entries

root, Aug 7, 2007, trustedCertEntry,
Certificate fingerprint (MD5): 8F:5D:77:06:27:C4:98:3C:5B:93:78:E7:D7:7D:9B:CC
tomcat, Jun 12, 2007, keyEntry,
Certificate fingerprint (MD5): 33:80:6F:75:5A:B4:BC:C7:7A:7D:4F:3F:FA:C0:95:2F
tomcat3, Jul 21, 2009, trustedCertEntry,
Certificate fingerprint (MD5): 8E:9F:F9:52:7B:07:B1:DB:BF:F3:96:BD:5F:49:2E:9F
tomcat2, Jun 14, 2008, keyEntry,
Certificate fingerprint (MD5): 0A:9B:73:6A:EE:2F:18:99:61:49:28:F3:CD:1E:DF:96

Does this have something to do with the tomcat3 entry being marked as "trustedCertEntry" rather than "keyEntry"?

What am I doing wrong?

tomcat ssl