Access 2K --> SQL 2K Internet Connectivity
Jun 9, 2001
Is it possible to connect an Access Project (.adp) to SQL Server 2K via the Internet?
I've installed the Office 2K SR-1 and the Access/SQL 2K Compatibility update.
I can connect to SQL 2K from any computer that is on the same subnet, but not outside of that . . . or through the Internet.
Can this be done?
Pls. respond directly or forward a copy of your response to this thread to me at flanders@mbay.net, if possible.
Thanks.
Pat
View 1 Replies
ADVERTISEMENT
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
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
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
Oct 15, 2005
I was wondering if any body has used Internet as a WAN (Wide AreaNetwork) to provide database access. I know about web services but Ilike to experiment with using Internet as a extended network (webserver behind one router and database behind another). Any ideas onwhere to look for this?Thanks
View 3 Replies
View Related
Jul 20, 2005
Hi.I would like to access my database outside of my company. I read manydocuments but they are all pertaining to accessing the database viaASP or some form of web application. Is there no single windows orlinux application tht runs natively to access a remote SQL data base?Any advise is appreciated. Thanks!!
View 5 Replies
View Related
Jul 24, 2007
We are trying to restict internet access from certin computers but, it's still in place because we need to process credit cards. Is it possible to remove internet access and allow our SQL based program to still run credit cards because of the ODBC connection to the SQL server which has internet access?
View 4 Replies
View Related
May 22, 2004
I know that SQL Server cost plenty to license for internet use...per year. But is there the same costs for MSDE and/or Access? I was recently told that every internet user would have to have a license to use a site that had Access as the database. I'm really not sure how true that is or if its MS support fobbing me off. Anyone know?
View 4 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
Jul 22, 1998
Hi...
I am using MSACCESS form to connect to SQL SERVER database..Is that possible.
my tables are defined in SQL SERVER and through MS ACCESSS forms as a front End I am manipulating it...
How should I do that...Can any body help me in the same
Thanks in Advance
Rakesh
View 1 Replies
View Related
Feb 9, 2008
How can I store my database on the internet and then access it's data (from a Visual Basic Express Windows Application)?
Where on my server do I upload it to?
How do I keep it secure?
Can anyone reccomend any good articles, etc, please?
Thank you for your help.
Sam
View 3 Replies
View Related
Sep 19, 2007
hi,
i am new to sql server reporting 2005. i can able to create reports and i can able to access in web pages. But my problem is, my reports and database are in one server, and my web server is differnet. we cant view the reports from internet. How can we slove this. any one can help?
Thanks in advance.
sns
View 2 Replies
View Related
Jun 18, 2007
Could someone point me to an article that shows how to configure SQLServer express so I can connect to it over the lan and Internet?
Thanks
View 1 Replies
View Related
Feb 29, 2008
I have report server setup on the same machine where the sql server 2005 db is setup, as well as iis running the website. i simply need to get report server running to allow internet access. I have report server setup so that it is running locally (localhost), however, as soon as I change the iis site settings to a domain name, report server stops working properly. This looks like a permissions issue, Ive tried different combinations of settings, but nothing works. Any insight on how I can get report server setup for internet access (forms authentication), would be much appreciated.
thanks, lance
View 1 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
Dec 16, 2005
am using VS2003 asp.net 1.1 on Windows 2003 sever to access another network server SQL Db.
This is the error message...
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Source Error:
Line 34: 'execute query and return data reader
Line 35: Try
Line 36: objHelperConnection.Open()
Line 37: RunSPReturnDR = objHelperCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 38: 'clean upSource File: c:inetpubwwwrootProtraxxScriptsIncludesdbhelper.vb Line: 36 Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.CreateConnection()
System.Data.SqlClient.ConnectionPool.UserCreateRequest()
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
chef.dbhelper.DBTools.RunSPReturnDR(String strSP, SqlParameter[] params) in c:inetpubwwwrootProtraxxScriptsIncludesdbhelper.vb:36
chef.Login.Authenticate(String sUserName, String sPassWord) in c:inetpubwwwrootProtraxxLogin.aspx.vb:168
chef.Login.btnSubmit_Click(Object sender, EventArgs e) in c:inetpubwwwrootProtraxxLogin.aspx.vb:90
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300
Ps : This app works on Windows XP and W2k
Thanks for any suggestions.
View 1 Replies
View Related
Dec 19, 2007
does anybody know why MS doesnt consider Basic Authentication a viable solution for Inter/Xtra net access to RS? I'm re reading the documentation at http://msdn2.microsoft.com/en-us/library/bb283249.aspx but so far am not getting what the Security Extension options accomplish that can't be accomplished with much less effort using some form of Basic Authentication.
View 25 Replies
View Related
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
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
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
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
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
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
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
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
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
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 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
View Related
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
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
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
May 31, 2007
Can SQL Server do mirroring over Https protocol over internet?
View 3 Replies
View Related
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
