connectivity issue

[purushoth]

Hi all,

i am using SourceOffSite 4.1.2 with visual sourcesafe6.0a on the server, i can able to connect to the server without any issues. but after i upgrade the visual sourcesafe server 6.0d on the server, i am not able to connect to the sourceoffsite server. its throwing me the error,
"Exception during Login: QueryInterface for interface SourceSafe TypeLib.IVSSDatabase failed". pls help me on this issue,

My server log shows the following:

9/15/2006 1:18:57 PM - Connection accepted from 20.x.x.x:26026 on local address 20.x.x.x:8880, session id is 1.
9/15/2006 1:18:57 PM - 1: Enter Authorized()
9/15/2006 1:18:57 PM - 1: Connection from: laptop (20.x.x.x) 9/15/2006 1:18:57 PM - 1: Preparing to send the list of databases... 9/15/2006 1:18:57 PM - 1: Sending the challenge to the client. 9/15/2006 1:18:57 PM - 1: Sending the challenge message body to the client. 9/15/2006 1:18:57 PM - 1: Waiting for the client's response...
9/15/2006 1:19:00 PM - 1: Reviewing the client's response...
9/15/2006 1:19:00 PM - 1: Process the client's crypto login request. 9/15/2006 1:19:00 PM - 1: Enter Login()
9/15/2006 1:19:00 PM - 1: User 'krish' requesting to login to database 'F:\Copy of database for testing\srcsafe.ini'
9/15/2006 1:19:00 PM - 1: Client is speaking protocol version 2.0

9/15/2006 1:19:00 PM - 1: Attempting to login WITH crypto.
9/15/2006 1:19:00 PM - 1: Verify the challenge string.
9/15/2006 1:19:00 PM - 1: Get the session key.
9/15/2006 1:19:00 PM - 1: Open the database.
9/15/2006 1:19:01 PM - 1: Exception during Login: QueryInterface for interface SourceSafeTypeLib.IVSSDatabase failed.
9/15/2006 1:19:01 PM - 1: Exit Login()
9/15/2006 1:19:01 PM - 1: Enter KillConnection()
9/15/2006 1:19:01 PM - 1: User krish disconnected from laptop.
9/15/2006 1:19:01 PM - 1 - Exit KillConnection()


thanks & regards,

purushothaman.M

[lbauer]

There seems to be a problem with the Source Safe automation component, ssapi.dll. This is supplied by the VSS Client and is used by the SOS Server to communicate with the VSS database.

How did you upgrade to VSS 6.0d? Did you install from disk, copy over the files, etc?

What version of the ssapi.dll is on the SOS Server machine? To find out, check this registry key for the path to the ssapi.dll file that the SOS Server is using:


HKEY_CLASSES_ROOT\CLSID\{783CD4E4-9D54-11CF-B8EE-00608CC9A71F}\InprocServer32

[purushoth]

i upgrade the vss using disk only. the version of ssapi.dll is 6.0.98.48.

[lbauer]

There's a problem with the automation component -- but it's not clear what.

Have you tried uninstalling the VSS client on the SOS Server machine and reinstalling? Be sure you delete any VSS client directories before reinstalling -- we've found that sometimes a new installation doesn't fully overwrite an old one.

[purushoth]

i tried uninstalling both the vss client and sourcesafe server and also delete the corresponding folders. i cleared all the entries for ssapi.dll in the registry and manually register it. but neverthless i am getting the same error , what else i can do on this issue with out rebuilding my system again , i cannot do that because this is my data server so i cannot think of rebuilding it. pls help me on this issue. i am getting into the hell with this issue.

[lbauer]

The error you are seeing in the log file "QueryInterface
for interface SourceSafeTypeLib.IVSSDatabase failed" is not an
SOS error directly, but comes from the SourceSafe Automation
component. It does not give use specific information about what is wrong, and there is no SOS setting to make this error more
useful.

At this point, the quickest solution would be to install the SOS
Server on a different machine in your LAN. You do NOT need to
move your VSS database; the SOS Server on the new machine can be
configured to use the existing database by entering its UNC path
in the SOS Server Manager. Also, make sure the SOS Server Service on the new machine runs as a Windows domain account so that it will have
the proper permission settings.

