[dba-SQLServer] Problem Finding Database Engine

Thanks Doug and Dan. All seems to be working now.

Arthur

On Sun, May 15, 2011 at 3:25 PM, Dan Waters <df.waters at comcast.net> wrote:

> Hi Arthur,
>
> I've always connected via TCP/IP.  IIRC, Management Studio is a remote
> connection to SQL Server, even on the same PC.  Because only TCP/IP handles
> remote requests, that's what must be used to be able to connect with
> Management Studio (and probably Visual Studio as well).
>
> Under administrative, go to the Computer Management control panel.  At the
> bottom open up Services and Applications.  Then you'll see SQL Server
> Configuration Manager.
>
> Now you'll see SQL Server Network Configuration - open that and then open
> Protocols for SQL Server.  You'll see the list of protocols - enable TCP/IP
> and disable the others.
>
> You may also see SQL Native Client 10.0 Configuration.  Open that and then
> open Client Protocols.  Again you'll see the list of protocols - enable
> TCP/IP and disable the others.
>
>
> Hope that works!
> Dan
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
> Fuller
> Sent: Sunday, May 15, 2011 10:38 AM
> To: Discussion concerning MS SQL Server
> Subject: [dba-SQLServer] Problem Finding Database Engine
>
> Lately I've been rebuilding my main box. It's running Windows 7 Ultimate
> 64-bit, and SQL 2008 Enterprise 64-bit.The SQL installation seemed to go
> perfectly, but when I try to run Management Studio I am unable to connect.
> I
> get a message saying "a network or instance-specific error occurred while
> establishing a connection to SQL Server. The server was not found or was
> not
> accessible. Verify that the instance name is correct and that SQL Server is
> configured to allow remove connections. (provider:Named Pipes Provider,
> error: 40 - Could not open a connection to SQL Server, error: 2).
> This was from trying to connect to Database Engine. However I am able to
> connect to Analysis Services (which happens to contain no databases at the
> moment, but at least I can connect).
>
> Any idea what might be wrong and how I can fix it?
>
> TIA,
> Arthur
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>