HOW TO CONNECT SQL OVER INTERNET

Jun 17, 2008

Please help me connect sql server over internet. I tested the connection in Windows XP, SQL Sever 2000, Router (forwarding IP port 1433) and its is working properly.
But using the same process in Windows 2000 Advance Server, Microsoft SQL Server 2000, Router (forwarding IP port 1433) Im getting the error "Unable to connect to server" . Can any one help me to setup this network. Thank you in advance!

View 11 Replies


ADVERTISEMENT

Connect To Database That Is Onto The Internet.

May 3, 2008

I have 2 instances of SQL-Server 2000  running on my computer.
I connected to them through SQLServer enterprice Manager.
Now I want to connect to a  Database that is stored on my WebHosting-Site [on INTERNET]   
The Server-IP address is 65.22.42.57.etc..........
WHILE I can connect to That Database from Visual-Studio     server-Explorer..........I cannot connect to that server from SQLServer-EnterpriceManager.
It says 'You need to use SQLServer 2005 tool'.
But there is no Connect-word to create a connection in 'SQLServer 2005'-Manager.'
 
 
HELP I need to connect , what shall I do ?
 
 
EXPERTS.
 

View 2 Replies View Related

How To Connect To Other M$ SQL Server Over Internet??(Help Me)

Oct 27, 2005

My English is not good.

I want to connect to other computer that installed M$ SQL Server2K over INTERNET. could you help me, plz.

I have used DNS (DOMAIN NAME SYSTEM) to forward to my computer( that connect to INTERNET) and my friend computer is the same. (because we have not static IP).

Thanks

:D

View 7 Replies View Related

Connect To Sql Server Through Internet

Mar 6, 2005

Hi,

Can someone please tell me how to do that?
I tried to connect to a sql server through internet by using sql query analyzer but it failed.

I searched for information in the internet but came to no avail.

Can someone please shed some light?

Thanks!

View 2 Replies View Related

Connect To SQL Server Via Internet

Sep 6, 2006

Hi there

We have the following problem. Our DB (MSDE 2000) is situated on remote server on which we

have
administrator privilege. The application which works on Local net connect to every machine in

the
net and see the database on one of the mashine as well.

The connection string is
data source=192.168.0.1XXXX;initial catalog=XXXX;integrated security=SSPI;persist security

info=True;workstation id=XXXX;packet size=4096"

but when we change IP in the connection string to our remote server(in internet with static IP) one we get

an exception says that
SQL server does not exist or access denied.
We opened ports on firewall but problem is still here. Then swithched off the firewall at all

but
same exception comes.
Thanks for answers

View 12 Replies View Related

Connect To The Internet Using Activesync 4.5

Apr 20, 2007

hallo could anyone tell me how do i connect to the internet through activesync ? thx

View 1 Replies View Related

Sql Server Does Not Exist When I Connect To Internet

Mar 18, 2004

Hi,

I am making a web application and it works fine. It uses Sql Server 2000 as the database. But when I connect to the Internet and compile or run my application it gives me this message :

" SQL SERVER DOES NOT EXIST OR ACCESS DENIED"

it works finewhen iam not connected to the internet

View 4 Replies View Related

Connect To Sql Server 2000 Via Internet

Jul 25, 2005

I'm Building a windows application which updates an internet site's database.Is it possible to connect directly to the sql server through the internet?If so is it the most efficient way ? perhaps a web service or streaming is a better solution?Thanks.

View 1 Replies View Related

DTS FTP Task Unable To Connect To Internet

Jul 9, 2004

I created a DTS FTP task to connect to an FTP site. The problem I'm having is the folder I want to access you cannot see under the Files Tab. So if I put the ftp site/subdirectory in the FTP Site box, I get the error "Unable to connect to internet! Please check the source site information, your username and password"

If I go to the FTP site/subdirectory in IE all the files show up fine. I believe this is limitation of DTS, but I would like to hear from you all first.