It's possible there's a problem with the registry. Often reinstalling the VSS Client will correct things, but you already tried that and it didn't
help. So at this point, moving the SOS Server to a different
machine is probably your quickest solution.

If you would like to spend more time troubleshooting this, we can. So far I've only seen parts of your SOS log file -- could you send me an entire log file -- that includes an SOS Server restart?

Have you tried re-installing VSS 6.0a, just on the SOS Server machine? This was working for you before.

[purushoth]

lbauer,

i tried reinstalling the vss6.0a alone, no luck. as per your post i am sending you the full log detail with this,

9/21/2006 11:23:10 AM - ****************************************************
9/21/2006 11:23:10 AM - SourceOffSite Server 4.1.2 Professional - With Cryptography

9/21/2006 11:23:10 AM - CurrentCulture is en-US.

9/21/2006 11:23:12 AM - Server Information
9/21/2006 11:23:12 AM - Operating System: Microsoft Windows 2000 Advanced Server
9/21/2006 11:23:12 AM - Service Pack: 4.0
9/21/2006 11:23:12 AM - OS Version: 5.0.2195
9/21/2006 11:23:12 AM - Locale: Ox0409
9/21/2006 11:23:12 AM - OSLanguage: 1033
9/21/2006 11:23:12 AM - Total Physical Memory: 1014.73 MB
9/21/2006 11:23:12 AM - Time Zone: (GMT+05:30) Calcutta, Chennai, Mumbai, New Delhi
9/21/2006 11:23:12 AM -
9/21/2006 11:23:12 AM - SSAPI.dll Information:
9/21/2006 11:23:12 AM - Location: file:///C:/Program Files/SourceOffSite Server/Interop.SourceSafeTypeLib.DLL
9/21/2006 11:23:12 AM - DisplayName: Interop.SourceSafeTypeLib, Version=5.1.0.0, Culture=neutral, PublicKeyToken=null
9/21/2006 11:23:12 AM -
9/21/2006 11:23:12 AM - Started at 9/21/2006 11:23:12 AM

9/21/2006 11:23:12 AM - General logging level is Verbose. Method logging is Enabled.

9/21/2006 11:23:12 AM - Number of licenses configured: 10
9/21/2006 11:23:12 AM - SourceSafe Initialization file(s) located at:
9/21/2006 11:23:12 AM - D:\Copy of database for testing\srcsafe.ini

9/21/2006 11:23:12 AM - laptop is attempting to listen for connections on secure port 8880

9/21/2006 11:23:12 AM - Waiting for a connection....secure = True
9/21/2006 11:23:14 AM - Stopping the service.
9/21/2006 11:23:15 AM - ****************************************************
9/21/2006 11:23:15 AM - SourceOffSite Server 4.1.2 Professional - With Cryptography

9/21/2006 11:23:15 AM - CurrentCulture is en-US.

9/21/2006 11:23:15 AM - Server Information
9/21/2006 11:23:15 AM - Operating System: Microsoft Windows 2000 Advanced Server
9/21/2006 11:23:15 AM - Service Pack: 4.0
9/21/2006 11:23:15 AM - OS Version: 5.0.2195
9/21/2006 11:23:15 AM - Locale: Ox0409
9/21/2006 11:23:15 AM - OSLanguage: 1033
9/21/2006 11:23:15 AM - Total Physical Memory: 1014.73 MB
9/21/2006 11:23:15 AM - Time Zone: (GMT+05:30) Calcutta, Chennai, Mumbai, New Delhi
9/21/2006 11:23:15 AM -
9/21/2006 11:23:15 AM - SSAPI.dll Information:
9/21/2006 11:23:15 AM - Location: file:///C:/Program Files/SourceOffSite Server/Interop.SourceSafeTypeLib.DLL
9/21/2006 11:23:15 AM - DisplayName: Interop.SourceSafeTypeLib, Version=5.1.0.0, Culture=neutral, PublicKeyToken=null
9/21/2006 11:23:15 AM -
9/21/2006 11:23:15 AM - Started at 9/21/2006 11:23:15 AM

9/21/2006 11:23:15 AM - General logging level is Verbose. Method logging is Enabled.

