Connecting Directly To SQL Server Oer The Internet
May 14, 2008
Hi,
I'm currently writing a desktop application that communicates directly with a SQL server database on the local network. Ideally we'd like to connect directly to the database via the Internet.
- connecting via the Internet is important because we want easy access from anywhere.
- directly is important because fast data transfer is a requirement.
Not knowing much about the security implications of such a connection, I thought I'd ask here. So what are the major risks and objections? Can the connection and data be made secure?
I know it is possible to establish a connection to an SQL Server overthe Internet via Enterprise Manager. My question is, how secure is thisconnection? Is there a best practices document for this type ofconnection?Here is my scenario:We are looking to outsource our web hosting. Currently, we uploadclient sensitive data to our SQL Server databases within our internalnetwork. If we outsource, the SQL server will be on a differentnetwork. We are behind a firewall here and the dedicated hosted SQLServer will also be behind a firewall. Is the Enterprise Managerconnection succeptable to hackers? If so any reccomendations on how toaccomplish this would be appreciated.Another scenario is connecting to the SQL Server through a DSN. Canthis be accomplished from inside our network to outsourced server? Howsecure would that connection be?Thanks in Advance.
I have set up an MSDE SQL Server in my Win XP Pro PC and am able to connect to it on the host PC, and over my LAN. However, when I try to connect to it over the Internet my connection is refused with the following message:SQL server does not exist or access denied. ConnectionOpen (Connect())Some background:I have router/NAT firewall and have opened port 1433 (I have even tried a DMZ to the SQL Server machine). The Router is definitely going to the SQL Server PC! I am fairly certain that the connection string is correct.Any help would be most gratefully received.
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
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?
***PROBLEM*** Slow connectivity while connecting SQL server through internet (TCP port) using vb6 program - Connecting a Database via VB 6 program : Very Slow speed - Data Entry : medium speed - Report generation : slow speed
***SERVER CONFIG*** - Intel Core 2 Duo, 2 GB RAM, Windows 2003 Standard with SP 2 - Sql server 2000 with SP4 - 2 Ethernet card. 1 connected to Broadband another with local network - Database size 2.5 GB - Internet: Broadband 1Mbps (upto 8 Mbps)
***CLIENT CONFIG*** -Intel P4, 256 MB RAM, win XP SP2 - Internet: 256 Kbps (upto 2 Mbps) - There may 2 to 3 client connect simultaneously via internet and about 20 clients connect through local net work
* Web sites opening fast, downloading of other files are also fast, why SQL connectivity is slow???
I am having same problem. I am trying to connect my vb6 application with SQL Server 2000. My database is on database server machine which has ID ADMIN and SQL Server is using default instance. Database instance name is DBPIMS. When I try to connect this database within any machine of LAN, it is working fine. But If I want to connect from my home or some other place through internet, it is not cannecting database to database.. I've 2wire router installed at my office. & I've done port forwarding for port 1433. Also I've one static IP which I am using for connection. My connection string is
But it couldn't get connected to database. Please can anybody help me. I am in urgent need to solve this as its been since long I am trying find its solution.
I'm currently dumping tables from PostgreSQL 7 to SQL Server 2K and I've been wondering if it's possible to create a trigger between the two databases. ..like if there's an insert to a PostgreSQL table, the trigger inserts the same row to the SQL Server table.
If it is possible, please do send me a sample code.
1. Can we directly install sp2 without SP1 - for sql server 2005.
2 . Iam basically dotnet developer. iam using sql server 2005 both developer and express editions. Do i need to stop sql server service before installing sp2. ?
During sp1 installation, it seems some file are locked and when it prompt, i stopped service and continued installation.
3. Moreover Sql server 2005 express edition comes along with VS2005 didn't have management studio. I feel like having entire features installed in my system. I have downloaded express edition SQLEXPR_ADV.exe. Which is better choice for installation.
our goal is to install SQL Server 2005 Express Edition SP1. So far we used to install SQL Server 2005 Express Edition which resulted in the Version 9.00.1399 (basic run time machine).
We noticed that SP1 is almost the same sice as the basic run time machine. Still, we then we applied SP1. during the installation, at the window "Existing Components", the "SQL Server Database Services 9.00.1399.06 is listed with a check box. When I tick the box, the installation can continue. SP1 resulted in the version 9.00.2047. (checked on sqlservr.exe).
my question: can we install directly SQL Server 2005 Express Edition SP1 without any previous SQL Server installation at all to save installation time (and errors)?
I do now that the service packs are considered "cumulative", so SP2 includes SP1, but I do not know of SP1 includes the basice runtime machine.
I was wondering if it was possible to call reporting server web service directly from my sql server stored procedure. The call that I need to make to reporting web service needs to generate the report in a PDF format.
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 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'm reasonably new to MS SQL server, I've mostly been setting up databases and creating ASP Pages to look at them with.
However recently I've been given a fun job and I can't seem to find a way to do it.
The problem is we have 2 servers located on different sites, one is actually doing stuff the other just monitors some equipment and when status chages on the equipment a report is made to a table. The software doing this is bespoke and it would cost a fortune to have changed, what we want to do is have the monitoring server send a copy of the inserted row as they get inserted.
I've tried linking the servers via ODBC (in the linked servers part) but when a trigger i've put on the insert table fires it throws up an error about ANSI NULLS and WARNINGS and nothing happens.
After a look round on the internet I've found reference to using the 'set ANSI_NULLS' on command but this seems to be for stored procedures, even then when i try to execute the stored procedure as they show it still comes back with this error.
Can anyone suggest any other ways of copying the inserted row across?
Both servers are MS SQL but are not on a LAN so I have to refere to them as IP addresses.
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
I have an Access 2003 application that works well in a LAN environment with a Jet based back end. However, I would like to move this back end to a SQL Server database hosted on a website so that my users could run the application from any Internet-connected PC, using a modified version of my Access front end.
Is this a perfectly normal way of using SQL Server? Is response time likely to be an issue or can careful design make performance similar to that with a LAN based back end?
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
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
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.
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
Hi,Just installed Norton Internet Security on an XP workstation that also hasSQL Server on it.I now find that I cannot access SQL Server and multiple messages are beingissued by NIS.When I switch off the Firewall & Intrusion Detection I can access SQLServer.Does anyone know how to configure NIS so that I can use it alongside SQLServer?Thanks,Mike.
Sorry for posting this here, I couldn't find an accurate forum name to post this in.
We are using Windows SBS Server 2003 with SQL Server installed. We have a static IP. I am wondering if we can host our database. I am specifically interested in having outside websites access our database. Is there anything special I need to do to make this happen? I am pretty clueless about this.
We're trying to determine the best way to implement an authentication mechanism for our reporting services solution. Basically, we are exposing a web application to the internet, and allowing a forms authenticated user to access our report server somewhere within our intranet to view reports. I've browsed msdn and found that there are two approaches:
1. create a custom authentication extension for reporting services 2. create a restricted domain user that is allowed to access the report server
Going with approach 2 and assuming I'm using a ReportViewer control, in order to authenticate with the report server (using the one domain user created specifically for report server access), are we supposed to just provide an instance of an object implementing IReportServerCredential containing the domain user information to the Credentials property of the ReportViewer.ServerReport before accessing the report? Is this the correct way to implement approach 2? Also, if implementing approach 2 is so simple compared to approach 1, why would anyone choose to implement custom authentication extension if they don't need fine-grain access control on the report server level?
Couple of questions for the SQL Server Guru's out there.
SQLServer 2005 Web Hosting Provider
Ok I am developing a Web application in ASP.NET with AJAX, etc. etc. It will be some time before it is ready to roll out. As a mockup I created the same application in Microsoft Access and Visual Basic (VS 2008), which I can link the tables to the hosting provider on the internet. Works very well and speed is very acceptable. The want to start utilizing it with the mockup distributed app that I created.
My question is, is how secure is the data that is moving from the local application to SQLServer 2005 with the web hosting provider ? Is there anything that I can do to increase security ?
How can I access my Microsoft SQL Server 2005 through internet?
For example, I set up a Microsoft SQL Server in one of computers of my company, and every computer in my company has its own IP .They are in the same workgroup. Now, there is no problem with database access with another computer in my company.
Can anyone tell my how to access it through a computer out of my company?
I cannot seem to find the definitive how-to guide for this. Can anyone point me in the right direction?
I have SQL Server 2005 (x64) already running on Windows 2003 R2 (x64). I'm having difficulty trying to expose it the Internet.
Using the Surface Area Configuration tool I can see that remote connections using TCP/IP is enabled. I also made the machine administrator a member of the SysAdmin role from here too.
In Windows Firewall "SQL Server" and "Web" are already checked as exceptions.
I know that SQL Server uses port 1433 and I also read somewhere that clients connecting to SQL Server communicate on a random port between 1024 and 5000. So, on my router (Netgear WNR854T) I'm forwarding ports 1024 through 5000 to the machine where SQL Server lives.
In my connection string I'm using the IP address of the SQL Server machine with ":1433" appended to the address. Yet I cannot connect to SQL Server. Am I missing anything?
