Re: MS SQL 2005 Configuration ???

It sounds like you are running SQLExpress, not SQLServer.
I don't have SQL Express, so I can't replicate what you're seeing.

When I open my Surface Area Configuration and select
"Surface Area Configuration for Services and Connections",
it brings up another screen with a listbox on the left-hand
side.

The first entry in my listbox is the name of my SQLServer
instance (yours may be SQLExpress). (Also displayed on
that level of the tree are Integration Services and
SQL Server Browser). When I open my SQLServer branch
of the tree, I see Database Engine, Reporting Services,
SQLServer Agent, and FUll-TextSearch.

Under DatabaseEngine, I have two options: Service and
Remote Connections. The latter is the one you're looking for.

Try opening the one in your tree list that says SQLExpress.
I would think that corresponds to my SQLServer instance.

As for how to confirm that SQLServer2005 is installed, I know
you can have both the full version and the Express version
installed at the same time. When I hit Start/Programs, I see
an entry for "Microsoft SQL Server 2005" which has links to
all the server stuff like SQLServer Management Studio, SQLServer
Business Integration Development Studio, Configuration, etc.
Do you see that on your machine?

You can also look at the running services on your machine
and see if you can tell from there. Open your control panel,
open Administrative Tools, open Services and see what you
see. I've got 8 different SQLServer entries -- the actual
server (it shows my server name), Active Directory helper,
Agent, Browser, FullText Search, Integration Services,
Reporting Services, and VSS Writer. What do you see?

Hope this helps.

Robin S.
--------------------------------------------------
"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:erlCkNxPHHA.4280@xxxxxxxxxxxxxxxxxxxxxxx
Thanks but my screens must look different than yours.

I have a command under my SQL Server 2005 menu called "SQL Surface
Area Configuration". So I selected that.

That opened a window where the closest thing to "configuring the
Services & Connections" was "Surface Area Configuration for Services
and Connections".

That opens another window, but I don't see anything about "Remove
Connections" or "Database Engine". It has a tree list with the two
roots being "SQLEXPRESS" and "SQL Server Browser". I noticed the SQL
Server Browser was disabled. I managed to enable it but that did not
resolve the issue.

Do you know where I went wrong? It says SQL Server 2005--why is the
first item SQLEXPRESS? How can I confirm I have SQL 2005 installed?

Thanks again.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com


"RobinS" <RobinS@xxxxxxxxxxxxxxx> wrote in message
news:uJednZbEA95TXCjYnZ2dnUVZ_rSjnZ2d@xxxxxxxxxxxxxx
Open the Surface Area Configuration for SQLServer and
select "configuring the Services & Connections",
select "Remove Connections" under "Database Engine".
Select "Local and Remote connections".
I have mine set to accept both TCP/IP and named pipes.

Remote connection does not mean a connection from another
computer; it means a connection from outside of SQLserver,
like from a website or application, even if they are running
on the same machine.

Robin S.
---------------------------------------------
"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:u9sEN8pPHHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
Greetings,

I'm fairly new to ASP.NET/ADO.NET and SQL. I worked out a few issues
with the help of some nice folks here.

Now, I'm starting a clean Web site project but am having trouble
right off again.

I'm trying to create a new database using MS SQL Server 2005. I
entered localhost as the Server name, selected Use Windows
Authentication, and entered a new name for my database. When I click
OK, I get the following error:

Microsoft Visual Studio
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)

As far as I know, localhost does not indicate a remote connection. I
eventually connected to a database previously with SQL Express
Edition, so I'm guessing this might have to do with my SQL
configuration.

I'm using Visual Studio 2005 on a new C#/ASP.NET project. I'm
running Windows XP Professional w/SP2. Sorry, but virtually every
suggestion I get will probably need to include instructions on how
to do--I'm quite new to this.

Any help greatly appreciated!

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com








.

Relevant Pages

  • Re: Dot Net 2.0 or SQL Server 2005 problem?
    ... Assume the SQLExpress set up is OK, whther you can actually access the SQL ... After installing SQL Server Express, if you did not add any SQL login ... Configuration' and set the option to 'Using Both TCP/IP and Named Pipes'. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server 2005 Express Connection
    ... Some people have been having issues when trying to make remote connections ... networking protocols are disabled by default in SQL Server Express. ...
    (microsoft.public.sqlserver.connect)
  • ADO data control, proper use
    ... When opening the program there is currently five connections to SQL ... connections for a single program to have open with SQL Server. ... Is there a way to close the ado data control connection after a ...
    (microsoft.public.vb.database.ado)
  • Re: MS Access linked tables SQL Server
    ... Protocol Encryption selection so that all connections to the SQL Server are ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server for Oracle DBAs
    ... It's no more anything to do with SQL Server than ORacle's ODBC driver - they are just other products that allow connection to SQL Server, also, it refers to SQL SErver 2000 which is no longer supported by Microsoft - the majority are on SQL Server 2005. ... the SQL Server team got the software quality life cycle right - oracle haven't; and don't take my word for it - as you well know the trade press take that view as well. ... The context of the presentation at that point was simply background and was being given to a SqlServer audience. ...
    (comp.databases.oracle.server)