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 MorganJohn Morgan (jfm@.XXwoodlander.co.uk) writes:
> 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.
>...
> 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,
And we don't even know their configuration. Or yours.
Can you connect with the IP address?
In the alias you have set up in Client Network Utility, have you checked
TCP/IP, entered the IP address, and unchecked "Dynamically determine port"
and specified 1433?
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi John
Check out the information regarding port 1434 and MSDE.
http://msdn.microsoft.com/library/d...asp?frame=true
John
"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
news:uhu3s09t8k7ngckgm5tjvq53bh1h76a3v0@.4ax.com...
>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|||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:
>Hi John
>Check out the information regarding port 1434 and MSDE.
>http://msdn.microsoft.com/library/d...asp?frame=true
>John
>"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
>news:uhu3s09t8k7ngckgm5tjvq53bh1h76a3v0@.4ax.com...
>>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|||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/defaul...kb;en-us;287932, but what
does netstat -an return?
John
"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
news:3hj6s0hcgim5b3u00uan9mfbqpvrk71537@.4ax.com...
> 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:
>>Hi John
>>
>>Check out the information regarding port 1434 and MSDE.
>>http://msdn.microsoft.com/library/d...asp?frame=true
>>
>>John
>>
>>"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
>>news:uhu3s09t8k7ngckgm5tjvq53bh1h76a3v0@.4ax.com...
>>>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
>sqlsql
No comments:
Post a Comment