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.
Showing posts with label remoteserver. Show all posts
Showing posts with label remoteserver. Show all posts
Tuesday, March 20, 2012
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 '
HermawihHi 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 fee
l
> 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 promp
t.
> 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 metho
d
> 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 yo
u
> 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 addres
s
> 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 th
e
> 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 thi
s
> 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/defaul...kb;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/defaul...kb;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.|||Thanks Wei Lu.
--
I'd like to know what do you mean that you can create table by coding? Do
you use the Query Analyzer?
--
I tried using Query Analyzer too. It failed - same problem.
What I meant creating table by coding :
I went to the web site and use its tool for creating tables, fields and
inserting values.
I also create an ASP page and put it there in my site and read the values of
a table.
I could do that.
Perhaps What I will try next is creating an ASP NET page and put it there
and will try to create some objects on my SQL server such as tables, fields
,
etc .
I have sent an Email about my problem to my web hosting company about the
possibilty of security setting problems. But I have not got any reply from
them. I will try again to contact them. If I may, can I attach some of this
discussion and send it to them .
I tried using TCP/IP connection with my local network server. It worked.
I am not sure if it is because of the speed of the connection ' My
connection speed is about 46 Kbps .
Or perhaps my ISP problem '
My Computer - ISP - Web Hosting .
Is that any possibility the problem is with ISP ?
Thank you so very much for being patience.
Hermawih
http://www.bocsoft.net
Hermawih
"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
.
>|||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
.
>
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 '
HermawihHi 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 fee
l
> 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 promp
t.
> 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 metho
d
> 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 yo
u
> 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 addres
s
> 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 th
e
> 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 thi
s
> 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/defaul...kb;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/defaul...kb;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.|||Thanks Wei Lu.
--
I'd like to know what do you mean that you can create table by coding? Do
you use the Query Analyzer?
--
I tried using Query Analyzer too. It failed - same problem.
What I meant creating table by coding :
I went to the web site and use its tool for creating tables, fields and
inserting values.
I also create an ASP page and put it there in my site and read the values of
a table.
I could do that.
Perhaps What I will try next is creating an ASP NET page and put it there
and will try to create some objects on my SQL server such as tables, fields
,
etc .
I have sent an Email about my problem to my web hosting company about the
possibilty of security setting problems. But I have not got any reply from
them. I will try again to contact them. If I may, can I attach some of this
discussion and send it to them .
I tried using TCP/IP connection with my local network server. It worked.
I am not sure if it is because of the speed of the connection ' My
connection speed is about 46 Kbps .
Or perhaps my ISP problem '
My Computer - ISP - Web Hosting .
Is that any possibility the problem is with ISP ?
Thank you so very much for being patience.
Hermawih
http://www.bocsoft.net
Hermawih
"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
.
>|||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
.
>
Remote Server issue...
Did you ever figure this out ? I have the same problem.
I think you have to delete all subscribers and then delete the remote
server. Then create a linked server and then add back the subscribers.
Becuase, the sp_serveroption for data access will not work with a
remote server
Brett wrote:
dannr09
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message110773.htmlIf you're using SQL Replication, we setup Remote Servers as opposed to
Linked Servers already. What functionality are you trying to acheive?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
I think you have to delete all subscribers and then delete the remote
server. Then create a linked server and then add back the subscribers.
Becuase, the sp_serveroption for data access will not work with a
remote server
Brett wrote:
quote:
> *I am attmepting to setup up a linked server from my
> production server (sql1) to my reporting server (sql2).
> I have replication from sql1 to sql2.
> I noticed that there is already a remote server setup on
> sql1 for sql2. It will not allow me to setup a linked
> server for sql2. Plus, I am unable to run a distributed
> query... I get the error message that the remote server
> is not configured from data access.
> How do I setup a linked server from sql1 to sql2 so that
> I have data access?
> Please advise..
> Thank you,
> Brett
> I am using SQL Server 2000 for my production and
> reporting servers. *
dannr09
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message110773.htmlIf you're using SQL Replication, we setup Remote Servers as opposed to
Linked Servers already. What functionality are you trying to acheive?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Remote server delete
Hi,
Can any please shed some light on the following problem or direct me to an
information source ?
DELETE remoteserver.database.schema.table
returns the following error message.
iServer: Msg 7345, Level 16, State 1, Line 2
OLE DB provider 'MSDASQL' could not delete from table '"S1031118"."CISDTA6".
"DXDV36001"'. There was a recoverable, provider-specific error, such as an
RPC failure.
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 106 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
[OLE/DB provider returned message: Multiple-step operation generated errors.
Check each status value.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::DeleteRows
returned 0x80040e21: DBROWSTATUS_E_FAIL].
Any help would really be appreciated.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200511/1What kind of Linked server is this ? (product etc.)
Jens Suessmeyer.|||Sorry about the delay.
The linked server is configured as server type: other data source
provider name:
Microsoft OLE DB provider for ODBC drivers
Jens wrote:
>What kind of Linked server is this ? (product etc.)
>Jens Suessmeyer.
Message posted via http://www.webservertalk.com
Can any please shed some light on the following problem or direct me to an
information source ?
DELETE remoteserver.database.schema.table
returns the following error message.
iServer: Msg 7345, Level 16, State 1, Line 2
OLE DB provider 'MSDASQL' could not delete from table '"S1031118"."CISDTA6".
"DXDV36001"'. There was a recoverable, provider-specific error, such as an
RPC failure.
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 106 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
[OLE/DB provider returned message: Multiple-step operation generated errors.
Check each status value.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::DeleteRows
returned 0x80040e21: DBROWSTATUS_E_FAIL].
Any help would really be appreciated.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200511/1What kind of Linked server is this ? (product etc.)
Jens Suessmeyer.|||Sorry about the delay.
The linked server is configured as server type: other data source
provider name:
Microsoft OLE DB provider for ODBC drivers
Jens wrote:
>What kind of Linked server is this ? (product etc.)
>Jens Suessmeyer.
Message posted via http://www.webservertalk.com
Subscribe to:
Posts (Atom)