9/21/2006 11:23:15 AM - Number of licenses configured: 10
9/21/2006 11:23:15 AM - SourceSafe Initialization file(s) located at:
9/21/2006 11:23:15 AM - D:\Copy of databse for testing\srcsafe.ini

9/21/2006 11:23:15 AM - laptop is attempting to listen for connections on secure port 8880

9/21/2006 11:23:15 AM - Waiting for a connection....secure = True
9/21/2006 11:28:31 AM - Stopping the service.
9/21/2006 11:28:34 AM - ****************************************************
9/21/2006 11:28:34 AM - SourceOffSite Server 4.1.2 Professional - With Cryptography

9/21/2006 11:28:34 AM - CurrentCulture is en-US.

9/21/2006 11:28:34 AM - Server Information
9/21/2006 11:28:34 AM - Operating System: Microsoft Windows 2000 Advanced Server
9/21/2006 11:28:34 AM - Service Pack: 4.0
9/21/2006 11:28:34 AM - OS Version: 5.0.2195
9/21/2006 11:28:34 AM - Locale: Ox0409
9/21/2006 11:28:34 AM - OSLanguage: 1033
9/21/2006 11:28:34 AM - Total Physical Memory: 1014.73 MB
9/21/2006 11:28:34 AM - Time Zone: (GMT+05:30) Calcutta, Chennai, Mumbai, New Delhi
9/21/2006 11:28:34 AM -
9/21/2006 11:28:34 AM - SSAPI.dll Information:
9/21/2006 11:28:34 AM - Location: file:///C:/Program Files/SourceOffSite Server/Interop.SourceSafeTypeLib.DLL
9/21/2006 11:28:34 AM - DisplayName: Interop.SourceSafeTypeLib, Version=5.1.0.0, Culture=neutral, PublicKeyToken=null
9/21/2006 11:28:34 AM -
9/21/2006 11:28:34 AM - Started at 9/21/2006 11:28:34 AM

9/21/2006 11:28:34 AM - General logging level is Verbose. Method logging is Enabled.

9/21/2006 11:28:34 AM - Number of licenses configured: 10
9/21/2006 11:28:34 AM - SourceSafe Initialization file(s) located at:
9/21/2006 11:28:34 AM - D:\Copy of database for testing\srcsafe.ini

9/21/2006 11:28:34 AM - laptop is attempting to listen for connections on secure port 8880

9/21/2006 11:28:34 AM - Waiting for a connection....secure = True
9/21/2006 11:29:21 AM - Connection accepted from 192.x.x.x:1841 on local address 20.x.x.x:8880, session id is 1.
9/21/2006 11:29:21 AM - 1: Enter Authorized()
9/21/2006 11:29:22 AM - 1: Connection from: client (192.x.x.x)
9/21/2006 11:29:22 AM - 1: Preparing to send the list of databases...
9/21/2006 11:29:22 AM - 1: Sending the challenge to the client.
9/21/2006 11:29:22 AM - 1: Sending the challenge message body to the client.
9/21/2006 11:29:22 AM - 1: Waiting for the client's response...
9/21/2006 11:29:29 AM - 1: Reviewing the client's response...
9/21/2006 11:29:29 AM - 1: Process the client's crypto login request.
9/21/2006 11:29:29 AM - 1: Enter Login()
9/21/2006 11:29:29 AM - 1: User 'krish' requesting to login to database 'D:\Copy of database for testing\srcsafe.ini'
9/21/2006 11:29:29 AM - 1: Client is speaking protocol version 2.0

