Cannot open MSSQL$SQLTOPSOLID

Issues and questions related to TopSolid installation.

Moderators: remi77, jacs, Daniel

John73
Private
Private
Posts: 9
Joined: Wed Jun 06, 2018 9:05 pm

Cannot open MSSQL$SQLTOPSOLID

Unread post by John73 »

Just started trying to use 7.12, got the perm codes sorted out, and now it's asking me for a password to connect to my local PDM server.
connection.png
I don't remember ever setting a password, or setting up a server, or anything.

Clicking the green check mark gives me the error "Cannot open MSSQL$SQLTOPSOLID service on computer '.'."

I'm totally lost here. I've never had to do whatever this is in previous versions.

I don't use a PDM server, I just have one computer which has all my stuff on it. I've tried all sorts of things fiddling around with the "Server Connections" links, but it doesn't help. By creating a new connection and naming it something else I can get the error to say "No connection could be made because the target machine actively refused it" followed by my IP address, but that's it.

The "Don't show at startup" checkbox is taunting me. I just want this window to go away so I can get back to work.
Last edited by John73 on Fri Aug 10, 2018 11:29 pm, edited 2 times in total.
User avatar
Bill
Master Chief
Master Chief
Posts: 115
Joined: Wed Feb 21, 2007 8:17 pm
TopSolid Module: TopSolid'Design
TopSolid Version: 6.25
Location: Chicago
Contact:

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by Bill »

Hi there,

Just hit the green check mark. It needs to logon to the new local pdm server. There is no password.
Happy Designing
Bill
Technical Director
Missler Software Inc
John73
Private
Private
Posts: 9
Joined: Wed Jun 06, 2018 9:05 pm

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by John73 »

That just gives me the error: "Cannot open MSSQL$SQLTOPSOLID service on computer '.'." and I end up back where I started.
User avatar
olaio
Second Officer Cadet
Second Officer Cadet
Posts: 194
Joined: Thu Mar 01, 2007 11:42 am
Answers: 2
Location: Leiria

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by olaio »

Hi John73

Try to run the file "TopSolid.Pdm.ServerServiceAdmin.exe" located in:
C:\Program Files\Missler Software\TopSolid 7.12\bin
you should get an icon on the notifications bar:
1.png
1.png (1.14 KiB) Viewed 23920 times
Right click on it and select the option "Manage".
You should get this:
2.png
You will need to configure your database and the vault location.

I hope this will help you...
John73
Private
Private
Posts: 9
Joined: Wed Jun 06, 2018 9:05 pm

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by John73 »

That window gives me this message:

Server stopped.

Failed to connect to server .\SQLTOPSOLID. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)

To connect to a SQL Server instance: Check that the name of the SQL Server instance is valid, you can use "Search..." to get the name of the available SQL Server instances. Check that the current Windows account is declared as a login in SQL Server instance and give the sysadmin user role to this login.


I checked the file path for the vault and it's correct. Also I'm logged in as the system administrator (not sure if that matters).
John73
Private
Private
Posts: 9
Joined: Wed Jun 06, 2018 9:05 pm

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by John73 »

I've made several attempts to get it working, including 3 complete uninstall/reinstalls, and it's still broken. Part of the problem is that uninstall doesn't seem to remove the whole MSSQL thing, and I've tried removing that manually and reinstalling a couple of times. At one point I got it to work, sort of (it seemed as if the database vault was working, at least) but then I got stuck in a chicken-and-egg problem:

Can't connect to server without putting in my license
Can't put in my license without launching the program
Can't launch the program because the first thing it asks me to do it connect to server and won't proceed without it

So I had to uninstall that and try again, and now it's back to the same server/database errors as before.

I'm really getting quite annoyed at this. Is there somewhere I can chat directly with a tech support person?
User avatar
remi77
Administator
Administator
Posts: 348
Joined: Thu Feb 22, 2007 10:05 am
Contact:

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by remi77 »

Hi

In case, you've tried everything :arrow:

You may try this :arrow:

1. Uninstall all SQL Server components you can using Control Panel -> Programs and Features

2. Backup the registry.

3. Delete the following keys in regedit:

--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

4. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and delete all the sub-keys referencing SQL Server.

5. Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.

6. Rename all the SQL Server folders in the computer like C:\Program Files\Microsoft SQL Server and subfolders.

In any case, preserve your data

See you

Rémi :wink:
Thanks to use the Image on the best answer when you've got the solution.
John73
Private
Private
Posts: 9
Joined: Wed Jun 06, 2018 9:05 pm

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by John73 »

Thank you for the reply.

I followed the instructions and the PDM server appears to be working (according to TopSolid.Pdm.ServerServiceAdmin.exe)

However when I launch the program I still have this error:
con1.png
I feel like I'm a step closer, maybe? Although I still don't understand why this is necessary when I never had to deal with it in previous versions. (My interest is mechanical engineering, not computer science)
John73
Private
Private
Posts: 9
Joined: Wed Jun 06, 2018 9:05 pm

Re: Cannot open MSSQL$SQLTOPSOLID

Unread post by John73 »

Okay, I ran another update and it seems to be working alright except for an issue with the license. Thank you again for your help.
Post Reply