Microsoft Sql Server 2005 Instance Wincc Oa

Microsoft Sql Server 2005 Instance Wincc Flexible. 5/31/2017 0 Comments. Starting the Microsoft SQL Server 2005 Express Instance The WinCC flexible instance of Microsoft SQL Server no longer starts after the PC was. Don't bother trying to fix SQL instance. WinCC flexible 2008 Microsoft SQL server 2005 Microsoft SQL server desktop engine. Download Security Update for SQL Server 2005 Service Pack 4 (KB2716427) from Official Microsoft Download Center. New Surface Pro 6. Stand out from the ordinary. This update is applicable to SQL Server 2005 SP4 RTM instances. Install Instructions Download the appropriate file for your computer's processor by clicking one of the links below. The laptop has Siemens WinCC installed and running updates for this keep failing because SQL server 2005 SP4 won't update at the start of the update program. Similarily the windows update SQL 2005 express SP3 (KB955706) keeps failing too and has been for a while so presumably SP3 is not fully/correctly installed.

5/29/2013 9:06 AM

Joined: 3/22/2013

Last visit: 9/12/2014

Posts: 40

Rating:

(0)

Dear all,
I am using winc flexible 2008. Untill yesterday it was running fine but now it is showingcannot connect to configured SQL server.....plz help.......
5/29/2013 10:28 AM

Joined: 9/5/2011

Last visit: 5/7/2014

Posts: 3037

Rating:

(181)

Hello,
Have a look in the following link.
What are the possible causes of an unsuccessful Microsoft SQL Server 2005 Express installation or why is creating or opening a WinCC flexible 2008 project aborted?
Tweety
9/12/2013 10:31 AM

Joined: 8/9/2007

Last visit: 3/8/2019

Posts: 53

Rating:

(2)

Hello,

i have the same problem. I tried the solution described above, but without result ... Still the same problem ... Pls help.
Henio.
9/16/2013 10:26 AM

Joined: 8/9/2007

Last visit: 3/8/2019

Posts: 53

Rating:

(2)

Hi,

I tried to return to clean Windows system (Win7, 64bit), then install WinCC Flexi 2008 on this clean system, but still the same result ... I can install, but during opening project still the same error info 'Cannot connect to the configured SQL server.'. I suggest something wrong is in Windows, but i dont know what ...
If anyone will have any idea i'll be gratefull ...
Henio.
PS.: I tried every metod which i found on FORUM/FAQ.
9/17/2013 11:06 AM

Joined: 9/5/2011

Last visit: 5/7/2014

Posts: 3037

Rating:

(181)

Hello,
You must do the point 1.4 in the following link.
http://support.automation.siemens.com/WW/view/en/29420407
Tweety
9/17/2013 12:59 PM

Joined: 8/9/2007

Last visit: 3/8/2019

Posts: 53

Rating:

(2)

Hello,

as i said, i did, but without positive result ... still the same problem.
Henio.
9/17/2013 2:14 PM

Joined: 8/9/2007

Last visit: 3/8/2019

Posts: 53

Rating:

(2)

Hello,

Error: 15372, Severity: 16, State: 1.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Henio.
9/17/2013 4:27 PM

Joined: 9/5/2011

Last visit: 5/7/2014

Posts: 3037

Rating:

(181)

Hello,
I found this link from microsoft.
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9e01e870-0bff-4669-a385-2d9349b1a4f0/error-15372-on-adding-new-sql-database-in-vwd
Do you delete all folders under this path?
%USERPROFILE%AppDataLocalMicrosoftMicrosoft SQL Server DataWINCCFLEXEXPRESS
See the point 2.1
http://support.automation.siemens.com/WW/view/en/29420407
Tweety
9/18/2013 7:50 AM

Joined: 8/9/2007

Last visit: 3/8/2019

Posts: 53

Rating:

(2)

Hello,

yes i do. Even i've tried to delete the folder 'MSSQL.1' in Program files, still the same ...
And yes, i've read the Microsoft forums too, and it looks like known problem, but it still doesnt help solve my problem ...
Henio.
9/18/2013 10:21 AM

Joined: 9/5/2011

Last visit: 5/7/2014

Posts: 3037

Rating:

(181)


Then you can contact the customer support for your problem.
Tweety

15 Jun 2009CPOL
This article will demonstrate how we can integrate T-SQL with an external application.

Introduction

This article will demonstrate how we can integrate T-SQL with an external application.

Background

When we need to store or retrieve data in SQL server database, we will go for T-SQL. But the thing is how can we integrate T-SQL with an external application? For example, we want to integrate SQL server with Microsoft Word, Excel or Microsoft exchange server as well. So how can we achieve this?

Using the Code

Instance Configuration In Sql Server

There are seven extended stored procedures to call external applications like DLLs. The name and description of those stored procedures are given below:

Stored Procedure Description
sp_OACreateCreates an instance of the OLE object on an instance of Microsoft SQL Server
sp_OADestroy Destroys a created OLE object
sp_OAGetErrorInfo Obtains OLE Automation error information
sp_OAGetProperty Gets a property value of an OLE object
sp_OASetProperty Sets a property of an OLE object to a new value
sp_OAMethod Calls a method of an OLE object
sp_OAStop Stops the server-wide OLE Automation stored procedure execution environment

Let’s take a simple example to implement this. Our requirement will be accessing a third party DLL from a SQL server stored procedure.

The following are the two functions which are developed in C# .NET.
Function (a) getOSPlatform will return the System platform and the function (b) writeToFile will write text into a text file called CLRTempE.txt with the value given by the parameter.

Sample COM+ Code (C#. NET)

Sql server instance vs database

Sample SQL Stored Procedure

Now we are going to discuss how the above code works. sp_OACreate will create an instance of the DLL to SQL Server. If it is a successfully created output, that will be 0. If it is non-zero, then send it to sp_OAGetErrorInfo and get the error messages. sp_OAMethod is to call the method of the DLL. In the first case, we are calling the method getOSPlatform which only has a returned value. The last parameter of sp_OACreate must be either of 1, 4 or 5. It specifies the execution context in which the newly created OLE object runs. If specified, this value must be one of the following:

  • 1 = In-process (.dll) OLE server only
  • 4 = Local (.exe) OLE server only
  • 5 = Both in-process and local OLE server allowed

If not specified, the default value is 5.

If an in-process OLE server is allowed (by using a context value of 1 or 5 or by not specifying a context value), it has access to memory and other resources owned by SQL Server. An in-process OLE server may damage SQL Server memory or resources and cause unpredictable results, such as a SQL Server access violation.

Instance configuration in sql server

When we specify a context value of 4, a local OLE server does not have access to any SQL Server resources, and it cannot damage SQL Server memory or resources. Finally sp_OADestroy will destroy a created OLE object in the SQL Server.

Reference SQL Server Books Online.

Points of Interest

When registering the COM+, we must use the following command by using Visual Studio command prompt.

Commands:
C:Program FilesMicrosoft Visual Studio 9.0VC> RegAsm CLRExample.dll tlb: CLRExample.tlb codebase
Note: Do not use regsvr32 for registering the COM+.

Conclusion

I hope that this article will be helpful to you. Enjoy!

Microsoft Sql Server 2005 Instance Wincc Oatmeal

History

  • 15th June, 2009: Initial post

Microsoft Sql Server 2005 Instance Wincc Oa