|
|
You're in the
sql server connect
group:Remote Server using Enterprise Manager
sql server connect:
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 ?? --
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 [quoted text, click to view] "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. > >
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 [quoted text, click to view] "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,
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.aspx?scid=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 [quoted text, click to view] "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.aspx?scid=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 [quoted text, click to view] "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 [quoted text, click to view] "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/details.aspx?FamilyID=c039a798-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.
Thanks Wei Lu,
After all the trouble we have been through, are we discussing the wrong tool ? I am so sorry that I have not said the problem clearly enough from the beginning. I should make a correction. We can not create an instance of SQL Server from another local network using TCP/IP. I thought it was. We can do it using Named pipes but not TCP/IP. What we do here : using SQL sever utility , we disabled Named Pipes from both computer and tried to connect - and failed. Onother thing, If I may ask you here, what is tool from Microsoft to read log created by IIS ?? What I have now is log parser. Okkay I will try to download SQL web tool Thank you -- Hermawih http://www.bocsoft.net [quoted text, click to view] "Wei Lu" wrote:
> 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/details.aspx?FamilyID=c039a798-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. >
Hi Hermawih,
Thanks for the update. When i state EM, i mean Enterprise Manager. Sorry for any misunderstanding. When you create an instance of SQL Server from another local network using TCP/IP, what's the error message? Further, Log Parser is the tool from Microsoft to read the IIS log. The latest version is 2.2 You can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25- 91b2-f8d975cf8c07&DisplayLang=en 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.
Thank you Wei Lu,
--------------------------------- Using TCP/IP Error Message: the same problem ... SQL Server registration failed because of the connection failure displayed below. Do you wish to Register anyway? SQL Server does not exist or access denied. ConnectionOpen(Connect()) ------------------------------------------------------------------ For the time being, we gave up using Enterprise Manager with TCP/IP Connection, we are focusing to learn how to use the SQL web Data Administration. It is written in C#- I can't understand it; so I downloaded another SQL web tool written in VB. Unfortunately, they have so little documentation. I am just guessing that this web tool should be placed in the internet site. I can do it for local SQL database, but I have not tried for SQL database located in my internet site. Thank you for the link for log parser 2.2 - we have the older one. -- Hermawih http://www.bocsoft.net [quoted text, click to view] "Wei Lu" wrote:
> Hi Hermawih, > > Thanks for the update. > > When i state EM, i mean Enterprise Manager. Sorry for any misunderstanding. > > When you create an instance of SQL Server from another local network using > TCP/IP, what's the error message? > > Further, Log Parser is the tool from Microsoft to read the IIS log. > The latest version is 2.2 > You can download it here: > http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25- > 91b2-f8d975cf8c07&DisplayLang=en > > 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. >
Dear Wei Lu,
--------------------------- [quoted text, click to view] > When you create an instance of SQL Server from another local network using ---------------------------> TCP/IP, what's the error message? We did it. We can create the instance of SQL server from another local network using TCP/IP. We forgot to turn off the FIREWALL. But for the internet SQL Server , still failed !!! Thank you. -- Hermawih http://www.bocsoft.net [quoted text, click to view] "Wei Lu" wrote:
> Hi Hermawih, > > Thanks for the update. > > When i state EM, i mean Enterprise Manager. Sorry for any misunderstanding. > > When you create an instance of SQL Server from another local network using > TCP/IP, what's the error message? > > Further, Log Parser is the tool from Microsoft to read the IIS log. > The latest version is 2.2 > You can download it here: > http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25- > 91b2-f8d975cf8c07&DisplayLang=en > > 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. It's very stange that you can connect to the SQL database in your internet site with Named Pipe but not TCP/IP. It seems that maybe your web hosting block some port. If you have any questions or concerns, please feel free to let me know. 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 Wei Lu.
Thanks for the reply. [quoted text, click to view] > It's very stange that you can connect to the SQL database in your internet ----------------------------------------------> site with Named Pipe but not TCP/IP. It seems that maybe your web hosting > block some port. No, I still can not connect to the SQL database in my internet site neither using named pipe nor TCP/IP . I can now connect using both method in my local network. When I failed to connect using TCP/IP method for my local network, I forgot to turned off the FIREWALL. But now all are okkay. For my Internet site, we gave up using EM temporarily. We are now focusing our energy on using SQL web tool , you gave us. For local, we can do it easily using SQL web tool but we are trying to figure it out how to do it for : - my network site - and latter for my internet site. we are still having problem even for SQL server in my local network site. It seems that all of our problem relates to security problem. It kept asking us password to get into our local intranet but we do not know what is the password since we never put any password on our local computer. Hopefully we can figure it out . Thank you Wei Lu. -- Hermawih http://www.bocsoft.net [quoted text, click to view] "Wei Lu" wrote:
> Hi Hermawih, > > Thanks for the update. > > It's very stange that you can connect to the SQL database in your internet > site with Named Pipe but not TCP/IP. It seems that maybe your web hosting > block some port. > > If you have any questions or concerns, please feel free to let me know. > > 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,
Thank you for the update. In most situation, the Web Hosting will block you to connect to the SQL Server directly for the security issue. I think the SQL web tool is the best choice for you to manage the data. If you have any questions or concerns, please feel free to let me know. 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 Wei Lu,
Thanks. -------------------- In most situation, the Web Hosting will block you to connect to the SQL Server directly for the security issue. I think the SQL web tool is the best choice for you to manage the data. ------------------ I think so too. That is why we are now focusing our attention how to use the SQL web tool. We are now able to use SQL web tool for network SQL server but we are still trying to figure it out how do it for our internet site. Hopefully we can solve it in short time. Thanks. -- Hermawih http://www.bocsoft.net [quoted text, click to view] "Wei Lu" wrote:
> Hi Hermawih, > > Thank you for the update. > > In most situation, the Web Hosting will block you to connect to the SQL > Server directly for the security issue. I think the SQL web tool is the > best choice for you to manage the data. > > If you have any questions or concerns, please feel free to let me know. > > 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,
If you have any questions or concerns, please feel free to let us know. Have a great day! 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. ===================================================== Business-Critical Phone Support (BCPS) provides you with technical phone support at no charge during critical LAN outages or "business down" situations. This benefit is available 24 hours a day, 7 days a week to all Microsoft technology partners in the United States and Canada. This and other support options are available here: BCPS: https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/ If you are outside the United States, please visit our International Support page: http://support.microsoft.com/common/international.aspx ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |