MSSQL auf anonymer samba share

Hallo,

ich versuche eine mssql Datenbank (läuft auf nem Windows Failover Cluster) auf eine samba share umzuziehen, was jedoch nicht funktioniert.

Die Daten vom SQL Server liegen alle auf einem Windows Storage Spaces Direct Cluster und sind über den Fileserver per smb erreichbar (\\sqlfs.domain.de\sqlsc3\....)

Nun müssen die Daten leider für kurze Zeit auf einen anderen Storage, dieser bietet jedoch nur iSCSI. Es ist mir etwas zu viel arbeit nun bei jeder Instanz und Tabelle die ganzen UNC Pfade in iSCSI Pfade Laufwerke zu ändern. Da es schon sehr viele Tabellen sind und das bei jeder geändert werden müsste.

Mein Plan ist es eine anonyme samba share zu machen und dann einfach per host-file auf den SQL-Knoten die Adresse sqlfs.domain.de auf die IP der neue Freigabe umzuleiten. Diese hat dann per iscsi ein großes Laufwerk gemountet auf dem die Daten liegen.
Also ne Umsetzung von iSCSI auf SMB.

ALT: SQL-Cluster ------->SMB-Share----alter Storage (storage spaces direct)
NEU: SQL-Cluster ------> SMB Share--->iSCSI----->neuer Storage

Ich weiß, das ist sicherheitstechnisch und bestimmt auch performancemäßig total schrott, aber es ist nur für eine sehr kurze Zeit.

Ich habe mir nun ein Ubuntu installiert und dort Samba drinnen. Hier eine anonyme Freigabe erstellt. Diese kann ich auch per WindowsExplorer erreichen und Dateien in dieser bearbeiten, jedoch meldet der SQL Server beim Starten dann "Unable to open physical file \\sqlfs.domain.de\sqlsc3\mssql12.sc3\mssql\data\master.ldf Operating system error 5: "5(Access is denied.)"

Im SMB Log steht folgendes:
[2017/11/08 15:25:49.808934, 0] ../source3/smbd/posix_acls.c:2080(create_canon_ace_lists)
create_canon_ace_lists: unable to map SID S-1-3-4 to uid or gid.

Wenn ich den Parameter "nt acl support = no" hinzufüge dann bekomme ich die Meldung:
[2017/11/08 15:26:47.974610, 0] ../lib/param/loadparm.c:1668(lpcfg_do_service_parameter)
Global parameter guest account found in service section!

Meine smb.conf
[global]
server string = "sqlfssmb"
netbios name = sqlfssmb
workgroup = sqlfs
security = user
map to guest = Bad User
usershare allow guests = yes
local master = yes
preferred master = yes
nt acl support = no
#log level = 3
#force unknown acl user = yes

[sqlsc3]
path = /media/test
force user = nobody
force group = nogroup
public = yes
writable = yes
browsable = yes
guest ok = yes
guest only = yes
guest account = nobody
create mask = 0777
directory mask = 2777

Hat einer ne Idee woran das liegen könnte?

Grüße

Please also mark the comments that contributed to the solution of the article

Content-Key: 354098

Url: https://administrator.de/contentid/354098

Printed on: April 16, 2024 at 15:04 o'clock

2 Comments

Latest comment

Also ich bin erstmal erstaunt das MSSQL mittlerweile tatsächlich von smb läuft, ob das gut ist weiß ich nicht

Es scheint aber einige Limitierungen zu geben:
https://logicalread.com/installing-sql-server-databases-on-smb-file-shar ...

Hi,

doch also MSSQL auf smb läuft seit smbv3 echt super darauf.

Ich habe mal ein "log level = 3" in der smb.con eingefügt und versucht eine neue Tabelle auf der Share zu erstellen.
Immer noch der selbe Fehler, aber hier mal das Log, evtl. kann da jemand mehr raus lesen als ich:

[2017/11/09 12:22:46.823892,  3] ../source3/param/loadparm.c:3754(lp_load_ex)
  lp_load_ex: refreshing parameters
