SQL Server (WINCC) does not exist

7.5k views Asked by At

I'm really in trouble having Wincc RT Professional running on my computer. It has consistently come with an error "Compilation not possible. the "WinCC" SQL instance is either not running or not available" anytime I compile it. I searched that it dues to SQL server (WINCC) is not running so I was gonna enable it in Sql server configuration manager but it didn't have such thing like that in the list of SQL Server services. How can I install it manually or make Wincc Pro run successfully? I'm using TIA Portal V14 that worked well with Wincc RT Advanced and the SIMATIC WinCC Runtime Professional has also installed formerly. Hope this description enough and clear for you. Thanks in advance.

2

There are 2 answers

3
Cliff Pennalligen On

This error has been reported a number of times on the Siemens forums. Unfortunately, it seems every time the forum users stop short of saying what they did to fix it (or they didn't fix it)...

As you may have guessed, the backbone of WinCC RT Professional is a Microsoft SQL Server database, although what flavor and version of SQL they embed in their product, I'm not sure.

Your installation has gone bad in some way. Sorry that's not a helpful description, but it's hard to tell why without further information, so here are some fault finding steps I would take.

If you haven't done so already, have a quick scan of forum to see if you can find a quick fix.

If you were never, ever able to compile with this installation, can I suggest the following as general fault-finding: A. if a working installation on another machine is available, compare the installs as much as possible to find out what's different. You might find the compatibility tool useful for this: compatibility tool B. If (A) is not possible, perform a fresh installation on a different machine without any other siemens software, and try to compile. C. if (B) works, you might have a software conflict. It happens. I thought that the installers for the different flavors of WinCC check for this before installing, but I'm not sure.

3
h4801681gmailcom On

Check if your SQL service is started, as shown in the picture below

enter image description here