A test with sqlcmd -S lpc:server returned: HResult 0x57, Level 16, State 1 SQL Network Interfaces: Cannot open a Shared Memory connection to a remote SQL s erver. A windows Firewall exception for sqlsvr.exe exists. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)ĭetails: SQL server 2005 with SP3 running on Windows server 2003 Mixed Authentification Mode Remote Connection allowed Using Named Pipes and TCP/IP SQL Browser and SQL Agent services are started. Since the dll uses a external text file to configure the connection string a changed this : Server=Server DataBase=HERZ Integrated Security=TRUE to this Server=Server DataBase=HERZ User ID=DOMAIN\USER Password=XXX! Integrated Security=no since then I can’t run the dll anymore.
Due to security question I was asqed to cange the way this dll acces the SQL server from windows authentification to named pipe authentification. This dll is suposed to connect to a MSSQL server data base, execute a Stored Procedure and retreve the result. DLL that is used to provide security to a SSAS cube.
0 kommentar(er)
