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 RepliesHi 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
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
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!
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
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
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
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
Hi!I am trying to connect to my SqlServer 2005 thru internet, but it is notworking. I have a dyndns updater on my server which tells me an ip addressof the router. The router is configured to forward TCP port 1433 to LAN IPaddress of the computer on which is SQL Server installation.What is the connection string to connect to my server.I tried xxx.dyndns.org:1433, but it doesn't work. There is a defaultinstance installed on that machine.Please help.Zvonko
View 6 Replies View RelatedSql 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 Relatedafter installing SQL Server 2008 R2 and the Reporting Services, I've managed to access the Report Manager URL....Reports through the web browser on the machine itself. But if i am trying to connect to on my client browser it does not find the Report Server.Do I need to configure the server in any way? Do I need to configure the firewall?
View 2 Replies View RelatedHi,
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 !
Can I open a Internet Explorer web page by Stored Procedure?
View 14 Replies View RelatedPlease 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!
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.
hallo could anyone tell me how do i connect to the internet through activesync ? thx
View 1 Replies View RelatedI created a DTS FTP task to connect to an FTP site. The problem I'm having is the folder I want to access you cannot see under the Files Tab. So if I put the ftp site/subdirectory in the FTP Site box, I get the error "Unable to connect to internet! Please check the source site information, your username and password"
If I go to the FTP site/subdirectory in IE all the files show up fine. I believe this is limitation of DTS, but I would like to hear from you all first.
To see what error I'm talking about:
Create a DTS FTP task
Use: ftp.microsoft.com/bussys/ with no username or password
Click the Files Tab
Normally you can just put the server name in, and see all the folders/files, but the way my FTP site is set up I cannot see the folder I want, I can only access it.
I recently setup mutliple instances of SQL Server Express at my office. I have 1 default instance, and two named instances. I can connect to the named instance of the default port of 1433 with Microsoft SQL Management Studio Express, however the other instances on dynamic TCP ports can not be accessed by the instance name over the internet. I have to specify the dynamic TCP port in this form: xxx.uconn.edu/SQLTEST, Port number. My current thinking is that the SQL Browser service should tell Management Studio Express what dynamic port number each SQL instance is listening to. Any ideas?
View 1 Replies View RelatedI 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 populate a Public Contacts Folder on an Exchange Server with data in a SQL 2000 Table. What would be the best way to do this?
Thanks
hi everybody, i got this error in my code.
Server Error in '/' Application.
SQL Server does not exist or access denied.
Source Error:
Line 12: Dim SQLConn As SqlConnection = New SqlConnection()Line 13: SQLConn.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")Line 14: SQLConn.Open()Line 15: Line 16: cmdLath = New SqlCommand ( _
my web.config
<configuration>
<appSettings>
<add
key="ConnectionString" value="Data
Source=xxx;UID=xxx;pwd=xxx" />
<add
key="ConnectionString" value="Server=xxx.xxx.x.x;database=xxx;UID=xxx;pwd=xxx;Trusted_Connection=True"
/>
</appSettings>
<system.web>
<sessionState cookieless="false" timeout="20"
/>
<customErrors
mode="Off"/>
</system.web>
</configuration>
what seems to be a problem, please help me??????
hi i have sql server 2000 installed on my domain server machine. Now i want to connect to that instance from another client machine.thanx in advance
View 3 Replies View RelatedI installed sql server 2000 on a remote server. I can connect to
it from the client with query analyzer, but I cannot connect to it from
ASP.NET. I'm using Sql authentication, and the account has every
permission under the sun. I can also connect to it from the
server explorer in visual studio.net. I turned off the
firewall. I tried connecting with the same asp.net code from a
different computer and still no luck. I've triple-double-checked
the connectionstring. It's the same credentials I'm using for
query analyzer and server explorer, which both work fine. Any
troubleshooting tips would be GREATLY appreciated.
Thank you.
I can't connect my jsp file to SQL Server 2000. Below is my code and the error result that i got.. Please help me to solve it..I have installed the driver and write them in the classpath..
<%@page import="java.sql.*"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
try {
// Open Database connection
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://sansan:1433;databasename= coffeepassion","sa","sa");
// Query Database (all queries use the same connection)
String sql = "SELECT EmpID, EmpPassword FROM EmpLogin";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("sql");
// Print header and each record returned
out.println("List of items in the database:");
while(rs.next())
out.println(rs.getString("EmpID") + " " +rs.getString("EmpPassword"));
// Finished using the database instances
rs.close();
stmt.close();
con.close();
}
catch (Exception e) {
out.println(e.toString()); // Error message to display
}
%>
Error Result:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database requested in login ' coffeepassion'. Login fails.
I have SQL server 2000 installed on machine A and when I try to connect using machine B, I get the error message:
A connection could not be established to "servername"
Reson: Timeout expired.
I have been able to connect to the machine in the past and this morning, the server was rebooted and now I can't connect. I can see the server using enterprise manager and I can start and stop machine A from B, but I just can't connect. Any ideas?
Thanks
Hello masters,
help me yaar
i am using dotnet 2003 and SqL SERVER 2000. BUT UNABLE TO CONNECT DATABASE using dataAdaptor(design time ) or sqlconnection any can help me
gs
i want to connect SQL Server 2000 with remotely how it will work?
i have a sql server data base on server(domain) in xyz company, they give me following information:
database name
server IP address
database user name
database password
i can connect the same database using networking internet (proxy)
connect internet connection
start proxy connection
i am using a pc from network which is useing proxy for internet.
i open query analyzer
enter IP address, user name and password (which is currect)
though i can't connect sql server
else i can connect the same server which PC is using own internet connection not form network
i want to know that
how can we connect SQL Server using internet connection form network (proxy server)?
where is to enter networ pc IP address?
where is to enter port number?
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
Running ASP.NET 2.0 on a Windows SBS2000 with IIS5 and SQLServer 2000 on the same box.
Trying to use membership controls to authenticate.
Installed aspnetdb on the server using aspnet_regsql.exe
Ran an ASPX page with the asp:CreateUserWizard control.
The "create user" button returns the following error:
A user instance was requested in the connection string but the server specified does not support this option
I appears that the connection string I am using is wrong.(See below for web.config entries)
I have tried:
"data source=RGMILLSITES;Integrated Security=True;database=aspnetdb;User Instance=True""data source=RGMILLSITES;Integrated Security=True;database=aspnetdb;User Instance=False""data source=RGMILLSITES;Integrated Security=True;database=aspnetdb""data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb;User Instance=False""data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb"
I have renamed LocalSqlServer to LocalSqlServerASPNETDB to ensure that a global configuration is not used.
I tried to rename the server in the connection string and got the same error"data source=RGMILLSITES00;Integrated Security=True;Initial Catalog=aspnetdb"
I've checked the Machine.config and web.config in the C:WINNTMicrosoft.NETFrameworkv2.0.50727CONFIG folderNeither have the LocalSqlServerASPNETDB configuration listed.
So now I'm thinking there is a cashing isssue. I've tried to restart the site and got the same result.
Any thoughts would be appreciated.
RobGMiller
The web.config file contains the following related skeema.
<connectionStrings> <add name="LocalSqlServerASPNETDB" connectionString="data source=RGMILLSITES;Integrated Security=True;Initial Catalog=aspnetdb;User Instance=False" ProviderName="System.Data.SqlClient" /></connectionStrings>
<roleManager enabled="true" defaultProvider="CustomizedRoleProvider"> <providers> <add name="CustomizedRoleProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="LocalSqlServerASPNETDB" /> </providers></roleManager>
<membership defaultProvider="CustomizedProvider"> <providers> <add name="CustomizedProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServerASPNETDB" applicationName="/" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0"/> </providers></membership>
Hi,I want to install an asp.net app on a sql server 2000.I've created a virtual Directory which points to the folder C:WINDOWSMicrosoft.NETFrameworkv2.0.50727ASP.NETWebAdminFiles.I've installed my website under InetpubwwwrootIn Web.config I changed the Connection String to point to my local server <connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=MY_DB;Integrated Security=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> </connectionStrings> I'm connecting to: http://localhost/ASP.NETWebAdminFiles/default.aspx?applicationPhysicalPath=XXX&applicationUrl=/YYY and I seeWelcome to the Web Site Administration Tool Application:/MyAppCurrent User Name:ComputerNameLoggedUserIf I click the Security Link, I get the following error:The following message may help in diagnosing the problem: Cannot open database requested in login 'MY_DB'. Login fails. Login failed for user 'MACHINE_NAMEASPNET'. What I missed to configure in order to be able to create Users and Roles in the security app? Thanks
View 1 Replies View RelatedHi!I am going to connect to "SQL Server 2000" through an "ASP.NET Web Application". My development environment is "Visual Studio .NET 2003". In my "Toolbox" -> "Data", I drag a "SqlConnection" and drop on the page. It would automatically be named "SqlConnection1". In its "Properties" -> "ConnectionString" -> "<New Connection...>", I would enter my Server Name (SAMIEI), select "Use Windows NT Integrated Security" and Select the Database on the Server (Northwind). Then such Connection String would automatically be generated:
"workstation id=SAMIEI;packet size=4096;integrated security=SSPI;data source=SAMIEI;persist security info=False;initial catalog=Northwind"
Now, I may see "SAMIEI.Northwind.dbo" in the "Data Connections" row of "Server Explorer" with its all "Database Diagrams", "Tables", "Views", "Stored Procedures" and "Functions".Please take a look at the following code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try SqlConnection1.Open() Catch ex As SqlException Response.Write(ex.Message) End Try
End Sub
It would unexceptedly encounter such error:
"Login failed for user 'NT AUTHORITYNETWORK SERVICE'"
Please tell me the reason. I am much obliged to you for your attention.
Regards!M.Sadegh Samiei
I need to connect SQL Server 2000 to DB2 on z/OS through DB2 Connect 8.I can successfully connect and query data through a System DSN, buttrying to link the server using this DSN and MSDASQL fails (can't seemto find the DB2 Connect server). I've also tried IBM's OLE/DB driver(IBMDADB2).Has anyone successfully linked to DB2 on a mainframe through DB2Connect 8.x via either ODBC or OLE/DB drivers?
View 3 Replies View RelatedI have installed an SQL Server 2000 Developer Edition (SP4) on acomputer that has Windows Server 2003 on it.The server is connected tothe workgroup "WORK" and has no Active Directory. Now I cannot connectto that database server from other computers in the network. On theserver itself, I can registrate the instance from the own SQL Server2000 and also an instance from an other SQL Server 2000 installation ona Windows 2000 Server in the network.The network consists of a Windows 2000 Server (with a SQL Server 2000installation), some workstations (W2000 Pro, Win XP Pro) and the newinstalled Windows Server 2003.When I try to connect to that new database Server with Query Analyzerfrom an other computer I get allways the message box with the text like"...SQL Server doesnt exist or access denied. ConnectionOpen(Connect())..."Many thanks for help.bitchanger
View 1 Replies View Related