Remote Server using Enterprise Manager

Hi,
please help
I am new with MS SQL Server.
I do not have any problem with my local server but has problem with remote
server.
I am trying to connect my SQL database in my internet site.
I want to design my database using "SQL Server Enterprise Manager" but I
have received this error.
A connection could not establish to SQLWeb
Reason : SQL Server does not exist or access denied
ConnectionOpen(Connect())..
Please verify SQL Server is running and check your SQL Server registration
properties(By right-clicking on SQLWEb node)
My web hosting suggested me to create connection using "SQL Server Client
Network Utility"
So I Add Server Alias SQLWeb using TCPIP using port Number 1433.
Then I add "SQL Server Registration" using SQL Server Enterprise Manager and
had the above message.
I have Check all My "Server name/Connection Parameter" .
What Could be wrong ?
Hermawih
Hi Hermawih,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: When you want to
register a remote SQL Server Instance, you got the "SQL Server does not
exist or access denied" error. If I misunderstood your concern, please feel
free to point it out.
"SQL Server exist or access denied" error may be caused by many reason. To
narrow down the issue, you may do the following steps:
1. Verify your DNS settings.
Use the ping <Server Name> command in the command prompt.
If you can ping the Server, please make sure that you can use the
Telnet program to connect to the port where SQL Server is listening. You
can use the Telnet <IP Address> <Port Number> command in the command prompt.
Verify your remote SQL Server Service is running.
2. Verify the enabled protocols and aliases.
Check the Client Network Utility in the Start Menu and enable all the
protocols that you want to use.
3. Connectivity problems may also occur because of problems with MDAC.
You can also test connectivity to the instance of SQL Server by using a
.udl file.
The following article will help you to do this:
244659 SAMPLE: How to create a data link file with Windows 2000
(http://support.microsoft.com/kb/244659/)
4. You may test the connectivity by using one or more following method
to check it:
a) Test the connectivity to the instance of SQL Server by using both
SQL Server Authentication and Windows authentication.
b) Test the connectivity to the instance of SQL Server from other data
sources, such as an ODBC DSN, a .udl file, SQL Query Analyzer, SQL Server
Enterprise Manager, the isql utility, or the osql utility.
c) Test the connectivity by using a different login account to help you
determine if the problem is associated with a particular login account.
d) Try to connect to the instance of SQL Server by using the IP address
instead of the server name.
e) Try to specify the specific port that the instance of SQL Server is
listening on, either by creating an alias or by adding a port number to the
connection string (MyServer\MyInstance, 1433, for example).
The following Knowledge base article will give you the detail information:
How to troubleshoot connectivity issues in SQL Server 2000
http://support.microsoft.com/?id=827422
Hope this will be helpful!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Wei Lu.
Yes that is the problem "SQL Server does not
exist or access denied"
I did try using DSN , Query Analyzer, SQL Server Manager and all of them
failed for remote SQL Server Instance. For local, I have no problem.
You gave me a lot of information. Since I am new to SQL Server, Let me play
around using SQL Server 2000 for a day or two or probably more. Hopefully
the information you gave will work. I did copy your answer to my notepad and
that will keep me busy for quite sometime.
Thank you again
Hermawih
"Wei Lu" wrote:

