Connecting To SQL Server OVer Internet
Jul 23, 2005
I know it is possible to establish a connection to an SQL Server over
the Internet via Enterprise Manager. My question is, how secure is this
connection? Is there a best practices document for this type of
connection?
Here is my scenario:
We are looking to outsource our web hosting. Currently, we upload
client sensitive data to our SQL Server databases within our internal
network. If we outsource, the SQL server will be on a different
network. We are behind a firewall here and the dedicated hosted SQL
Server will also be behind a firewall. Is the Enterprise Manager
connection succeptable to hackers? If so any reccomendations on how to
accomplish this would be appreciated.
Another scenario is connecting to the SQL Server through a DSN. Can
this be accomplished from inside our network to outsourced server? How
secure would that connection be?
Thanks in Advance.
View 5 Replies
ADVERTISEMENT
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?
Cheers, Gavin
View 2 Replies
View Related
Jun 9, 2005
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.
View 7 Replies
View Related
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
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
Apr 3, 2008
***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???
View 4 Replies
View Related
Sep 27, 2007
Hi Everybody
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
"Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User ID=xxx;Initial Catalog=<atabase instance name;Data Source=" & static IP addres
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.
Thanks in advance
View 1 Replies
View Related
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
Oct 18, 2000
i want to connect to remote sql server through ip address
iam using winnt server 4.0 and sql 7.0
View 1 Replies
View Related
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
Apr 9, 2001
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!
View 1 Replies
View Related
Dec 24, 2004
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 ?
Pls Help..
View 1 Replies
View Related
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
Feb 2, 2004
Hi,
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.
Cheers,
Iain
View 1 Replies
View Related
May 1, 2004
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..
View 5 Replies
View Related
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
May 17, 2008
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?
View 18 Replies
View Related
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
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
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
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
Jul 20, 2005
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.
View 1 Replies
View Related
Feb 1, 2007
Hello,
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.
Thanks!
View 3 Replies
View Related
Mar 6, 2007
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?
Thanks for any help and suggestions!
View 11 Replies
View Related
Feb 2, 2008
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 ?
Thanks, any thoughts ?
Appreciate any suggestions or comments.
View 1 Replies
View Related
Feb 18, 2007
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?
Thanks
View 1 Replies
View Related
Jun 6, 2007
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?
View 9 Replies
View Related
Nov 7, 2007
Hi,
Here is the situation:
My SQL server is in B'lore. I need to transfer the Database from the B'lore server to a new Server in California.
Kindly let me know how it could be done.
Thanks in advance.
View 2 Replies
View Related
Nov 24, 2006
Hi,
I am migrating from MySQL 5 to SQL Server Express 2005 (SP1) and I am having some remote connections issues. I have tried just about everything that I have read in the forums and in Microsoft's knowledge base about remote connections with SQL Server. I am using Visual FoxPro 9 as my client and connecting with ODBC to SQL Server. The strange thing about my issue is that I can connect just fine with localhost or using my LAN IP address. Before I get to the errors, here is what I have configured:
Remote connections are allowed, TCP is active, SQL Browser service is active and running, my router forwards requests on ports 4567 (my custom port that I setup IP1 in SQL Server Configuration Manager to listen on), 1433 and 1434 (TCP and UDP for all) to my local IP address. My firewall will not block ports 4567, 1433 or 1434 (TCP and UDP for all). I even tried turning my firewall off.
For example, the following connection strings work. The first works when I am at the same computer as my SQL Server, the second works from a different computer on the same LAN.
Driver=SQL Native Client;Server=localhostsqlexpress;Database=xyz;Uid=adm;Pwd=pw
Driver=SQL Native Client;Server=192.168.1.3sqlexpress;Database=xyz;Uid=adm;Pwd=pw
When I try the following connection strings (with either my hostname or internet IP address, I get one of several failures):
Driver=SQL Native Client;Server=my.domain.comsqlexpress;Database=xyz;Uid=adm;Pwd=pw
The above strings yields this error message: [Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]
Driver=SQL Native Client;Server=my.domain.comsqlexpress,1433;Database=xyz;Uid=adm;Pwd=pw
Driver=SQL Native Client;Server=my.domain.comsqlexpress,4567;Database=xyz;Uid=adm;Pwd=pw
Using either the SQL default port or a custom port yields this error message: [Microsoft][SQL Native Client]Login timeout expired Connectivity error: [Microsoft][SQL Native Client]TCP Provider: No connection could be made because the target machine actively refused it.
The fact that I can connect with my LAN and not on the internet suggests that my ISP may be blocking port 1433. For this reason I tried to change the port my SQL Server instance was listening on but I have a feeling it isn't working.
Any help would be greatly appreciated as I've been stuck on this problem. Is there any way to test if my SQL server instance is actually listening on my custom defined port? Thanks in advance.
-Tom
View 1 Replies
View Related
Jul 31, 2007
hi friends
DNS entry is a must in my PC to connect to internet but i canot connect to an MS SQL database server
installed on another machine on same lan. but if i remove DNS entry in my PC i could connect to MSSQLServer but i canot connect internet. i want to work on both simoultaniously.
some one please suggest what to do ..?
stephen
View 3 Replies
View Related
Jun 14, 2006
Hi,
I've 2 SQL Server 2000 EE (A & B). Both are connected to internet but not in the same LAN. How do I insert a row triggered from A to a table in B ?
If I've both SQL Server 2005 Express in the same setup above, is it possible to setup as above ?
Advice pls...TIA !
View 4 Replies
View Related
Jul 12, 2006
Hey all!I am hoping that somebody will be able to help me getting my database working over the Internet.I am using VS 2005 and SQL Server 2005 Express Edition and have my database set up within a web site project in VS under the App_Data folder.Everything runs smoothly when running the application on localhost I am just facing a problem when I attempt the same thing after uploading my pages to my web server.I am receiving the following error:An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified)I have tried enabling the disabled SQLEXPRESS protocols and disabled my firewall with no luck.I have also looked into using localhostsqlexpress as the server name but I dont see how this method would work as it appears to only run a database on the local machine which is the problem I have currently.Could anybody help me with this problem? I have only just started trying to use SQL Server Express as a means of database connectivity and I am not exactly sure how it all works.Thanks
View 1 Replies
View Related
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