Problem with sample databases

I have installed SQL Express 2005 together with VS 2005. After a while I found out that the sample databases (Northwind and Pubs) were missing, so I installed them. According to the 'Readme', which comes with the installation I could choose between attaching the db to the Server or running a SQL script.

Neither works. I've read this link about remote connections (http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx). My development machine is just a local single computer and I still get this error message:

'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 under the default settings SQL Server does not allow remote connections.'

I' ve opened TCP/IP and Named Pipes and I get the same result when trying to connect from the Server Explorer in VS.

Thanks for your help.

Hey,

SQL Server 2005 doesn't install with the sample databases anymore; I am having training on it, and that is what I just found out. Also, to setup remote connections, you can do so in the SQL Server Surface Area Configuration.

Brian

|||

Hey,

TCP/IP and Named Pipes are only selectable if you allow remote connections in the SQL Server Surface Area Configuration.

RTFT.

Anybody else coming up with an idea?