Hi
Before 'Build 2600 Service Pack 1' it probably says "on Windows NT 5.1" i.e.
you are on Windows XP service pack 1. What does the first (few) line of
@@Version return?
I am not sure if I have already posted
http://support.microsoft.com/default...b;en-us;287932, but what
does netstat -an return?
John
"John Morgan" <jfm@XXwoodlander.co.uk> wrote in message
news:3hj6s0hcgim5b3u00uan9mfbqpvrk71537@4ax.com...[color=blue]
>
> Thank you Erland and JOhn
>
> Re fixed IP address: my ISP tells me that as I do not have a fixed IP
> address it means I cannot allow me access based on my IP address.
>
> Yes, I have checked and rechecked that the Client Network Utility is
> showing TCP/IP and that the 1433 port is specified.
>
> I have looked at the Microsoft article suggested by John. This appears
> to indicate that unless everything on the computer is upgraded then
> port 1434 will be used when connecting online.
>
> I have now uninstalled my current version of MSDE and attempted to
> install a new default instance using the SP3a disk. this has brought
> its own problem in that the apparently successfully installed new
> version still reads 'Build 2600 Service Pack 1'
>
> I have asked for advice on this on the MSDE News group but if you had
> an insight into this it would be welcome,
>
> Best wishes, John Morgan
>
>
> On Thu, 16 Dec 2004 22:24:55 -0000, "John Bell"
> <jbellnewsposts@hotmail.com> wrote:
>[color=green]
>>Hi John
>>
>>Check out the information regarding port 1434 and MSDE.
>>
http://msdn.microsoft.com/library/de...asp?frame=true
>>
>>John
>>
>>"John Morgan" <jfm@XXwoodlander.co.uk> wrote in message
>>news:uhu3s09t8k7ngckgm5tjvq53bh1h76a3v0@4ax.com. ..[color=darkred]
>>>I have Enterprise Manager on my local machine. For the last twelve
>>> months it has been connecting without problem to my online SQL Server
>>> database provided by my ISP.
>>>
>>> Three weeks ago the ISP applied some sort of extra security
>>> arrangements to their SQL Server to allow access only through port
>>> 1433. they have told me to configure an alias using Network Client and
>>> to register this alias in the usual way using my Enterprise Manager.
>>>
>>> My problem is that despite creating the alias in exactly the way
>>> instructed I just cannot connect to online database. I keep getting
>>> the SQL Server does not exist or access denied when I try to connect.
>>>
>>> As a result of advice obtained I have tried using the lite version of
>>> the 'littleADmin' tool available from
>>>
http://www.mylittletools.net/scripts/en/mla_sql/
>>>
>>> Using this useful looking software I find I cannot connect to the
>>> online SQL database when it is installed on my own local machine but
>>> if I install it on my website it does connect without problem to my
>>> online SQL. Server database
>>>
>>> However I need to use my more powerful Enterprise Manager to connect,
>>> my question (at last!) is:
>>>
>>> 1. Is there likely to be a problem trying to connect to my online
>>> database from Enterprise Manager on my local machine as a result of
>>> the new security arrangements. In other words, is there something
>>> analagous to what is happening with the 'littleAdmin tool' whereby
>>> using Enterprise Manager I cannot connect from my local machine for
>>> some reason obvious to everyone except myself??
>>> or
>>> 2. Is it possible that there is some problem arising from Net Client?
>>> (the aliases appear in Enterprise Manager OK)
>>>
>>> I know my ISP should be answering this sort of question but they just
>>> don't seem to know. I need to connect even if only to download my
>>> database and take it to another ISP,
>>>
>>> Best wishes, John Morgan[/color]
>>[/color]
>[/color]
