Error while establishing connection to server

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Error while establishing connection to server

Postby MarkI » Sat Nov 17, 2007 2:48 am

Hi,

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.

Mark
MarkI
 
Posts: 1
Joined: Sat Nov 17, 2007 2:41 am

Postby chris.buckingham » Thu Nov 22, 2007 6:24 pm

You can access the SQL Express connection - when you fire up the SQL Package you have framed 'Select Database' set of options.

For Server insert

.\\SQLExpress

in the Server drop down combo box (note the '.\\' before the string 'SQLExpress' is necessary)

This will force the SQLExpress to be seen. If it doesn't see a SQL server then it will always come up with this message - it is a bit misleading as it is a blanket message for all circumstances!
Chris Buckingham
Red-Gate support
chris.buckingham
 
Posts: 56
Joined: Mon Jul 30, 2007 1:39 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests