I have succeeded in getting SQL Server 2005 Express running on my
laptop. Now I would like to connect to it with SQL Server Enterpise
Manager (2002) on my desktop pc. When I use SQL Sever Mgt Studio
Express I always use Sever name THINKPAD\SQLEXPRESS and Authentication
Windows Authentication. It doesn't work from the desktop. Where do I
start to fix the problem?

Enterprise Manager can't connect to 2005 instances. You need
to use a 2005 tool - or for 2000 tools Query Analyzer will
probably connect to Express. I never tried it with Express
but it connects to other editions of 2005 instances.

-Sue

On Wed, 27 Sep 2006 14:32:57 -0400, cj <cj@nospam.nospam>
wrote:

>I have succeeded in getting SQL Server 2005 Express running on my
>laptop. Now I would like to connect to it with SQL Server Enterpise
>Manager (2002) on my desktop pc. When I use SQL Sever Mgt Studio
>Express I always use Sever name THINKPAD\SQLEXPRESS and Authentication
>Windows Authentication. It doesn't work from the desktop. Where do I
>start to fix the problem?

Oh, Well, I guess it's a good thing I think I've figured out the
complete structure of the database and indexes and made a copy of them
in SQL Server 2000. Now to change a few lines of code to reference the
database on the SQL Server 2000 and if that works I can dump this
express c%@p.

Sue Hoegemeier wrote:
> Enterprise Manager can't connect to 2005 instances. You need
> to use a 2005 tool - or for 2000 tools Query Analyzer will
> probably connect to Express. I never tried it with Express
> but it connects to other editions of 2005 instances.
>
> -Sue
>
> On Wed, 27 Sep 2006 14:32:57 -0400, cj <cj@nospam.nospam>
> wrote:
>
>> I have succeeded in getting SQL Server 2005 Express running on my
>> laptop. Now I would like to connect to it with SQL Server Enterpise
>> Manager (2002) on my desktop pc. When I use SQL Sever Mgt Studio
>> Express I always use Sever name THINKPAD\SQLEXPRESS and Authentication
>> Windows Authentication. It doesn't work from the desktop. Where do I
>> start to fix the problem?
>

Hi,
My understanding of your issue is:
You want to use SQL Server 2000 Manager to manage your SQL Server 2005
Express instance.
If I have misunderstood, please let me know.

Unfortunately SQL Server 2000 Manager can't be used to register SQL Server
2005 Express instance.
You can use SQL Server 2000 Query Analyzer to connect to it. I'm not very
clear of your intent, however if you just want to manage your SQL Server
2005 Express instance, I recommend that you download SQL Server 2005
Express Management Studio which has a similar GUI management function with
SQL Server Enterprise Manager. You can download it from:
http://www.microsoft.com/downloads/d...5AE-4BD1-4E3D-
94B8-5A0F62BF7796&DisplayLang=en

If you can't connect to SQL Server 2005 Express in Query Analyzer. I
recommend that you enable TCP/IP protocol on your SQL Express instance via
SQL Server Configuration Manager and specify a port; run the cliconfig.exe
at the client computer to add an alias for your SQL Express instance; then
you can logon the SQL Express instance with the alias.
If you still can't connect to the SQL Express, you can refer to:
Cannot connect to remote SQL 2005 Express Server
http://support.microsoft.com/kb/555585/en-us

If you have any other questions or concerns, please feel free to let me
know. It's my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

This is a common problem. There is a short connectivity tutorial in Books
Online. See http://msdn2.microsoft.com/en-us/library/ms345318.aspx
Lesson 2 is Lesson 2: Connecting from Another Computer .
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:q7jlh2h7nb98b75pqma0028us04k1t6jk3@4ax.com...
> Enterprise Manager can't connect to 2005 instances. You need
> to use a 2005 tool - or for 2000 tools Query Analyzer will
> probably connect to Express. I never tried it with Express
> but it connects to other editions of 2005 instances.
>
> -Sue
>
> On Wed, 27 Sep 2006 14:32:57 -0400, cj <cj@nospam.nospam>
> wrote:
>
>>I have succeeded in getting SQL Server 2005 Express running on my
>>laptop. Now I would like to connect to it with SQL Server Enterpise
>>Manager (2002) on my desktop pc. When I use SQL Sever Mgt Studio
>>Express I always use Sever name THINKPAD\SQLEXPRESS and Authentication
>>Windows Authentication. It doesn't work from the desktop. Where do I
>>start to fix the problem?
>