[2017/11/09 12:22:46.823919,  3] ../source3/param/loadparm.c:548(init_globals)
  Initialising global parameters
[2017/11/09 12:22:46.823925,  2] ../source3/param/loadparm.c:320(max_open_files)
  rlimit_max: increasing rlimit_max (1024) to minimum Windows limit (16384)
[2017/11/09 12:22:46.823951,  3] ../source3/param/loadparm.c:2683(lp_do_section)
  Processing section "[global]"  
[2017/11/09 12:22:46.823977,  2] ../source3/param/loadparm.c:2700(lp_do_section)
  Processing section "[sqlsc3]"  
[2017/11/09 12:22:46.824005,  0] ../lib/param/loadparm.c:1668(lpcfg_do_service_parameter)
  Global parameter guest account found in service section!
[2017/11/09 12:22:46.824303,  3] ../source3/param/loadparm.c:1600(lp_add_ipc)
  adding IPC service
[2017/11/09 12:22:46.824402,  2] ../source3/lib/interface.c:341(add_interface)
  added interface eth0 ip=10.0.196.219 bcast=10.0.196.255 netmask=255.255.255.0
[2017/11/09 12:22:46.824420,  3] ../source3/smbd/server.c:1331(main)
  loaded services
[2017/11/09 12:22:46.824442,  1] ../source3/profile/profile_dummy.c:30(set_profile_level)
  INFO: Profiling support unavailable in this build.
[2017/11/09 12:22:46.824449,  3] ../source3/smbd/server.c:1362(main)
  Becoming a daemon.
[2017/11/09 12:22:46.828194,  3] ../source3/auth/token_util.c:547(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:46.828246,  3] ../source3/auth/token_util.c:579(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:46.828537,  3] ../source3/rpc_server/svcctl/srv_svcctl_reg.c:565(svcctl_init_winreg)
  Initialise the svcctl registry keys if needed.
[2017/11/09 12:22:46.829453,  3] ../source3/rpc_server/eventlog/srv_eventlog_reg.c:59(eventlog_init_winreg)
  Initialise the eventlog registry keys if needed.
[2017/11/09 12:22:46.829605,  0] ../lib/util/become_daemon.c:124(daemon_ready)
  STATUS=daemon 'smbd' finished starting up and ready to serve connections  
[2017/11/09 12:22:46.829701,  3] ../source3/printing/queue_process.c:335(start_background_queue)
  start_background_queue: Starting background LPQ thread
[2017/11/09 12:22:46.830158,  1] ../source3/printing/printer_list.c:234(printer_list_get_last_refresh)
  Failed to fetch record!
[2017/11/09 12:22:46.830170,  2] ../source3/smbd/server.c:1009(smbd_parent_loop)
  waiting for connections
[2017/11/09 12:22:46.830303,  3] ../source3/printing/pcap.c:140(pcap_cache_reload)
  reloading printcap cache
[2017/11/09 12:22:46.830704,  3] ../source3/printing/pcap.c:189(pcap_cache_reload)
  reload status: ok
[2017/11/09 12:22:46.831256,  3] ../source3/printing/print_cups.c:152(cups_connect)
  Unable to connect to CUPS server localhost:631 - Ungültiger Dateideskriptor
[2017/11/09 12:22:46.831584,  3] ../source3/printing/print_cups.c:530(cups_async_callback)
  failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
[2017/11/09 12:22:47.211610,  3] ../source3/lib/access.c:338(allow_access)
  Allowed connection from 10.0.189.95 (10.0.189.95)
[2017/11/09 12:22:47.211654,  3] ../source3/smbd/oplock.c:1310(init_oplocks)
  init_oplocks: initializing messages.
[2017/11/09 12:22:47.211680,  3] ../source3/smbd/process.c:1880(process_smb)
  Transaction 0 of length 112 (0 toread)
[2017/11/09 12:22:47.211751,  3] ../source3/smbd/smb2_negprot.c:271(smbd_smb2_request_process_negprot)
  Selected protocol SMB3_02