To see what error I'm talking about:
Create a DTS FTP task
Use: ftp.microsoft.com/bussys/ with no username or password
Click the Files Tab

Normally you can just put the server name in, and see all the folders/files, but the way my FTP site is set up I cannot see the folder I want, I can only access it.

View 1 Replies View Related

Connect Throught Internet Between 2 Server.

Feb 27, 2004

Hi all,
I 'm in VietNam, i want to use SQL server 2000 to connect to SQL server in China throught the internet. I did it in many way but it did not work, please show me.
Best regards

View 2 Replies View Related

Connect To Sql Server Desktop Engine Over Internet

Apr 11, 2004

i have got to connect to sql server desktop engine over internet with the following connection string

conString = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=" & dbName & ";Network Address=" & IPAddress & ";Data Source=" & DataSource & " ;User ID=" & UserId & " ; Password=" & Password

Plz also inform me about the restriction imposed in connectivity by any of the window operating system such as that win 98 wont work or work!

There is no firewall involved. The two computers are in the same room and connected directly to the internet.

Even the ping is not going to either computer.

So what could be the possible problem and the solution.

need urgent

View 1 Replies View Related

Connect To Sql Server 2005 Standard Thru Internet

Jul 12, 2007

Hi!I am trying to connect to my SqlServer 2005 thru internet, but it is notworking. I have a dyndns updater on my server which tells me an ip addressof the router. The router is configured to forward TCP port 1433 to LAN IPaddress of the computer on which is SQL Server installation.What is the connection string to connect to my server.I tried xxx.dyndns.org:1433, but it doesn't work. There is a defaultinstance installed on that machine.Please help.Zvonko

View 6 Replies View Related

Can't Connect To Multiple SQL Instances Over The Internet With SQL Browser Service

Nov 2, 2006

I recently setup mutliple instances of SQL Server Express at my office. I have 1 default instance, and two named instances. I can connect to the named instance of the default port of 1433 with Microsoft SQL Management Studio Express, however the other instances on dynamic TCP ports can not be accessed by the instance name over the internet. I have to specify the dynamic TCP port in this form: xxx.uconn.edu/SQLTEST, Port number. My current thinking is that the SQL Browser service should tell Management Studio Express what dynamic port number each SQL instance is listening to. Any ideas?

View 1 Replies View Related

Connect To SQL Server 2000 Trough Internet (adsl Connection )

Mar 29, 2007

Hi guys,



Can somebody tell me where i can find ( or explain me ) the steps to

connect to sql server using the internet. I am using VB6 (SP6) and SQL SERVER 2000

I want to set up asql server on a central location ( PC ) so that 4 different sites can access the data stored





Thanks for all help







grtz Robert

View 1 Replies View Related

Reporting Services :: Connect To Report Server From Client Through Internet Browser

Jun 11, 2015

after installing SQL Server 2008 R2 and the Reporting Services, I've managed to access the Report Manager URL....Reports through the web browser on the machine itself. But if i am trying to connect to on my client browser it does not find the Report Server.Do I need to configure the server in any way? Do I need to configure the firewall?

View 2 Replies View Related

Ssis Package Can't Connect To Pop Server Over The Internet From Sql Server Agent

Dec 20, 2007

Sql server agent is running under a domain account that is a member of administrators and domain users amongst others, and the package is executed as the service account. Connecting to servers on the same domain works and when I run it from the msdb package store in ssis (ssis runs under the network service account ...) it will connect to the pop server as well. Permissions, fiddly proxies .. the answer's out there somewhere

View 3 Replies View Related

How Do I Connect From One Sqlserver7 To Other Sqlserver7 Through Internet

Jul 20, 2005

hi myself avii am developing one appilication in which i am using vb as front end andsql server 7.0 as backend. i all ready complete the full application andit installed it on my clients computer. but some times i need my clientsdata which is on his computer,so any one can help me to find out how do i connect to my clients sqlserver through internet i. e. how do i configure or use server networkutility / Client network utility. i need it very badly.plz help methose who r giving me their valuable help plz mentioned their email id sothat i can contact further

