A SQLPackage file was provided to me. I have SQL Server 2005 Express installed on a Vista machine. When I double-click on the file to extract a db, I get this:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I went in to SQL Server 2005 Surface Area Configuration and changed the SQLEXPRESS Database Engine's Remote Connections to use Remote and local connections (I tried both "Using named pipes only" and "Using both TCP/IP and named pipes"). I made sure to stop and start the Database Engine service after each change. Unfortunately, this did not work.
I am connecting to the database with Windows Authentication.
Ideas? Help... Thank you.