Connect Throught Internet Between 2 Server.
Feb 27, 2004Hi 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
ADVERTISEMENT
Unable To Connect To Sql Server Throught Asp.net
Nov 30, 2005hello guysI'm trying to access a sql server database through an asp.net web application and I get the following message"login failed for user 'MYCRAYASPNET' " where MYCRAY is the server name. I enabled mixed mode authentification to the server and created a user "ASPNET" for the database. But while creating the user, enterprise manager never asked me to supply a password.does anybody know what's going on here?Thanks for any input.Naby.
View 1 Replies View RelatedHow To Connect To Other M$ SQL Server Over Internet??(Help Me)
Oct 27, 2005My 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
Connect To Sql Server Through Internet
Mar 6, 2005Hi,
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!
Connect To SQL Server Via Internet
Sep 6, 2006Hi 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
Sql Server Does Not Exist When I Connect To Internet
Mar 18, 2004Hi,
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
Connect To Sql Server 2000 Via Internet
Jul 25, 2005I'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 RelatedConnect To Sql Server Desktop Engine Over Internet
Apr 11, 2004i 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
Connect To Sql Server 2005 Standard Thru Internet
Jul 12, 2007Hi!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 RelatedConnect To SQL Server 2000 Trough Internet (adsl Connection )
Mar 29, 2007Hi 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
Ssis Package Can't Connect To Pop Server Over The Internet From Sql Server Agent
Dec 20, 2007Sql 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 RelatedReporting Services :: Connect To Report Server From Client Through Internet Browser
Jun 11, 2015after 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 RelatedHOW TO CONNECT SQL OVER INTERNET
Jun 17, 2008Please 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!
Connect To Database That Is Onto The Internet.
May 3, 2008I 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.
Connect To The Internet Using Activesync 4.5
Apr 20, 2007hallo could anyone tell me how do i connect to the internet through activesync ? thx
View 1 Replies View RelatedDTS FTP Task Unable To Connect To Internet
Jul 9, 2004I 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.
Can't Connect To Multiple SQL Instances Over The Internet With SQL Browser Service
Nov 2, 2006I 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 RelatedSending Emails Throught DTS Packages In Sql Server 2005
Jan 23, 2007Hai,
I am working on the DTS Package in SQL Server 2005 , actaully the DTA Packages Use OutLook to Send the email to the Mailing List , now that Out Look Stuff is not working Fine , soo I came to know that we can use Sp_send_dbMail stored Procedure insteds of Outlook , i am trying to do that my Email contains the attaachment to the Text file from the shared Folder.
I am not Getting the Correct Help when i am trying .
So can some one Helpe Providind Some examples and suggetions .
Thanks
How Can I Search Throught DOCX (MS Word 2007) Documents By SQL Server 2005 Full Text Search Engine?
Dec 11, 2006How can I search throught DOCX (MS Word 2007) documents by SQL Server 2005 Full Text Search engine?
Should I something download?
How Do I Connect From One Sqlserver7 To Other Sqlserver7 Through Internet
Jul 20, 2005hi myself avii am developing one appilication in which i am using vb as front end andsql server 7.0 as backend. i all ready complete the full application andit installed it on my clients computer. but some times i need my clientsdata which is on his computer,so any one can help me to find out how do i connect to my clients sqlserver through internet i. e. how do i configure or use server networkutility / Client network utility. i need it very badly.plz help methose who r giving me their valuable help plz mentioned their email id sothat i can contact further
View 1 Replies View RelatedCan't Execute Master.dbo.xp_cmdshell Throught A Variable.
Dec 5, 2007
Hi all.
I've previous posted a message with error building the expression of the dtexec.exe string. But now, the problem is other, and I've decided to create other threat.
Here is what I'm doing:
I've a SP that receives every parameter so I can build my dtexec.exe statement to be executed by a variable with something like this exec @rc = master.dbo.xp_cmdshell @CMD
Till now I have no problem executing it, not from a variable, but just with the statement itself, like this:
exec master.dbo.xp_cmdshell 'C:PROGRA~2MICROS~290DTSBINNDTEXEC.EXE /SQ PACKAGE /SET "Package.Variables[PERIOD].Value";20070101'.
But now, I have this SP that builds the string into a variable and then I just want to execute it throught the variable like this: exec @rc = master.dbo.xp_cmdshell @CMD.
When I make a SELECT @CMD just before the exec @rc = master.dbo.xp_cmdshell @CMD, so it prints the builded string, copy it and pasted to exec master.dbo.xp_cmdshell 'copied string' it works fine. But the step of exec @rc = master.dbo.xp_cmdshell @CMD returns the error:
The filename, directory name, or volume label syntax is incorrect.
Why is this, if I copy the generated string and execute it by the other way it works fine, but executing the generated string throught the variable it gives me that error?
Decimal Datatype Conversion From DB2 To SSIS Throught Microsoft OLE DB Provider For DB2
May 1, 2007Hi All,
Here is a description of the issue I'm facing about decimal datatype conversion from DB2 to SSIS throught Microsoft OLE DB Provider for DB2.
I first discovered it when I tried to use a LookUp trans. and selected a decimal typed field. I was unable to validate it and clicking the OK button threw the error copied below:
TITLE: Microsoft Visual Studio
------------------------------
Error at Data Flow Task [DTS.Pipeline]: The "output column "MFIXFRA" (317)" has a value set for length, precision, scale, or code page that is a value other than zero, but the data type requires the value to be zero.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC0204019 (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
Some workarounds on this issue led me to two other strange behaviours:
- If I create a dataflow task to perform a raw copy of a DB2 table to a brand new table in SQLServer destination (by clicking "new" instead of choosing an existing destination table), generated "create table" script for decimal fields is quite different from source table. For example, a source field declared Dec(15,2) is translated as Dec(29,5), and so on.
- Quite same behaviour if I try to derive a column using as derived column trans. If the source column is a decimal, it's scale and precision are interpreted ramdomly.
Any idea welcome
André
Loop Throught Columns Of An Excel File Using Dtsx Package!
Dec 29, 2006Hello,
I'd need an help because I'm stucked!!
I have to import an Excel file into my DB.
The Excel file is made by 2 worksheets but I need only one and inside this worksheet I have to loop through the columns and for each column I define a Data Flow that trasform the data as necessary and then insert into the table.
I started with a "Foreach ADO.NET Schema Rowset Enumerator" with connection=excel file and the schema was set to "Columns" but the loop go also through the worksheet that I don't need..
after 4 hours of tries I'm lost...
Someone could give me an advice?
ThankX
Marina B.
Maintain Session State Throught Application For Long Time
Mar 31, 2008
Hi,
I need the application not to expire the session always. I need to maintain the session always even if the user keeps the web application idle for long time.
Regards,
Saravanan Gajendran
SQL Server And Internet
Mar 13, 2000Hi,
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.
Need Help --&&> Connecting To Oracle Throught SSIS Package(Failed To Decrypt An Encrypted XML Node Because The Password Was Not S)
May 14, 2007Hi,
In BI Tool SSIS Packages run fine and get data From Oracle and Save it in SQL Server.
Package Protection Level is EncryptSensitivewithPassword.
In BI tool when i open the package it ask password and then run fine.
If i change the Protection Level to Dont save Sensitive,
It does not run fine in even BI tool.
It is fine if i use EncryptSensitivewithPassword.in BI Tool and run it.
Now the problem is that i need to run this package through SQL Job.
so Job give error
"Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information."
Please i need help ?
Thanks
Conecting To The Internet Server
Oct 18, 2000i want to connect to remote sql server through ip address
iam using winnt server 4.0 and sql 7.0
Sql Server Licensing For Internet
Apr 9, 2001I 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!
Access Sql Server Over Internet
Dec 24, 2004I 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..
Updating 2nd MS Sql Server Over Internet
Feb 2, 2004Hi,
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
SQL Server Connection Over Internet ??
May 1, 2004Hi 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..
Connecting To SQL Server OVer Internet
Jul 23, 2005I 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.
View 5 Replies View RelatedDoes SQL Server Work Well Over The Internet?
May 17, 2008I 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?