View 1 Replies View Related

SQL 2000 Over The Internet

Jul 5, 2001

I am trying to connect to SQL Server 2000 using the enterprise manager, and I want to do it over the Internet. My server is in another country and I am using SQL authentication. When I try to make the connection I get a message of server does not exists or access denied. If I ping the server the ping is successful, I am using TCP/IP as protocol for the client, I am not behind any firewall, and the port 1433 is enabled and is the default. I imagine it has to be something with permissions but since I am using SQL validation it should work. Is there something else I have to change?

View 2 Replies View Related

SQL Connection Over The Internet

Jul 11, 2001

Hello,

I am trying to upload a database (MS SQL 7) from my machine to a remote location (host company). This company has MS SQL Server 7 running in its machine, so they told me that all I had to do was to connect from my SQL Enterprise Manager. I am new to MS SQL, so I would appreciate if someone can help me to create a connection from Enterprise Manager to this remote SQL Server.

Thanx

View 1 Replies View Related

Access SQL Through Internet

Jul 16, 2001

I need to access my SQL server from another domain across the internet. How can I do this? Everything I have tried has been unsuccessful.


Chris Walcott

View 2 Replies View Related

Administration Of SQL 7 Over The Internet

Jan 21, 2000

Hi
Could someone help me out with administration of SQL Server over the internet.
What do I need to change on my SQL Server and what will I need to configure on my clients using SQL analyzer connecting over the internet

Vijay

View 1 Replies View Related

SQL Server And Internet

Mar 13, 2000

Hi,
I am developing a VB app that will be accessed over the net. What do i need to do so that my users will be able to connect to the SQL server without being denied the permission.
a hind regarding the network library settings will be most appreciated.
Thanks in advance.
Deepak.

View 2 Replies View Related

Sql Data On The Internet

Feb 9, 2000

I would like to know how I can make data from sql 6.5 availeble for viewing on the internet. I think that I have to use ASP but how to implement this and what the steps are to follow is a big mystery for me, so if someone can the me more about this....

View 3 Replies View Related

Sql Admin Via The Internet

Mar 29, 1999

Hello,

I will soon be managing a sqlserver/iis4.0/nt box located remotely in another state. It has a permanen connection to the net. I have a dialup connection.

I have a remote control package, but it is slow. Is there a way to add that boxes sql server to my enterprise manager on my local nt server so that I can
adminsiter it from my machine? I am not over familair with sql server, but quickly learning!

Will I need to set up a vpn to do that?
I searched microsoft knowledge base, but could not find anything.
Thanks for your support.
Johanna

View 2 Replies View Related

Replication On The Internet Through FTP

Aug 6, 2001

Hi,
I am trying to replicate using Win 2000 and Sql 2000 on the Internet(FTP) using merge replication
The seqence of Activities are
..Intializing
..Connecting to publisher 'PUBSERVER'
..Retrieving publication Information
..Retrieving Subscribtion Information
..The subscription has been marked for reintialization.Reinitialization will occur the next time you synchroize this subscription
..The schema script 'Pubserver.. .. emp_1.sch' could not be propagated to the subscriber.
..The schema script 'Pubserver.. .. emp_1.sch' could not be propagated to the subscriber.
..The process could not read the file 'Pubserver....emp1.sch due to OS error 53
Can you help me out with this
(Please not I was able to replicate on the LAN with the same setup)

Regards
Anil

View 2 Replies View Related

Connection Thru Internet

Dec 9, 2004

Hello again pals, i meet you again to ask an old question i had, but no found answer.

Can i connect to a remote SQL Server thru Internet, lets say from a client like Query Analyzer?

I read to make it using a VPN, but i try to configure it and cant get connected.

I'm using a Win2000 Server or Win2003 Server,

Thanksfull!!!!

