Prev: Can't use Sql server when using forms authentication
Next: I have now probably done a very silly thing
From: Jason Huang on 4 Jan 2010 02:12
Hi,

We've installed the SQL Server 2000 on our Windows Server 2008.
However, we can't connect SQL Query Anylyzer to the SQL Server 2000 on the
Win2008.
Ho do we fix this problem.
Thanks for help.


Jason


From: Tony Rogerson on 4 Jan 2010 03:03
Double check you've applied SP4

"Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
news:uHT7E1QjKHA.2160(a)TK2MSFTNGP02.phx.gbl...
> Hi,
>
> We've installed the SQL Server 2000 on our Windows Server 2008.
> However, we can't connect SQL Query Anylyzer to the SQL Server 2000 on the
> Win2008.
> Ho do we fix this problem.
> Thanks for help.
>
>
> Jason
>
From: Jason Huang on 4 Jan 2010 03:52
It's SP4, but still can't make the connection at all.

"Tony Rogerson" <tonyrogerson(a)torver.net>
???????:CC6F7A8A-10B3-477A-9754-D912999346CE(a)microsoft.com...
> Double check you've applied SP4
>
> "Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
> news:uHT7E1QjKHA.2160(a)TK2MSFTNGP02.phx.gbl...
>> Hi,
>>
>> We've installed the SQL Server 2000 on our Windows Server 2008.
>> However, we can't connect SQL Query Anylyzer to the SQL Server 2000 on
>> the Win2008.
>> Ho do we fix this problem.
>> Thanks for help.
>>
>>
>> Jason
>>


From: Abba on 4 Jan 2010 04:03
Whats the error, Jason?

"Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
news:uJ6qGtRjKHA.4912(a)TK2MSFTNGP02.phx.gbl...
> It's SP4, but still can't make the connection at all.
>
> "Tony Rogerson" <tonyrogerson(a)torver.net>
> ???????:CC6F7A8A-10B3-477A-9754-D912999346CE(a)microsoft.com...
>> Double check you've applied SP4
>>
>> "Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
>> news:uHT7E1QjKHA.2160(a)TK2MSFTNGP02.phx.gbl...
>>> Hi,
>>>
>>> We've installed the SQL Server 2000 on our Windows Server 2008.
>>> However, we can't connect SQL Query Anylyzer to the SQL Server 2000 on
>>> the Win2008.
>>> Ho do we fix this problem.
>>> Thanks for help.
>>>
>>>
>>> Jason
>>>
>
>


From: John Bell on 4 Jan 2010 13:19

"Jason Huang" <JasonHuang8888(a)hotmail.com> wrote in message
news:uHT7E1QjKHA.2160(a)TK2MSFTNGP02.phx.gbl...
> Hi,
>
> We've installed the SQL Server 2000 on our Windows Server 2008.
> However, we can't connect SQL Query Anylyzer to the SQL Server 2000 on the
> Win2008.
> Ho do we fix this problem.
> Thanks for help.
>
>
> Jason

My guess is that you've installed MSDE and I can remember that far back I
think the default is not to have TCP/IP enabled if they aren't specified.

See http://support.microsoft.com/kb/814130 for more.

John

 |  Next  |  Last
Pages: 1 2
Prev: Can't use Sql server when using forms authentication
Next: I have now probably done a very silly thing