9/21/2006 11:29:29 AM - 1: Attempting to login WITH crypto.
9/21/2006 11:29:29 AM - 1: Verify the challenge string.
9/21/2006 11:29:29 AM - 1: Get the session key.
9/21/2006 11:29:29 AM - 1: Open the database.
9/21/2006 11:29:29 AM - 1: Exception during Login: QueryInterface for interface SourceSafeTypeLib.IVSSDatabase failed.
9/21/2006 11:29:29 AM - 1: Exit Login()
9/21/2006 11:29:29 AM - 1: Enter KillConnection()
9/21/2006 11:29:29 AM - 1: User krish disconnected from client
9/21/2006 11:29:29 AM - 1 - Exit KillConnection()
9/21/2006 11:31:44 AM - Connection accepted from 192.x.x.x:1863 on local address 20.x.x.x:8880, session id is 2.
9/21/2006 11:31:44 AM - 2: Enter Authorized()
9/21/2006 11:31:44 AM - 2: Connection from: client(192.x.x.x)
9/21/2006 11:31:44 AM - 2: Preparing to send the list of databases...
9/21/2006 11:31:44 AM - 2: Sending the challenge to the client.
9/21/2006 11:31:44 AM - 2: Sending the challenge message body to the client.
9/21/2006 11:31:44 AM - 2: Waiting for the client's response...
9/21/2006 11:31:51 AM - 2: Reviewing the client's response...
9/21/2006 11:31:51 AM - 2: Process the client's crypto login request.
9/21/2006 11:31:51 AM - 2: Enter Login()
9/21/2006 11:31:51 AM - 2: User 'krish' requesting to login to database 'D:\Copy of databse for testing\srcsafe.ini'
9/21/2006 11:31:51 AM - 2: Client is speaking protocol version 2.0

9/21/2006 11:31:51 AM - 2: Attempting to login WITH crypto.
9/21/2006 11:31:51 AM - 2: Verify the challenge string.
9/21/2006 11:31:51 AM - 2: Get the session key.
9/21/2006 11:31:51 AM - 2: Open the database.
9/21/2006 11:31:51 AM - 2: Exception during Login: QueryInterface for interface SourceSafeTypeLib.IVSSDatabase failed.
9/21/2006 11:31:51 AM - 2: Exit Login()
9/21/2006 11:31:51 AM - 2: Enter KillConnection()
9/21/2006 11:31:51 AM - 2: User krish disconnected from client.
9/21/2006 11:31:51 AM - 2 - Exit KillConnection()
9/21/2006 11:37:58 AM - Stopping the service.
9/21/2006 11:37:59 AM - ****************************************************
9/21/2006 11:37:59 AM - SourceOffSite Server 4.1.2 Professional - With Cryptography

9/21/2006 11:37:59 AM - CurrentCulture is en-US.

9/21/2006 11:37:59 AM - Server Information
9/21/2006 11:37:59 AM - Operating System: Microsoft Windows 2000 Advanced Server
9/21/2006 11:37:59 AM - Service Pack: 4.0
9/21/2006 11:37:59 AM - OS Version: 5.0.2195
9/21/2006 11:37:59 AM - Locale: Ox0409
9/21/2006 11:37:59 AM - OSLanguage: 1033
9/21/2006 11:37:59 AM - Total Physical Memory: 1014.73 MB
9/21/2006 11:37:59 AM - Time Zone: (GMT+05:30) Calcutta, Chennai, Mumbai, New Delhi
9/21/2006 11:37:59 AM -
9/21/2006 11:37:59 AM - SSAPI.dll Information:
9/21/2006 11:37:59 AM - Location: file:///C:/Program Files/SourceOffSite Server/Interop.SourceSafeTypeLib.DLL
9/21/2006 11:37:59 AM - DisplayName: Interop.SourceSafeTypeLib, Version=5.1.0.0, Culture=neutral, PublicKeyToken=null
9/21/2006 11:37:59 AM -
9/21/2006 11:37:59 AM - Started at 9/21/2006 11:37:59 AM

9/21/2006 11:37:59 AM - General logging level is Verbose. Method logging is Enabled.

9/21/2006 11:37:59 AM - Number of licenses configured: 10
9/21/2006 11:37:59 AM - SourceSafe Initialization file(s) located at:
9/21/2006 11:37:59 AM - D:\Copy of database for testing\srcsafe.ini

9/21/2006 11:37:59 AM - laptop is attempting to listen for connections on secure port 8880
9/21/2006 11:37:59 AM - Waiting for a connection....secure = True

