Re: Can't connect on Local Machine

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

http://sql.veranoest.net/sql_faq.htm#ExpressConnect

Q: I have installed SQL Server Management Studio Express (SSMSE).
How do I connect to the Database Engine?

A: The default installation of SQL Server Express uses an instance
name (SQLExpress). This instance name must be provided to connect
to SQL Server Express by using SSMSE. If you have a instance name
other than SQLExpress, connect by using computer name\instance
name.

To connect SSMSE to a SQL Server 2005 Express Database Engine
instance, follow these steps:

1. In the Connect to Server dialog box, specify one of the
following:
.\sqlexpress
(local)\sqlexpress
server name\sqlexpress
2. Click Enter
_________________________________________________________
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___

=?Utf-8?B?UGF1bCBNZW5kbGVzb2hu?=
<PaulMendlesohn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote on 04 nov 2007 in
microsoft.public.sqlserver.connect:

I am running SQL Server Express on a local machine, when I try
to connect to a server on a local machine I get the message
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

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: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance
Specified) (Microsoft SQL Server, Error: -1)

How can I get round this problem?
Thanks
.

Relevant Pages

  • Re: Recordsource only available to Administrator on clients
    ... In the ADP itself, when a connection is established under a non- ... Administrator Windows logon, all stored procedures, for example, are ... white arrow head is absent in SSMSE, just as in SSMSE the stored ... It seems that SQL Server should be designed to ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SSMSE Help is missing
    ... Integrated help is not a feature of SSMSE. ... You must either use Books Online as a stand alone component or use the full ... Management Studio from the full editions of SQL Server. ...
    (microsoft.public.sqlserver.tools)
  • Re: SSEnterprise looking like Express
    ... I'm not advising you to uninstall the Database Engine, I'm telling you to uninstall only the SSMSE itself which is the GUI to manage your SQL Server instances. ... If you need this edition you install it, if you don't then simply you don't install it. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot find a GUI to execute a query
    ... SSMSE but there are some other features, like SQL Server Profiler, that I ... I guess I can still 'Script Stored Procedure As Execute To' a new window, ... How about using SSMSE instead of SSMS? ...
    (microsoft.public.sqlserver.tools)
  • Re: Large MySQL SQL File -> ASP.NET Database
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... can a database engine like MySQL function adequately from such an application. ... The SQL queries you use to access it would also require conversion. ... And, given the long line lengths, it's long enough to bring SQL Server Management Studio Express pretty much to it's knees. ...
    (microsoft.public.dotnet.framework.adonet)