When using the Rda Pull/Push methods I need to have an Internet connection. I'm using VS2005 with VB to build my application. What commands can I use to check for and force or establish an internet connection from my pda?
View 1 RepliesHello,
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
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! :'(
Hi all developers...
Please help me for connect to SQL server over internet.
What is the connection string in VB6 ?
And what is the different techniques do this ?
Thanks..
I want to set up merge replication over internet between sql servers located in different cities. Servers have adsl connection. Also I want to start replication witout synchronizing. Actually what I want is starting replication without snapshot because of connection issues. How could I achieve connecting approximately 40 server in this way?
View 6 Replies View RelatedIs it possible to connect to a sql server express over internet or not ?
- I am using a win2003 sp1 server. Freshly installed.
- The server is directly connected to internet.
- For the purpose of the test, I stopped the windows firewall and the IPSec service.
- I stopped SQL server Browser service.
- I find a free port (here : 1401)
- I activated TCP/IP protocol in SQL Server Configuration Manager, and I have selected 1401 as the TCP port in the IPAll sextion of TCP/IP protection (and I remove the '0' of the dynamic TCP Port).
- Restarted SQL server express...
In the sql server log, I get the message "Serveur Server is listening on [ 'any' <ipv4> 1401]"
But I never get an answer from the server.
sqlcmd -S ip_of_the_server, 1401 -U username -P password is working fine if launched on the server. But I always get a timeout error from any PC. Same with a telnet on port 1401.
Any idea ?
-
I create a WebSite onto the internet.
Then I created a database with MSSQLmanager provided by the WebHosting.
I created a Table and put some data in it.
When I try to access the DataBase an Error says: "Connection cannot be opened. On default settings you cannot access a Database Remotely."
What shall I do to configure my Database.
basically I don't know where to go to change configuration of my Database.
In my intranet I would use SQLServerSuraceArea.
But on Internet I do not know.
someone Help.
Did I miss something ?
Hi
Im having some problems setting up sql server so that i can connect to it in my vb program over the internet.
Im using windows xp pro and have IIS installed and using sql server 2005 express SP2.
My setup is as follows:
from phonecable to router, from router to wireless access point and the wireless connects to my computer.
I have tried disabling the xp firewall, and in the sql server configurationi have set the port to 11001, which i have also opened in my router.
There should be a connection to the computer, cause i have succesfully set up an FTP server on a different port.
I have also enabled remote connections, both via TCP/IP and named pipes.
I have tried to use telnet on my IP adress with the port 11001, and it says that i cant create a connection..Are there other settings i should set to get this to work? This has been bugging me for a little while...
I am working in a secured company which doesn't allow live internet connection, therefore I can't install SSDT using Web Platform Installer and we also don't want to install the intire 2012 client tools.
View 2 Replies View RelatedHi,You all may be knowing that Connection.isClosed() does not tells usif the underying DB connection is active or not; it only checks ifConnection.close() had been previously called or not.One sure shot way to find out this is by executing some dummy SELECTquery and catching it via SQLException.This could be done in various DB's as follows:SELECT * from 1 (MS SQL)SELECT * from DUAL(Oracle)My question is what if you use some other DB , which is not famous asthe above.This could still be achieved by creating dummy table with one columnand querying it. One pitfall of doing this approach is we may not havecreate permissions to create table. Even if we have permissions tocreate table, you need to do the following, if you need to check DBConnection every time.a) Create Tableb) Use SELECT queryc) Drop tableYou may ask me why we need to use drop table. This is because, we cannot create many tables and keep them alive if we were to check (DBConn) it for 100 times. One way is we can use IF NOT EXISTS along withCreate table. Unfortunately, this command is not supported by all DBvendors. So, this is ruled out.One more way of doing is writing simple stored procedure that returnsplain constant. Unfortunatley the syntax for Stored procedures isdifferent for different DB Vendors.So, do we have a correct way of finding if DB connection is active,that would work on all DB's ?Fortunately, there is a way to do this.We could use Connection.getMetaData().getTables(null,null,null, null).We could use this way as this would surely get the number of tablespresent at that moment. How many tables are present in a DB will notbe cached as this may change dynamically. One disadvantage of usingthis approach is performance. What if a DB has 1000 tables, it tries toget the names of 1000 tables and it is performance hit.Is there a solution for this?. Yes, we can use getTables method byinvoking only against the SYSTEM table types. I am sure any DB willnot have many system tables.So, our call would be,Conn.getMetaData().getTables(null,null,null,new String[]{"SYSTEMTABLE"});The above statement is expected to give whether connection is active;if connection is not active, then it throws SQLException. And best partis it will work on all DB Drivers.What if some JDBC driver does not implement the above getTables() call,then we would get some AbstractMethodError that can be caught usingLinkageError. So, finally code for checking if connection is active ornot is as follows:try {ResultSet rs = conn.getMetaData().getTables(null,null,null,newString[]{"SYSTEM TABLE"});} catch (SQLException e) {conn.close();// use try catch block here to catch SQLException forConn.close();//call to open new DB connection.getNewConnection();}catch(LinkageError e){conn.close();// use try catch block here to catch SQLException forConn.close();//call to open new DB connection.getNewConnection();}}This limitation (if it can be called) is going to be fixed for JDBC4.0 implemented drivers(if they implement it in right way).Any comments on this would be appreciated.Regards,Venkata Narayana
View 2 Replies View RelatedHi 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
I have a list of servers on a table, I take this list and pass to a for each loop container and that will grab some system information from each server that we give for our internal auditors.
The issue that I'm currently having with this package is that some times, 1 or 2 servers from the list are down and/or extremelly busy and it times out, either case causes the whole package to fail.
What I'm trying to do is, test the connection to the server prior passing the server name to the For Each Loop Container and log that information somewhere (Maybe a boolean field in a table), so then I check after the package finish and validate that the server was actually up or down.
Any ideas or suggestions?
Thanks,
Igor Santos
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 RelatedI 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
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
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.
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 RelatedHello,
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
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
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.
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
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!
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?
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
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
Can SQL Server do mirroring over Https protocol over internet?
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
I am tuning up a stalled ASP.NET2.0 community website.
The latter accesses MS SQL Server2005 (SS2005) database over internet.
The website and SS2005 are on different machines and even networks communicating over internet.
They are on shared public hosting that I access through Helm control panel.
The accounts are very restrictive to check most of configurations.
What are possible pitfalls, configurations, security configurations and dangers,
optimizations for accessing SS2005 over internet?
Hi.. need some help!
My problem is thus - I am looking for a
synchronization technique (between SQLCE and SQL Server 2000) for a PPC
which can not connect to the internet.
I am not sure at this stage if the device would even be equipped with a
network adapter.I
would be using RDA to sync with the database. The only problem is that I am unable to access IIS directly from the PDA.
I did some research and found out that SQL CE Relay
is one way to achieve what I am looking for but Darren let me know that
Relay is outdated and might not be supported anymore. I tried working
with relay but in vain.
I thought of using Pocket Access instead but Pocket Access
does not have the ability to handle the db I am using neither is it
being supported anymore.
I am fast running out of ideas:(
Could someone please suggest me alternatives or any available solution
to deal with the problem for a PPC with / without a network adapter.
Thanks in advance!
Abhi.
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.
Hi,
What is a secure way or accepted method to make database changes,IE: edit tables, add sprocs. ect. on a server being ran by an ASP.NET hosting service across the internet?
Thank you
-heywade
i want to connect to remote sql server through ip address
iam using winnt server 4.0 and sql 7.0
I have a Analysis Servises installed in a Windows 2000 server and I created
a cube on it. I created also an ASP page with Web Pivot Control to access
the cube, but when the users open my ASP page they canīt access the cube. Their machines
doenīt have Excell 2000 installed.
Is it necessary to heve the Pivot table Service installed in the user machine? Or I only have toinstall the Office Web Components ? Or both?
If
itīs true how can I install Pivot Table Service in the user machine? Is
there a specific setup program to install it or is the same setup program
used to install Analysis Services? How should I do this? Should I have a
link in the ASP page to run the setup program? Should I do a download?
Thanks,
Paulo Ortega