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
Good day.I have dts running every 10 minutes in a server of slqserver 2000 who is in a country and that it sends data to another country which has a data base sybase12.5.The problem is when by reasons for the WAN the connection fails from a country to another one the dts or job fails executing its processes and I must soon give click to stop and start so that it continues. That I can do so that when the connection is lost and i need to dts reconected automatically and is continued its processing? thanks and sorry my english :)
I am trying to connect some users to the server using ODBC. But when I do that I get an error that the user is not asociated as a concexcion of confidence of SQL Server. From my PC it works fine as I am the administrator.
I am very new to all thisI have a access databse wich uses a ODBC conection to mysql server. Ican open the and run the database find but if i leave the dadabaseloaded but do not use it when i go back to it is has lost theconection and i need to close the databse and reopen itIf there a way to make sure i alwasy have a coenctionThanks
When trying to connect to my SQL Server I'm getting the following error:
******************************************
A connection could not be established to (local).
Reason: Logon failed for user.
Please vertify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.
******************************************
SQL Server is definately running, but I'm unable to connect.
I've tried changing the ODBC settings but I can't get past the "MIcrosoft SQL Server DNS Configuration" window. I choose "With Windows NT authentication using the network lognin ID" and click "Conect to SQL Server to obtain default setting for the additional congiruation options" and click "Next" but I get stopped by the following error:
connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user machine1Administrator'
Does anyone have any ideas on what I need to do to fix this? If it helps, this all seems to have started occuring since I changed the Administrator password
I need solve this problem. I have this software running at 2 locations (1 and 2)
- the 1) got a app server and the data base, in the same computer; - the 2) got a app server, acessing the data base of the 1) - the conection between the two is all right, like a local network, by air. - at 1) it runs all right, but the 2), when have to acess the data base (at 1), the conection becames too
slowwwwwwww.... impossible to work
Somebody acess data base via internet, or acess a data base that stay phisically away from the app server ?? Could it be a data trasmisson protocol problem ???
sorry the language errors ... thats the best i can :) hehe
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?
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.
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
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....
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)
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?
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?
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?
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?
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.
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.'
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?
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?
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).
I am so confused and I am getting no help from the Microsoft, two months and only stammering from their representatives. I need to set up a Sql Server database that will allow internet access. This is not an e-commerce situation. At most there will be 10 known users of this system accessing statistical data. I had priced this system to use Backoffice, but as I now read this is not legal for internet use. It also appears that a processor license is required for internet access (not entirely clear on this). Access and MSDE also don't appear to be legal for internet access. The customer is on a shoe string budget. If I use stand-alone components the budget only covers an one processor SQL Server 2000 license. I don't like the idea of setting up a database system with only one processor. Is there another Sql Server based option I am not aware of? Its looking like a linux/mysql option - Yikes!
I need to develop an application in vb.net that uses sql server database so that user can access the use the application over the inter net. How Can I accomplish that ? What are the options ?
I have SQL Server running on my internal LAN. I want to have a second SQL Server running on a hosted (shared) website. I then would like these servers to talk to each other. At some scheduled time I need to publish data to the web, and I then need to subscribe to data input on the web by various clients. My internal LAN can see the Internet via our cable modem.
What is the best way to do this? What software will I need to run. I'm looking for the big picture.