> Hi Hermawih,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: When you want to
> register a remote SQL Server Instance, you got the "SQL Server does not
> exist or access denied" error. If I misunderstood your concern, please feel
> free to point it out.
> "SQL Server exist or access denied" error may be caused by many reason. To
> narrow down the issue, you may do the following steps:
> 1. Verify your DNS settings.
> Use the ping <Server Name> command in the command prompt.
> If you can ping the Server, please make sure that you can use the
> Telnet program to connect to the port where SQL Server is listening. You
> can use the Telnet <IP Address> <Port Number> command in the command prompt.
> Verify your remote SQL Server Service is running.
> 2. Verify the enabled protocols and aliases.
> Check the Client Network Utility in the Start Menu and enable all the
> protocols that you want to use.
> 3. Connectivity problems may also occur because of problems with MDAC.
> You can also test connectivity to the instance of SQL Server by using a
> .udl file.
> The following article will help you to do this:
> 244659 SAMPLE: How to create a data link file with Windows 2000
> (http://support.microsoft.com/kb/244659/)
> 4. You may test the connectivity by using one or more following method
> to check it:
>
> a) Test the connectivity to the instance of SQL Server by using both
> SQL Server Authentication and Windows authentication.
> b) Test the connectivity to the instance of SQL Server from other data
> sources, such as an ODBC DSN, a .udl file, SQL Query Analyzer, SQL Server
> Enterprise Manager, the isql utility, or the osql utility.
> c) Test the connectivity by using a different login account to help you
> determine if the problem is associated with a particular login account.
> d) Try to connect to the instance of SQL Server by using the IP address
> instead of the server name.
> e) Try to specify the specific port that the instance of SQL Server is
> listening on, either by creating an alias or by adding a port number to the
> connection string (MyServer\MyInstance, 1433, for example).
>
> The following Knowledge base article will give you the detail information:
> How to troubleshoot connectivity issues in SQL Server 2000
> http://support.microsoft.com/?id=827422
>
> Hope this will be helpful!
>
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ================================================== ====
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
|||Hi Hermawih,
Thanks for your update.
I think you need to check the DSN and try to ping the Server first. If this
does not work, it means that the server name is not correct or the SQL
Server Service is not start on the remote Server.
Hope this will be helpful.
I look forward for your reply.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Wei Lu.
I did try ping my SQL server , I received ,
pinging xx.xxx.xx.xx with 32 bytres of data:
Request Timed out.
Request Timed out.
Request Timed out.
Reply from xx.x.x.xxx:Destination net unreachable.
Ping Statistics for xx.xxx.xx.xx:
Packets: Sent=4, Received=1, Lost=3 (75% loss),
Approximate round trip times in milli-seconds:
Minimum=0ms, Maximum=0ms, Average = 0ms
Is that good or bad ?
What is that means ?
What I could not understand is that I could create tables, Fields and
inserting some values by coding .
I chatted with someone in web hosting company and said that he could connect
to my server. I followed all his suggestion including turning off my
firewall but so far It did not work.
I am using Window XP Profesional with sp2 , SQL Server 2000 Developer
edition . Before that I installed SQL server 2005 express edition but then I
changed to SQL server 2000 Developer edition.
What is the problem ..?.
Hermawih
http://www.bocsoft.net
Hermawih
"Wei Lu" wrote:

> Hi Hermawih,
> Thanks for your update.
> I think you need to check the DSN and try to ping the Server first. If this
> does not work, it means that the server name is not correct or the SQL
> Server Service is not start on the remote Server.
> Hope this will be helpful.
> I look forward for your reply.
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> ================================================== ====
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Hermawih,
Thank you for the update.
The result of Ping command shows that the network does not work fine.
To resolve it, please contact your local network administrator.
Also, you may use the ipconfig /all command to check your IP configuration.
The following Knowledge base article will help you to do the troubleshoot
step:
How to Troubleshoot Basic TCP/IP Problems
http://support.microsoft.com/default...b;EN-US;169790
Hope this will be helpful.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Wei Lu,
Thank you .
Okkay I will try to research your links.
I will get back to you for the result.
My last choice probably will forget about using the tool and starts coding
to create tables, fields etc.
Hermawih
http://www.bocsoft.net
"Wei Lu" wrote:

> Hi Hermawih,
> Thank you for the update.
> The result of Ping command shows that the network does not work fine.
> To resolve it, please contact your local network administrator.
> Also, you may use the ipconfig /all command to check your IP configuration.
> The following Knowledge base article will help you to do the troubleshoot
> step:
> How to Troubleshoot Basic TCP/IP Problems
> http://support.microsoft.com/default...b;EN-US;169790
> Hope this will be helpful.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi hermawih,
Thanks for the update.
I'd like to know what do you mean that you can create table by coding? Do
you use the Query Analyzer?
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Sorry, I should clarify this :
I tried using TCP/IP connection with my local network server. It worked.
I tried using TCP/IP to create an instance of SQL server from another SQL
server in my local network. It worked .
Hermawih
http://www.bocsoft.net
"Wei Lu" wrote:

> Hi hermawih,
> Thanks for the update.
> I'd like to know what do you mean that you can create table by coding? Do
> you use the Query Analyzer?
> Sincerely yours,
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Hermawih,
Thanks for the update.
Since you need to use the EM to create table, fields etc, I suggest you to
use the SQL Web Data Administrator to do that.
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. You can deploy it on the web host and use
it to manage your database.
You can download this tool from the following url:
http://www.microsoft.com/downloads/d...798-c57a-419e-
acbc-2a332cb7f959&displaylang=en
Hope this will be helpfu.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.