9/21/2006 11:38:16 AM - Connection accepted from 192.x.x.x:1875 on local address 20.x.x.x:8880, session id is 1.
9/21/2006 11:38:16 AM - 1: Enter Authorized()
9/21/2006 11:38:16 AM - 1: Connection from: client(192.x.x.x)
9/21/2006 11:38:16 AM - 1: Preparing to send the list of databases...
9/21/2006 11:38:16 AM - 1: Sending the challenge to the client.
9/21/2006 11:38:16 AM - 1: Sending the challenge message body to the client.
9/21/2006 11:38:16 AM - 1: Waiting for the client's response...
9/21/2006 11:38:23 AM - 1: Reviewing the client's response...
9/21/2006 11:38:23 AM - 1: Process the client's crypto login request.
9/21/2006 11:38:23 AM - 1: Enter Login()
9/21/2006 11:38:23 AM - 1: User 'krish' requesting to login to database 'D:\Copy of database for testing\srcsafe.ini'
9/21/2006 11:38:23 AM - 1: Client is speaking protocol version 2.0

9/21/2006 11:38:23 AM - 1: Attempting to login WITH crypto.
9/21/2006 11:38:23 AM - 1: Verify the challenge string.
9/21/2006 11:38:23 AM - 1: Get the session key.
9/21/2006 11:38:23 AM - 1: Open the database.
9/21/2006 11:38:23 AM - 1: Exception during Login: QueryInterface for interface SourceSafeTypeLib.IVSSDatabase failed.
9/21/2006 11:38:23 AM - 1: Exit Login()
9/21/2006 11:38:23 AM - 1: Enter KillConnection()
9/21/2006 11:38:23 AM - 1: User chris disconnected from omeon010.omeon.com.
9/21/2006 11:38:23 AM - 1 - Exit KillConnection()
9/21/2006 11:39:01 AM - Connection accepted from 192.x.x.x:1888 on local address 20.x.x.x:8880, session id is 2.
9/21/2006 11:39:01 AM - 2: Enter Authorized()
9/21/2006 11:39:01 AM - 2: Connection from: client(192.168.0.70)
9/21/2006 11:39:01 AM - 2: Preparing to send the list of databases...
9/21/2006 11:39:01 AM - 2: Sending the challenge to the client.
9/21/2006 11:39:01 AM - 2: Sending the challenge message body to the client.
9/21/2006 11:39:01 AM - 2: Waiting for the client's response...
9/21/2006 11:39:07 AM - 2: Reviewing the client's response...
9/21/2006 11:39:07 AM - 2: Process the client's crypto login request.
9/21/2006 11:39:07 AM - 2: Enter Login()
9/21/2006 11:39:07 AM - 2: User 'krish' requesting to login to database 'D:\Copy of database for testing\srcsafe.ini'
9/21/2006 11:39:07 AM - 2: Client is speaking protocol version 2.0

9/21/2006 11:39:07 AM - 2: Attempting to login WITH crypto.
9/21/2006 11:39:07 AM - 2: Verify the challenge string.
9/21/2006 11:39:07 AM - 2: Get the session key.
9/21/2006 11:39:07 AM - 2: Open the database.
9/21/2006 11:39:07 AM - 2: Exception during Login: QueryInterface for interface SourceSafeTypeLib.IVSSDatabase failed.
9/21/2006 11:39:07 AM - 2: Exit Login()
9/21/2006 11:39:07 AM - 2: Enter KillConnection()
9/21/2006 11:39:07 AM - 2: User krish disconnected from client
9/21/2006 11:39:07 AM - 2 - Exit KillConnection()

regards,

purushoth

[lbauer]

There are no additional errors -- the database seems to be accessible by SOS.

Maybe there's a problem with the database. If you create a test VSS database on the same drive as the SOS Server machine, can you open it with SOS?

[purushoth]

Hi linda,

i had tried with a new database, but getting the same error with that also. i attached the log details. As the server was running on a public ip address i cannot able to rebuild the server. so pls provide me any help.

9/26/2006 11:27:09 AM - ****************************************************
9/26/2006 11:27:09 AM - SourceOffSite Server 4.1.2 Professional - With Cryptography

9/26/2006 11:27:09 AM - CurrentCulture is en-US.