There is many people asking for that, i start to think it cant be done! :'(

View 6 Replies View Related

Who Can Help Me With Conection Over Internet?

Jan 11, 2006

Hi,
Now I really need you help. I have an application that needs to conect to a server
over the internet and I have change the MSQL port to 2015 cos the server even with a
firewall it has been attempt to be hacked. So I needed to change the port but my application
cannot conect to the server if I change it. If I left in the firewall 1433 and SQL it works fine
but once I change it to 2015 it doesnīt work.


Iīm using ADO conection as folow:

Variables string parameters:
01=password
02=user
03=database
04=server IP adress

"Provider=SQLOLEDB.1;Password='+01+';Persist Security Info=True;User ID='+02+';Initial Catalog='+03+';Data Source='+04;"

Using this conection string I can conect to the server using 1433 port but if I change the port I get the folow message:

"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

Iīd try to add the new port number to IP adress but it doesnīt work as (200.121.65.140:2015) and it return the folow message:

[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.

What I need to know or to do? Please somebody help me cos I donīt know more what to do and my superiors need awnsers.
Thanks for attetion.

Leonardo Almeida.

View 3 Replies View Related

Connecting To Sql Over Internet

Sep 23, 2006

hello,
we are learning sql2000 at school. i have been put in charge of trying to make it possible for the students to connect to the sql database from home.At the college they connect via a lan. Can anyone give me a way to do this, or is there a way. There are 30 students who will need to connect not all at the same time. Besides buying something like pcanywhere is it possible and how. I would really appreciate it. thanks again, tom

View 2 Replies View Related

SQL Query Over The Internet?

Jan 22, 2007

it is my first time using SQL remotely, i am used to client/server ..

i need to run query and execute procedure remotely.

i have SQL server 2000 installed on one machine connected to the internet with static IP adress, the second machine does not have SQL server but also connected on the internet but different cities.. so how that can be possible?

i am using VB6 to and ODBC, i need to know the full code to execute procedure or run query and what i have to do on the first machine to let it work and give me access over the internet?





View 1 Replies View Related

Authentication Across Internet

Jan 3, 2007

From what I have understood, Reporting Services could be configured to use Basic Authentication. In this way, a user can access a RS-server across the internet and he/she will be prompted for a valid username/password when trying to access.

However, from what I can understand this username and password will be sent uncrypted over the Internet (from the client machine to the RS-server), right?

My problem is, I need to give access to users acress the internet to a RS-server. The users uses all kind of operating systems (Windows, Linux, MacOS tec). And the communication needs to be encrypted.

How would you recommend me to implement security for this solution? I guess some kind of "Forms authentication" will have to be used? But how to make sure the data traffic is encrypted? And where do you recommend me to store the username and passwords? In an Active Directory on the server side, or in a separate database on the server side?

regards Andreas

View 7 Replies View Related

Connecting Via The Internet

Jun 1, 2008

I have just started on SQl Server and C# and was wondering if the following is possible.

Using a Windows application, is it possible to connect to a database held on another computer via the Internet? I am not talking about a local network / domain whatever.

What I am really asking is can you use the IP address of a 'real' remote computer in the connection string or is it done some other way?

John

View 1 Replies View Related

Mirroring Over Internet

May 31, 2007

Can SQL Server do mirroring over Https protocol over internet?



View 3 Replies View Related

Help With RS2005 And Internet

May 5, 2008

Hi all,

I really need help with this issue.

I have a setup a reporting server that works perfectly when accessing it from the intranet. Now I need to give access to this report server over the intranet.

I'm stomped...

The network guys did create a secure access to my report server so I can access my server using :
https://<MySecureRS>/reports

The issue I'm facing is that once I authenticated my self using https://<MySecureRS>/reports
It shows the internal ip addres of my server in the browser.... http://<My internal IP Adress>/reports

How can I configure my server to stay on my secure address?

Thanks
Aiwa

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved