Re: Visual Studio 2005 "How do you connect/create a new sql database?"

Tech-Archive recommends: Fix windows errors by optimizing your registry

You may find it helpful to run through my tutorial. It addresses some common
issues.
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.


"Gary.J" <GaryJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F3B42CB0-0906-4037-BC00-D9404946982A@xxxxxxxxxxxxxxxx
Hello

I have just got the trial dvd for Visual Studio 2005 Professional

When trying to make a new sql server database, I get an error box:-

********************************************************************************************************

An error has occured while establishing a connection to the server. When
connecting tp 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 Provide, error: 40 - Could not open a
connection to SQL Server)

********************************************************************************************************

My sql server is shown on my computer via server explorer, but it appears
that sql is not configured correctly?

I just want it to work on the local machine, can you please help?

Thanks

Gary.








.

Relevant Pages

  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)