Hello guys,

I installed to mz PC MS SQL server 2022 and I wanted to try create DB from WinCC. I used TIA Portal V17, Advanced and WinCC RT Advanced. I donloaded from Siemens support script for creating DB: 

Sub Insert(ByRef Name_DSN)

Dim connect, record, SQL_Table, DB_Name, ErrorDesc1, ErrorDesc2

DB_Name = SmartTags("DatabaseName")

On Error Resume Next

Set connect = CreateObject("ADODB.Connection")

Set connect = CreateObject("ADODB.Recordset")

'Open data sourceC

connect.Open "Provider=MSDASQL;DSN="&Name_DSN&"" 'DSN= name of the odbc-database - DSN= Name der ODBC-Datenbank

'Error routine

If Err.Number <> 0 Then

ErrorDesc1 = Err.Description & " (" & Err.Number & ")"

SmartTags("ErrDesc1") = ErrorDesc1

Set connect = Nothing

Exit Sub

End If

' SQL_Table = "CREATE DATABASE" & DB_Name

' Set record = connect.Execute(SQL_Table)

'Error routine

If Err.Number <> 0 Then

ErrorDesc2 = Err.Description & "(" & Err.Number & ")"

SmartTags("ErrDesc2") = ErrorDesc2

Set connect = Nothing

Exit Sub

End If

'Close data source

connect.close

Set record = Nothing

Set connect = Nothing

End Sub

After starting the procedure when is executing command "connect.Open "Provider=MSDASQL;DSN="&Name_DSN&"""

i get the error: "The connection cannot be used to perform this operation. It is either closed or invalid in this context. (3709)"

When i tested SQL server, I tried to create DB manually, and everything is correct. I set the rule in firewall port 1433. I dont understand where is the problem

Thanks you