I am attempting to create a connection manager in Microsoft SQL Server Data Tools (SSDT) for a Visual Studio 2017 integration services project.
The settings I am using in the Connection Manager are:
- Provider: Native OLE DB\SQL Server Naive Client 11.0
- Server name: the name of the local machine
- Log on to the server: Windows Authentication
- Connect to a database: Select or enter a database name
When I use the Test Connection feature, I receive an error message:
Test connection failed because of an error in initializing provider. Login timeout expired A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. Named Pipes Provider: Could not open a connection to SQL Server ..
I am using SQL Server 2017 and Microsoft SQL Server Management Studio 18. Remote connections have been enabled, however, the SQL Server Agent and SQL Server Browser are not running and the TCP/IP Protocols for SQLEXPRESS is disabled. I am unable to enable this without an Access is denied (0x80070005) error.
I have followed all the guides, yet I am still unable to progress. Could someone please provide me with further guidance?