[2017/11/09 12:22:47.212970,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'gssapi_spnego' registered  
[2017/11/09 12:22:47.212981,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'gssapi_krb5' registered  
[2017/11/09 12:22:47.212985,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'gssapi_krb5_sasl' registered  
[2017/11/09 12:22:47.212988,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'spnego' registered  
[2017/11/09 12:22:47.212992,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'schannel' registered  
[2017/11/09 12:22:47.213000,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'naclrpc_as_system' registered  
[2017/11/09 12:22:47.213004,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'sasl-EXTERNAL' registered  
[2017/11/09 12:22:47.213007,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'ntlmssp' registered  
[2017/11/09 12:22:47.213011,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'ntlmssp_resume_ccache' registered  
[2017/11/09 12:22:47.213014,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'http_basic' registered  
[2017/11/09 12:22:47.213017,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'http_ntlm' registered  
[2017/11/09 12:22:47.213021,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'krb5' registered  
[2017/11/09 12:22:47.213024,  3] ../auth/gensec/gensec_start.c:907(gensec_register)
  GENSEC backend 'fake_gssapi_krb5' registered  
[2017/11/09 12:22:47.214408,  3] ../auth/ntlmssp/ntlmssp_util.c:69(debug_ntlmssp_flags)
  Got NTLMSSP neg_flags=0xe2088297
[2017/11/09 12:22:47.215491,  3] ../auth/ntlmssp/ntlmssp_server.c:452(ntlmssp_server_preauth)
  Got user=[sql_serviceuser] domain=[DOMAIN] workstation=[SQLNODE03] len1=24 len2=336
[2017/11/09 12:22:47.215528,  3] ../source3/param/loadparm.c:3754(lp_load_ex)
  lp_load_ex: refreshing parameters
[2017/11/09 12:22:47.215562,  3] ../source3/param/loadparm.c:548(init_globals)
  Initialising global parameters
[2017/11/09 12:22:47.215601,  3] ../source3/param/loadparm.c:2683(lp_do_section)
  Processing section "[global]"  
[2017/11/09 12:22:47.215630,  2] ../source3/param/loadparm.c:2700(lp_do_section)
  Processing section "[sqlsc3]"  
[2017/11/09 12:22:47.215652,  0] ../lib/param/loadparm.c:1668(lpcfg_do_service_parameter)
  Global parameter guest account found in service section!
[2017/11/09 12:22:47.215704,  3] ../source3/param/loadparm.c:1600(lp_add_ipc)
  adding IPC service
[2017/11/09 12:22:47.215718,  3] ../source3/auth/auth.c:178(auth_check_ntlm_password)
  check_ntlm_password:  Checking password for unmapped user [DOMAIN]\[sql_serviceuser]@[SQLNODE03] with the new password interface
[2017/11/09 12:22:47.215723,  3] ../source3/auth/auth.c:181(auth_check_ntlm_password)
  check_ntlm_password:  mapped user is: [SQLFSSMB]\[sql_serviceuser]@[SQLNODE03]
[2017/11/09 12:22:47.215750,  3] ../source3/auth/check_samsec.c:400(check_sam_security)
  check_sam_security: Couldn't find user 'sql_serviceuser' in passdb.  
[2017/11/09 12:22:47.215755,  2] ../source3/auth/auth.c:315(auth_check_ntlm_password)
  check_ntlm_password:  Authentication for user [sql_serviceuser] -> [sql_serviceuser] FAILED with error NT_STATUS_NO_SUCH_USER
[2017/11/09 12:22:47.215766,  3] ../source3/auth/auth_util.c:1602(do_map_to_guest_server_info)
  No such user sql_serviceuser [DOMAIN] - using guest account
[2017/11/09 12:22:47.216815,  3] ../source3/lib/access.c:338(allow_access)
  Allowed connection from 10.0.189.95 (10.0.189.95)
[2017/11/09 12:22:47.216973,  1] ../source3/param/loadparm.c:2389(lp_idmap_range)
  idmap range not specified for domain '*'  
[2017/11/09 12:22:47.217007,  3] ../source3/auth/token_util.c:547(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:47.217017,  3] ../source3/auth/token_util.c:579(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:47.217083,  3] ../source3/smbd/service.c:394(set_conn_force_user_group)
  Forced user nobody
[2017/11/09 12:22:47.217113,  3] ../source3/smbd/service.c:286(find_forced_group)
  Forced group nogroup
[2017/11/09 12:22:47.217120,  3] ../source3/smbd/service.c:524(make_connection_snum)
  Connect path is '/media/test' for service [sqlsc3]  
[2017/11/09 12:22:47.217142,  3] ../source3/smbd/vfs.c:113(vfs_init_default)
  Initialising default vfs hooks
[2017/11/09 12:22:47.217165,  3] ../source3/smbd/vfs.c:139(vfs_init_custom)
  Initialising custom vfs hooks from [/[Default VFS]/]
[2017/11/09 12:22:47.217228,  2] ../source3/smbd/service.c:774(make_connection_snum)
  sqlnode03 (ipv4:10.0.189.95:52142) connect to service sqlsc3 initially as user nobody (uid=65534, gid=65534) (pid 2244)
[2017/11/09 12:22:47.219102,  3] ../source3/smbd/dir.c:628(dptr_create)
  creating new dirptr 0 for path ., expect_close = 0
[2017/11/09 12:22:47.219128,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found . fname=. (.)
[2017/11/09 12:22:47.219139,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found .. fname=.. (..)
[2017/11/09 12:22:47.219151,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found MSSQL12.SYSTEMCENTER03 fname=MSSQL12.SYSTEMCENTER03 (MSSQL12.SYSTEMCENTER03)
[2017/11/09 12:22:47.219162,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test3.txt fname=test3.txt (test3.txt)
[2017/11/09 12:22:47.219170,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test2.txt fname=test2.txt (test2.txt)
[2017/11/09 12:22:47.219177,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test.txt fname=test.txt (test.txt)
[2017/11/09 12:22:47.663484,  3] ../source3/smbd/smb2_notify.c:250(smbd_smb2_notify_send)
  smbd_smb2_notify_send: notify change called on ., filter = FILE_NAME|DIR_NAME, recursive = 1
[2017/11/09 12:22:59.785496,  3] ../auth/ntlmssp/ntlmssp_util.c:69(debug_ntlmssp_flags)
  Got NTLMSSP neg_flags=0xe2088297
[2017/11/09 12:22:59.786520,  3] ../auth/ntlmssp/ntlmssp_server.c:452(ntlmssp_server_preauth)
  Got user=[service_sqlsc3] domain=[DOMAIN] workstation=[SQLNODE03] len1=24 len2=336
[2017/11/09 12:22:59.786560,  3] ../source3/param/loadparm.c:3754(lp_load_ex)
  lp_load_ex: refreshing parameters
[2017/11/09 12:22:59.786596,  3] ../source3/param/loadparm.c:548(init_globals)
  Initialising global parameters
[2017/11/09 12:22:59.786645,  3] ../source3/param/loadparm.c:2683(lp_do_section)
  Processing section "[global]"  
[2017/11/09 12:22:59.786690,  2] ../source3/param/loadparm.c:2700(lp_do_section)
  Processing section "[sqlsc3]"  
[2017/11/09 12:22:59.786714,  0] ../lib/param/loadparm.c:1668(lpcfg_do_service_parameter)
  Global parameter guest account found in service section!
[2017/11/09 12:22:59.786769,  3] ../source3/param/loadparm.c:1600(lp_add_ipc)
  adding IPC service
[2017/11/09 12:22:59.786779,  3] ../source3/auth/auth.c:178(auth_check_ntlm_password)
  check_ntlm_password:  Checking password for unmapped user [DOMAIN]\[service_sqlsc3]@[SQLNODE03] with the new password interface
[2017/11/09 12:22:59.786783,  3] ../source3/auth/auth.c:181(auth_check_ntlm_password)
  check_ntlm_password:  mapped user is: [SQLFSSMB]\[service_sqlsc3]@[SQLNODE03]
[2017/11/09 12:22:59.786808,  3] ../source3/auth/check_samsec.c:400(check_sam_security)
  check_sam_security: Couldn't find user 'service_sqlsc3' in passdb.  
[2017/11/09 12:22:59.786813,  2] ../source3/auth/auth.c:315(auth_check_ntlm_password)
  check_ntlm_password:  Authentication for user [service_sqlsc3] -> [service_sqlsc3] FAILED with error NT_STATUS_NO_SUCH_USER
[2017/11/09 12:22:59.786818,  3] ../source3/auth/auth_util.c:1602(do_map_to_guest_server_info)
  No such user service_sqlsc3 [DOMAIN] - using guest account
[2017/11/09 12:22:59.787608,  3] ../source3/lib/access.c:338(allow_access)
  Allowed connection from 10.0.189.95 (10.0.189.95)
[2017/11/09 12:22:59.787725,  1] ../source3/param/loadparm.c:2389(lp_idmap_range)
  idmap range not specified for domain '*'  
[2017/11/09 12:22:59.787758,  3] ../source3/auth/token_util.c:547(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:59.787768,  3] ../source3/auth/token_util.c:579(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:59.787827,  3] ../source3/smbd/service.c:394(set_conn_force_user_group)
  Forced user nobody
[2017/11/09 12:22:59.787851,  3] ../source3/smbd/service.c:286(find_forced_group)
  Forced group nogroup
[2017/11/09 12:22:59.787858,  3] ../source3/smbd/service.c:524(make_connection_snum)
  Connect path is '/media/test' for service [sqlsc3]  
[2017/11/09 12:22:59.787874,  3] ../source3/smbd/vfs.c:113(vfs_init_default)
  Initialising default vfs hooks
[2017/11/09 12:22:59.787878,  3] ../source3/smbd/vfs.c:139(vfs_init_custom)
  Initialising custom vfs hooks from [/[Default VFS]/]
[2017/11/09 12:22:59.787913,  2] ../source3/smbd/service.c:774(make_connection_snum)
  sqlnode03 (ipv4:10.0.189.95:52142) connect to service sqlsc3 initially as user nobody (uid=65534, gid=65534) (pid 2244)
[2017/11/09 12:22:59.790198,  2] ../source3/modules/vfs_default.c:1396(vfswrap_fsctl)
  vfswrap_fsctl (0x90248): Currently not implemented.
[2017/11/09 12:22:59.806240,  3] ../auth/ntlmssp/ntlmssp_util.c:69(debug_ntlmssp_flags)
  Got NTLMSSP neg_flags=0xe2088297
[2017/11/09 12:22:59.807268,  3] ../auth/ntlmssp/ntlmssp_server.c:452(ntlmssp_server_preauth)
  Got user= domain= workstation=[SQLNODE03] len1=1 len2=0
[2017/11/09 12:22:59.807309,  3] ../source3/param/loadparm.c:3754(lp_load_ex)
  lp_load_ex: refreshing parameters
[2017/11/09 12:22:59.807353,  3] ../source3/param/loadparm.c:548(init_globals)
  Initialising global parameters
[2017/11/09 12:22:59.807421,  3] ../source3/param/loadparm.c:2683(lp_do_section)
  Processing section "[global]"  
[2017/11/09 12:22:59.807473,  2] ../source3/param/loadparm.c:2700(lp_do_section)
  Processing section "[sqlsc3]"  
[2017/11/09 12:22:59.807511,  0] ../lib/param/loadparm.c:1668(lpcfg_do_service_parameter)
  Global parameter guest account found in service section!
[2017/11/09 12:22:59.808106,  3] ../source3/param/loadparm.c:1600(lp_add_ipc)
  adding IPC service
[2017/11/09 12:22:59.808135,  3] ../source3/auth/auth.c:178(auth_check_ntlm_password)
  check_ntlm_password:  Checking password for unmapped user \@[SQLNODE03] with the new password interface
[2017/11/09 12:22:59.808144,  3] ../source3/auth/auth.c:181(auth_check_ntlm_password)
  check_ntlm_password:  mapped user is: [SQLFSSMB]\@[SQLNODE03]
[2017/11/09 12:22:59.808156,  3] ../source3/auth/auth.c:249(auth_check_ntlm_password)
  check_ntlm_password: guest authentication for user  succeeded
[2017/11/09 12:22:59.808809,  3] ../source3/lib/access.c:338(allow_access)
  Allowed connection from 10.0.189.95 (10.0.189.95)
[2017/11/09 12:22:59.808953,  1] ../source3/param/loadparm.c:2389(lp_idmap_range)
  idmap range not specified for domain '*'  
[2017/11/09 12:22:59.808987,  3] ../source3/auth/token_util.c:547(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:59.808999,  3] ../source3/auth/token_util.c:579(finalize_local_nt_token)
  Failed to fetch domain sid for SQLFS
[2017/11/09 12:22:59.809061,  3] ../source3/smbd/service.c:394(set_conn_force_user_group)
  Forced user nobody
[2017/11/09 12:22:59.809096,  3] ../source3/smbd/service.c:286(find_forced_group)
  Forced group nogroup
[2017/11/09 12:22:59.809103,  3] ../source3/smbd/service.c:524(make_connection_snum)
  Connect path is '/media/test' for service [sqlsc3]  
[2017/11/09 12:22:59.809114,  3] ../source3/smbd/vfs.c:113(vfs_init_default)
  Initialising default vfs hooks
[2017/11/09 12:22:59.809118,  3] ../source3/smbd/vfs.c:139(vfs_init_custom)
  Initialising custom vfs hooks from [/[Default VFS]/]
[2017/11/09 12:22:59.809189,  2] ../source3/smbd/service.c:774(make_connection_snum)
  sqlnode03 (ipv4:10.0.189.95:52142) connect to service sqlsc3 initially as user nobody (uid=65534, gid=65534) (pid 2244)
[2017/11/09 12:22:59.823563,  3] ../source3/smbd/trans2.c:3289(smbd_do_qfsinfo)
  smbd_do_qfsinfo: level = 1001
[2017/11/09 12:22:59.823619,  3] ../source3/smbd/trans2.c:3289(smbd_do_qfsinfo)
  smbd_do_qfsinfo: level = 1005
[2017/11/09 12:22:59.827412,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf read=Yes write=Yes (numopen=2)
[2017/11/09 12:22:59.828102,  3] ../source3/smbd/smb2_notify.c:250(smbd_smb2_notify_send)
  smbd_smb2_notify_send: notify change called on ., filter = FILE_NAME|DIR_NAME, recursive = 1
[2017/11/09 12:22:59.834508,  3] ../source3/smbd/open.c:1192(open_file)
  Error opening file MSSQL12.SYSTEMCENTER03/MSSQL/DATA (NT_STATUS_FILE_IS_A_DIRECTORY) (local_flags=2) (flags=2)
[2017/11/09 12:22:59.835143,  3] ../source3/smbd/trans2.c:3289(smbd_do_qfsinfo)
  smbd_do_qfsinfo: level = 1011
[2017/11/09 12:22:59.838980,  3] ../source3/smbd/trans2.c:8150(smbd_do_setfilepathinfo)
  smbd_do_setfilepathinfo: MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf (fnum 1875708785) info_level=1020 totdata=8
[2017/11/09 12:22:59.839563,  3] ../source3/smbd/trans2.c:8150(smbd_do_setfilepathinfo)
  smbd_do_setfilepathinfo: MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf (fnum 1875708785) info_level=1019 totdata=8
[2017/11/09 12:22:59.877630,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=4128768 offset=0 wrote=4128768
[2017/11/09 12:22:59.885926,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=1114112 offset=0 wrote=1114112
[2017/11/09 12:22:59.886603,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.887247,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.887846,  3] ../source3/smbd/smb2_read.c:413(smb2_read_complete)
  smbd_smb2_read: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=8192 read=8192
[2017/11/09 12:22:59.888503,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.889465,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.890018,  3] ../source3/smbd/smb2_read.c:413(smb2_read_complete)
  smbd_smb2_read: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=8192 read=8192
[2017/11/09 12:22:59.890671,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.891274,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.891843,  3] ../source3/smbd/smb2_read.c:413(smb2_read_complete)
  smbd_smb2_read: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=8192 read=8192
[2017/11/09 12:22:59.892523,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.893138,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.893586,  3] ../source3/smbd/smb2_read.c:413(smb2_read_complete)
  smbd_smb2_read: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=8192 read=8192
[2017/11/09 12:22:59.894241,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.895056,  3] ../source3/smbd/smb2_read.c:413(smb2_read_complete)
  smbd_smb2_read: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=8192 read=8192
[2017/11/09 12:22:59.895772,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.896444,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 1875708785, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.897690,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf (numopen=1) NT_STATUS_OK
[2017/11/09 12:22:59.916605,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf read=Yes write=Yes (numopen=2)
[2017/11/09 12:22:59.924689,  3] ../source3/smbd/open.c:1192(open_file)
  Error opening file MSSQL12.SYSTEMCENTER03/MSSQL/DATA (NT_STATUS_FILE_IS_A_DIRECTORY) (local_flags=2) (flags=2)
[2017/11/09 12:22:59.925339,  3] ../source3/smbd/trans2.c:3289(smbd_do_qfsinfo)
  smbd_do_qfsinfo: level = 1011
[2017/11/09 12:22:59.929278,  3] ../source3/smbd/trans2.c:8150(smbd_do_setfilepathinfo)
  smbd_do_setfilepathinfo: MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf (fnum 3803670963) info_level=1020 totdata=8
[2017/11/09 12:22:59.929896,  3] ../source3/smbd/trans2.c:8150(smbd_do_setfilepathinfo)
  smbd_do_setfilepathinfo: MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf (fnum 3803670963) info_level=1019 totdata=8
[2017/11/09 12:22:59.950447,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 3803670963, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf, length=2097152 offset=0 wrote=2097152
[2017/11/09 12:22:59.951194,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 3803670963, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf, length=4096 offset=0 wrote=4096
[2017/11/09 12:22:59.951893,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 3803670963, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf, length=4096 offset=0 wrote=4096
[2017/11/09 12:22:59.952372,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 3803670963, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf, length=4096 offset=0 wrote=4096
[2017/11/09 12:22:59.952908,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 3803670963, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf, length=4096 offset=0 wrote=4096
[2017/11/09 12:22:59.953536,  3] ../source3/smbd/smb2_write.c:212(smb2_write_complete_internal)
  smb2: fnum 3803670963, file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf, length=8192 offset=0 wrote=8192
[2017/11/09 12:22:59.954730,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf (numopen=1) NT_STATUS_OK
[2017/11/09 12:22:59.958061,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf read=No write=No (numopen=2)
[2017/11/09 12:22:59.958682,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf (numopen=1) NT_STATUS_OK
[2017/11/09 12:22:59.959504,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf read=No write=No (numopen=2)
[2017/11/09 12:22:59.960024,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf (numopen=1) NT_STATUS_OK
[2017/11/09 12:22:59.974226,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf read=No write=No (numopen=2)
[2017/11/09 12:22:59.974865,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf (numopen=1) NT_STATUS_OK
[2017/11/09 12:22:59.975597,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf read=No write=No (numopen=2)
[2017/11/09 12:22:59.976115,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf (numopen=1) NT_STATUS_OK
[2017/11/09 12:22:59.992709,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf read=No write=No (numopen=2)
[2017/11/09 12:22:59.995745,  3] ../source3/smbd/trans2.c:8150(smbd_do_setfilepathinfo)
  smbd_do_setfilepathinfo: MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf (fnum 3447364331) info_level=1013 totdata=1
[2017/11/09 12:22:59.997423,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test_log.ldf (numopen=1) NT_STATUS_OK
[2017/11/09 12:22:59.998557,  2] ../source3/smbd/open.c:1316(open_file)
  nobody opened file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf read=No write=No (numopen=2)
[2017/11/09 12:22:59.999949,  3] ../source3/smbd/trans2.c:8150(smbd_do_setfilepathinfo)
  smbd_do_setfilepathinfo: MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf (fnum 2814277771) info_level=1013 totdata=1
[2017/11/09 12:23:00.002190,  2] ../source3/smbd/close.c:780(close_normal_file)
  nobody closed file MSSQL12.SYSTEMCENTER03/MSSQL/DATA/test.mdf (numopen=1) NT_STATUS_OK
[2017/11/09 12:23:00.840808,  3] ../source3/smbd/dir.c:628(dptr_create)
  creating new dirptr 0 for path ., expect_close = 0
[2017/11/09 12:23:00.840856,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found . fname=. (.)
[2017/11/09 12:23:00.840872,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found .. fname=.. (..)
[2017/11/09 12:23:00.840889,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found MSSQL12.SYSTEMCENTER03 fname=MSSQL12.SYSTEMCENTER03 (MSSQL12.SYSTEMCENTER03)
[2017/11/09 12:23:00.840902,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test3.txt fname=test3.txt (test3.txt)
[2017/11/09 12:23:00.840912,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test2.txt fname=test2.txt (test2.txt)
[2017/11/09 12:23:00.840919,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test.txt fname=test.txt (test.txt)
[2017/11/09 12:23:01.820420,  3] ../source3/smbd/smb2_notify.c:250(smbd_smb2_notify_send)
  smbd_smb2_notify_send: notify change called on ., filter = FILE_NAME|DIR_NAME, recursive = 1
[2017/11/09 12:23:02.841018,  3] ../source3/smbd/dir.c:628(dptr_create)
  creating new dirptr 0 for path ., expect_close = 0
[2017/11/09 12:23:02.841070,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found . fname=. (.)
[2017/11/09 12:23:02.841084,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found .. fname=.. (..)
[2017/11/09 12:23:02.841099,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found MSSQL12.SYSTEMCENTER03 fname=MSSQL12.SYSTEMCENTER03 (MSSQL12.SYSTEMCENTER03)
[2017/11/09 12:23:02.841110,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test3.txt fname=test3.txt (test3.txt)
[2017/11/09 12:23:02.841119,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test2.txt fname=test2.txt (test2.txt)
[2017/11/09 12:23:02.841125,  3] ../source3/smbd/dir.c:1187(smbd_dirptr_get_entry)
  smbd_dirptr_get_entry mask=[*] found test.txt fname=test.txt (test.txt)
[2017/11/09 12:23:03.820454,  3] ../source3/smbd/smb2_notify.c:250(smbd_smb2_notify_send)
  smbd_smb2_notify_send: notify change called on ., filter = FILE_NAME|DIR_NAME, recursive = 1
[2017/11/09 12:23:10.347247,  3] ../source3/smbd/server_exit.c:252(exit_server_common)
  Server exit (termination signal)
[2017/11/09 12:23:10.347422,  3] ../source3/smbd/server_exit.c:252(exit_server_common)
  Server exit (termination signal)
[2017/11/09 12:23:10.348073,  2] ../source3/smbd/service.c:1050(close_cnum)
  sqlnode03 (ipv4:10.0.189.95:52142) closed connection to service sqlsc3
[2017/11/09 12:23:10.348132,  2] ../source3/smbd/service.c:1050(close_cnum)
  sqlnode03 (ipv4:10.0.189.95:52142) closed connection to service sqlsc3
[2017/11/09 12:23:10.348160,  2] ../source3/smbd/service.c:1050(close_cnum)
  sqlnode03 (ipv4:10.0.189.95:52142) closed connection to service sqlsc3
[2017/11/09 12:23:10.348250,  3] ../source3/smbd/server_exit.c:252(exit_server_common)
  Server exit (termination signal)

Grüße

German Question Samba Linux