RobinS
Wed Jan 24 12:10:18 CST 2007
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@softcircuits.com> wrote in message
news:erlCkNxPHHA.4280@TK2MSFTNGP02.phx.gbl...
> 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@NoSpam.yah.none> wrote in message
> news:uJednZbEA95TXCjYnZ2dnUVZ_rSjnZ2d@comcast.com...
>> 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@softcircuits.com> wrote in message
>> news:u9sEN8pPHHA.3544@TK2MSFTNGP03.phx.gbl...
>>> 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
>>>
>>>
>>
>>
>
>