9/26/2006 11:27:09 AM - Server Information
9/26/2006 11:27:09 AM - Operating System: Microsoft Windows 2000 Advanced Server
9/26/2006 11:27:09 AM - Service Pack: 4.0
9/26/2006 11:27:09 AM - OS Version: 5.0.2195
9/26/2006 11:27:09 AM - Locale: Ox0409
9/26/2006 11:27:09 AM - OSLanguage: 1033
9/26/2006 11:27:09 AM - Total Physical Memory: 1014.73 MB
9/26/2006 11:27:09 AM - Time Zone: (GMT+05:30) Calcutta, Chennai, Mumbai, New Delhi
9/26/2006 11:27:09 AM -
9/26/2006 11:27:09 AM - SSAPI.dll Information:
9/26/2006 11:27:09 AM - Location: file:///C:/Program Files/SourceOffSite Server/Interop.SourceSafeTypeLib.DLL
9/26/2006 11:27:09 AM - DisplayName: Interop.SourceSafeTypeLib, Version=5.1.0.0, Culture=neutral, PublicKeyToken=null
9/26/2006 11:27:09 AM -
9/26/2006 11:27:09 AM - Started at 9/26/2006 11:27:09 AM

9/26/2006 11:27:09 AM - General logging level is Verbose. Method logging is Enabled.

9/26/2006 11:27:10 AM - Number of licenses configured: 10
9/26/2006 11:27:10 AM - SourceSafe Initialization file(s) located at:
9/26/2006 11:27:10 AM - D:\new database\srcsafe.ini

9/26/2006 11:27:10 AM - laptop is attempting to listen for connections on secure port 8880

9/26/2006 11:27:10 AM - Waiting for a connection....secure = True
9/26/2006 11:49:34 AM - Connection accepted from 192.x.x.x:1752 on local address 20.x.x.x:8880, session id is 1.
9/26/2006 11:49:34 AM - 1: Enter Authorized()
9/26/2006 11:49:35 AM - 1: Connection from: client (192.x.x.x)
9/26/2006 11:49:35 AM - 1: Preparing to send the list of databases...
9/26/2006 11:49:35 AM - 1: Sending the challenge to the client.
9/26/2006 11:49:35 AM - 1: Sending the challenge message body to the client.
9/26/2006 11:49:35 AM - 1: Waiting for the client's response...
9/26/2006 11:49:45 AM - 1: Reviewing the client's response...
9/26/2006 11:49:45 AM - 1: Process the client's crypto login request.
9/26/2006 11:49:45 AM - 1: Enter Login()
9/26/2006 11:49:45 AM - 1: User 'krish' requesting to login to database 'D:\new database\srcsafe.ini'
9/26/2006 11:49:45 AM - 1: Client is speaking protocol version 2.0

9/26/2006 11:49:45 AM - 1: Attempting to login WITH crypto.
9/26/2006 11:49:45 AM - 1: Verify the challenge string.
9/26/2006 11:49:45 AM - 1: Get the session key.
9/26/2006 11:49:45 AM - 1: Open the database.
9/26/2006 11:49:45 AM - 1: Exception during Login: QueryInterface for interface SourceSafeTypeLib.IVSSDatabase failed.
9/26/2006 11:49:45 AM - 1: Exit Login()
9/26/2006 11:49:45 AM - 1: Enter KillConnection()
9/26/2006 11:49:45 AM - 1: User krish disconnected from client
9/26/2006 11:49:45 AM - 1 - Exit KillConnection()

[lbauer]

Is it possible to install the SourceOffSite server on a different machine? The SOS Server does not need to be on the same machine as the VSS datababase, just on the same LAN. Unless you have a very large development team, it can even be run on a workstation, like XP Pro.

[purushoth]

No, i cannot move the sourceoffsite server as it is running on a public ip. i tried connecting the database in another server. but still i am getting the same error. is anything related with registry or some thing like that.

[lbauer]

Here are some steps that may repair the registry, if the registry is the problem.

First, browse to the location of the VSS Client on the SOS Server machine. In the VSS\Win32 directory, double-click on SSINT.EXE to open it, then click OK.

Next, from the command line, cd to the VSS Client win32 directory, where the ssapi.dll (automation component) should be. Run these commands to unregister then re-register the .dll:

regsvr32 /u ssapi.dll

regsvr32 ssapi.dll

Hope this helps.