Databases In Remote Servers

May 12, 2006

Hello,

This is my first post, and i am looking for help about Databases in remote servers.

This is my problem:

1) I have a free account in "HostBasket", with 50 mb of space, and 10 mb of SQL Server... with ASP.NET 2 support --> http://www.hostbasket.com/dotnet2.shtml?LinkFrom=10060

2) They gave me this info for the database:


Your SQL Server: sql15.hostbasket.com
Your database name: myDatabaseName
Your login for the database: myLogin
Your password for the database: myPassword

Connection string for ASP.NET (using ADO.NET with System.Data.SqlClient namespace):

Persist Security Info=True;User ID=myLogin;Password=myPassword;Initial Catalog=MyDatabaseName;Data Source=sql15.hostbasket.com

 3) Actually, i don't know what to do with that info... I mean, i have read so much info, and all people saying "their way" to do things... oh, I am so confused...

4) I read in a website, this: "the database can be uploaded as a FILE saved in the App_Data folder, under the .mdf extension"

I read that from : http://dotnetjunkies.com/QuickStartv20/aspnet/doc/data/vwd.aspx

5) In the url given above, there is a "step by step" example... i follow it, exactly (i start a asp.net website, i create the database and the table, i show the data with the grids, etc )

6) All is OK until here, i mean, when i run the website with VWD, it shows me the info OK.

7) But... ¿How can i do this works on the Remote Server i described in 1) and 2) ?

I know how to upload my website, in fact i uploaded a very basic one, and all was OK, but when i work with databases starts my problem...

So, i am almost sure, that i have an error in the "Conecction String"...

 connectionString="Data Source=.SQLExpress;AttachDbFilename=|DataDirectory|MiBaseDeDatos.mdf;
Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" 
¿How should it be, to work with my free remote server?

or,

if you have done the "easy way" of uploading the .MDF file in the server (but a server different of mine) please, tell me the "how to..." (and the server you used :p )

--------------------

Ok guys, i am a Chilean young (i dont speak english very well) and i tried to write my ideas in an easy way, so I REALLY HOPE you can help me.

I am a New (very new) on this (vwd , .net , asp.net ) in fact, i am using this just 3 days ago...

THANK YOU SO MUCH,

Carlos,
La Serena, Chile.

View 7 Replies


ADVERTISEMENT

Remote Servers ?

Jan 8, 2001

Hi Everybody,

Can anybody help me on Remote Servers. I want to create a remote server
from 6.5 to 7.0. Is it possible to create a remote server from 6.5 to 7.0?.

From the Books online I saw remote server related commands. Like Linked servers in 7.0, tables of 7.0 can be extracted like "select * from <Remote_server>.<Database>.<Owner>.<Table_name>", in 6.5 Remote servers?. How do we execute a stored procedure of 7.0 Database from 6.5 server in remote server?.

Can anybody guide me on the above topics.

Tks in advance,
Sam

View 2 Replies View Related

Remote Servers

Jun 15, 2000

How do I add a remote SQL server to a local SQL server so that I can query it
using the normal T-SQL syntax. I have already tried using the following syntax:

sp_addlinkedserver @server = '233.56.152.112',
@srvproduct = N'SQL Server'


This caused the server to show up in the linked servers under Security folder in the Enterprise Manager GUI.

BUT WHEN RUNNING THE FOLLOWING QUERY:
(Select * from 233.56.152.112].remoteDATABASE.dbo.remoteTABLE)

I GET THE FOLLOWING ERROR:

[OLE/DB provider returned message: Client unable to establish connection]
[DBNMPNTW]ConnectionOpen (CreateFile()).

ANY GUIDANCE IS GREATLY APPRECIATED

THANKS

View 2 Replies View Related

Remote Servers

Oct 22, 1998

I am trying to get 1 SQL Server to update another SQL Server.
I have followed the examples in the books on-line and did have some success until I rebooted one of the servers.
I need a step by step process of how to set up the communication link to these servers.

View 1 Replies View Related

Connect 2 Databases On 2 Servers ???

Sep 4, 2007

 Hi, If you have  2 databases with the exact same table columns, and in the first database in a table column the indentidy seed starts at 1 and finishes at 32,000 can you attatch a second database so that the indentity starts at 32,001and carries on. What happens if you create a site and run out of disk space and need to attach another database which is located on another server??? I am really confused about this.Hope someone can give some links to some articles about this as I can't find any information about it.How can this be done? Thanks 

View 1 Replies View Related

Transferring Databases Between Servers

Feb 15, 2002

I need some advice on copying databases, stored procedures, views, logins ..etc from a SQL Serevr 7.0 server, to a new SQL Server 2000 server.
Is it better to backup the databases on one server and then restore them to the other. Or id it easier to use the Wizards to Import everything from new server, or to Export everything from the old server ?

Any advice would be appreciated. I need to ensure that I do not miss anything, in particular Stored Procedures in the old master database.

View 2 Replies View Related

Documenting SQL Servers/databases

Mar 27, 2001

I'm fairly new to a DBA role, I've been tasked with documenting all the SQL servers/databases. Is there anywhere on the Web where I could find a standard list of what needs to be documented. Any help/advice would be appreciated.

View 1 Replies View Related

Transferring Databases Between Servers

Jan 11, 2000

I tried using Import/Export to transfer a database from one SQL Server box to another using NT authentication.

The database appeared to transfer OK, however the process crashed with an error suggesting that a SQL Server login was not present.

How are the SQL Server logins transferred ?

Richard

View 2 Replies View Related

How To Connect Two Databases On Two Servers

Aug 23, 2013

We are wanting to know how to connect 2 databases residing on 2SQL servers. The workstation has access to both databases. Join on Cols 1 and 2.

Server1, Database1, Table1, Column1 (Char)
Server2, Database2, Table2, Column2 (VarChar)

View 2 Replies View Related

Compare Databases Between 2 SQL Servers

May 17, 2006

Hello,I wish to see if the tables from database A server A1 exist in databaseA on server B1.I setup a linked server from my first server (robertcamarda) to atarget (cognos-dev)This works from robertcamarda:select count(*) from [cognos-dev].ds_v6_source.dbo.stdmasand this works:select * from ds_v6_source.information_schema.tables order bytable_namebut this wont work:select * from [cognos-dev].ds_v6_source.information_schema.tables orderby table_nameError:Msg 117, Level 15, State 1, Line 1The object name 'cognos-dev.ds_v6_source.dbo.information_schema.tables'contains more than the maximum number of prefixes. The maximum is 3.I want to do something like:select * from ds_v6_source.information_schema.tableswhere table_name not in (select table_name from[cognos-dev].ds_v6_source.information_schema.tables order bytable_name)so I can see of the sql server (robertcamarda) has any missing tablesthat exist on the server (cognos-dev)TIARobSQL Server 2005 Enterprise

View 3 Replies View Related

2 Databases On 2 Servers, 1 Query?

Jan 25, 2008

Hello,

We have adedicated MS-SQL Server for our CRM database and we have another MS-SQL database server for in house applications, written in c#.Net 2.0. To avoid duplicating information already in our CRM database, it would be nice if we could build a query that combined columns from both data sources.Example





Code Snippet

CRM database on Server1
Table Accounts


Columns
AccountID UniqueIdentifier Primary Key

Name NvarChar(50)



Application Database on Server2
Table Transaction


Columns

TransactionID UniqueIdentifier Primary Key

AccountID UniqueIdentifier
Amount Money




Would it be possible to create a T-SQL statement that will select




Code Snippet

Select
Server1.CRM.Accounts.Name,
Server2.Application.Transaction.TransactionID,
Server2.Application.Transaction.AccountID,
Server2.Application.Transaction.Amount



From Server1.CRM.Accounts INNER JOIN Server2.Application.Transaction




ON (Server1.CRM.Accounts.AccountID = Server2.CRM.Transaction.AccountID)


I appreciate there will need to be 2 connections and therefore some credential information would need to be passed too.


Is anything like this possible? I do not wish to copy the Name field from Server1.CRM.Accounts to Server2..Application.Transaction as this is duplication and any change to the value of Server1.CRM.Accounts.Name would not be reflected in the results.


Many thanks for any information provided.

View 3 Replies View Related

How To Run A JOIN Between Databases On Two SQL Servers

Feb 23, 2008





Code Snippet
SELECT ReciptItems.acc_TopicCode, ReciptItems.acc_DetailCode, ReciptItems.acc_CTopicCode,
SUM(ReciptItems.TotalInputPrice + ReciptItems.TotalOutputPrice), a.MoeenName_L1
FROM ReciptItems LEFT OUTER JOIN
Acc_mydbname.dbo.Categories AS a ON ReciptItems.acc_TopicCode = a.TopicCode
GROUP BY ReciptItems.acc_TopicCode, ReciptItems.acc_DetailCode, ReciptItems.acc_CTopicCode, a.MoeenName_L1





How Replace Acc_mydbname with (SELECT AccountDBName FROM Config)

(SELECT AccountDBName FROM Config) ='Acc_mydbname_2008.dbo.'

View 6 Replies View Related

Synchronize 2 Databases On Different Servers

Apr 10, 2006

Hi,

I was wondering if the following is possible: I have 2 SQL Express servers on different machines. One holds the production and one the development database. On a request basis I'd like mirror all the data of the production database to the development database. Right now I have to stop the sql engine, zip the mdf, send it over, attach it to database, etc. and that's quite cumbersome. So, is there an easier way to do this? If not with SQL Express, is it possible with the full version?

Thanks,

Tom

View 1 Replies View Related

Getting Data From Remote Servers

Jun 20, 2007

 
 am an authenticated user of a remote data base
I can log in using sql server management studio and add tables and
even I can back up the database .
Good.

 But I want to get a copy of the
database to my local computer
Is there any way to do
this?The problem is that i don't have access  to the directory of sql sever  pleases tel me a way that is possible just by using sql server or any add on on it 

View 7 Replies View Related

Non-Existent Remote Servers

May 11, 2000

Please help me! We have a server that was renamed some time ago and, for some reason, the old name is now in SQL 6.5 in remote servers. I can't remove it because it keeps saying that it is "not defined as a remote server at the site."

This is a problem because when I try to set up the server for replication as a subscriber, it gives me the same message and won't let me go any further. It's kind of a catch-22; It's not a valid server so it should be removed, but when I try to remove it, it fails because it's not a valid server.

View 1 Replies View Related

Query Remote Servers On 6.5?

Jul 23, 2002

Hi, all -

I know you can execute stored procedures on remote servers in SQL Server 6.5, but can you run regular queries as well using the 4 part name qualification?

Example: select * from server1.database1.dbo.table1

If not, is there another way I can manipulate data on remoter servers?

View 1 Replies View Related

SQL 6.5 Remote Servers / Replication

Aug 23, 1999

Hi

I have two SQL Servers (6.5). One based in London (LDNINNTS9) and one in New York (NYINNTS2).

I had bidirectional replication set up on one table in a DB and everything is (WAS!!!) working fine. Came to work this morning (Monday typical!) and the following has happened.

When I select the remote servers option on the NY server from Enterprise manager I get the following error message

Unable to connect to site '0'because '' is not defined as a remote server.

Now it says that '' is not defined as a remote server. So I did a select of @@Servername and it has returned (null). It was set to NYINNTS2. I have tried executing some ISQL to change the name and started and stopped the SQL Services but the name remains (null). Does anyone have an idea of what I can do to set the name up as it was?

I know that the Server name gets set to null if it is invalid, but I am trying to set it to NYINNTS2, which should not be invalid? Does the domain name impact the validity of the name?

HELP!!!!


Regards

Steve Farmer

View 7 Replies View Related

Exchange Data Between Databases On Two Servers??

May 29, 2007

Dear all
 
I have tow server on the same intranet. One server has a sql server 2000 database and the other one has SQL server 2005 databse.
 The sql 2000 database has a table called employee. When ever a new employee is inserted in the database i would like the same values to be sent to the sql 2005 database. But this cant be done on the application level. It has to be done in the database. The application level can not be changed.
I was thinking a trigger but how to achieve the writing from one database to another. If they were on the same server then it would be easier but because they are on different servers i dont know how to do it.
 Has anyone had similar issue before?
Any help is apreciated.
 
Sincerely
Dan

View 2 Replies View Related

Specify Two Different Servers/databases For SQL Report Viewer

Apr 25, 2008

I'm working with the SQL Report Viewer in VS2k5. In the Data tab, where the Dataset drop down list is, I click the "..." to edit the dataset. I am currently using the following for the datasource...
   Data Source=ServerName;Initial Catalog=DatabaseName
In one database, I store an employee ID number. I need to access a different database on a different server to reference the employee ID and pull the employee's name. Is there a way to specify two different databases on two different servers in the connection string above?
Thanks!

View 1 Replies View Related

Select Data From Two Databases On Different Servers

Oct 27, 1999

Hi there,
I was just wondering is it possible to select data from two different databases on two different servers?

ie Select * from
Server1.databasename..table, Server2.databasename..table


If anyone has any suggestions they would be appreciated,
Thanks,
Fin

View 2 Replies View Related

Tool For Syncronization Databases On 2 Servers

Aug 15, 2005

Hello, I need a tool for management ms sql: compare list of databases on 2 servers (not structure and/or data of 2 databases), copy from one server to second new databases, delete from the second server ... Not to propose Copy Wizard.
Thanks

View 4 Replies View Related

One SQL Statement To Access Databases On Different Servers

Dec 8, 2004

I know the SQL syntax to join two tables in different databases on the ame server, but does anyone know if a SQL statement will allow you to join tables from different databases on different servers?

View 8 Replies View Related

List Of Databases From Multiple Servers Without SMO

Nov 14, 2007



Is it possible to get an aggregate list of databases from multiple servers, without using SMO?

All target servers are running SQL Server 2005.

Ben Aminnia

View 2 Replies View Related

SSIS - How To Run A JOIN Between Databases On Two SQL Servers?

Jan 17, 2006

Hi All,

I need to run an Insert query which pulls data from a table located on server A database AA Table AAA conditional on (or JOINED with) Table BBB in database BB sever B. In SQL 2000 I would simply do the following:

From Server A:

sp_addlinkedserver B

INSERT dbo.ResultsTable

SELECT SourceTable.* FROM B.BB.dbo.BBB SourceTable

INNER JOIN A.AA.dbo.AAA ConditionTable ON SourceTable.RecID = ConditionTable.RecID

sp_dropserver B



What do I need to do to perform the same operation in SSIS world?

Thank you !

View 1 Replies View Related

Restoring Encrypted Databases Between Different Servers

Jun 20, 2007

Hello:

I'm working with two sql servers instances, ServerA and ServerB, which run under two different service accounts on different machines. They both have a database, DatabaseA, that has some encrypted fields.

If I take a backup of DatabaseA on ServerA and restore it on ServerB, I need to re-encrypt the Database Master Key (DMK) with the Service Master Key (SMK) as follows:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'pwd used to encrypt DMK'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

However, if I again take a backup on ServerB and then restore it on ServerA, I can use the DMK on ServerA without re-encrypting it with the SMK.

Shouldn't I have to re-encrypt the DMK with the SMK everytime I restore from a backup that was generated from a different server?

Thanks,
Cyndi







View 1 Replies View Related

How To Reference Different Databases On Different Servers In One Query

Apr 28, 2006

 

View 10 Replies View Related

Problem Registering Remote Servers

May 11, 1999

Hi,

I've SQL 7 running on windows NT 4.0 server.
From my Sql server when I tried to register a remote server in the same office, I couldn't.

When I get the new registration wizard, I could see the server(s) I want to register. But when I finish all the steps in the wizard, it says: Unable to establish client connection.Connection Open(Create File).

I tried using both sql standard and win nt security (logins) but didn't work.

Help please.
Thanks,
Kiran

View 1 Replies View Related

Run Remote Proc Without Using Linked Servers

Aug 1, 2002

Hi

Is there a way (workaround) of running a remote stored
procedure as pass through query and without having to use
linked servers. Something similar OPENROWSET when
selecting form a remote object?

Many thanks
Tariq

View 1 Replies View Related

Transfer Data Between Two Remote Servers

Sep 26, 2005

Hi, I'm looking for an artical or Someone who can explain me what is the best way to transfer data between two remot database?

I'll Explane:
two business have local SqlServer in their office.
1 of business need to get Specific data from other. each database is protected. how can I read ake information of it?

Thanks.

View 5 Replies View Related

Problem Connecting To Remote Servers

Jan 3, 2008

Error: 18456, Severity: 14, State: 16.
Login failed for user 'XXXXXX.COMusername'.

On the remote servers I enabled Named Pipes and TCP/IP and activated the Browser.

Here's what's strange: I can connect to one server but not any other.

View 1 Replies View Related

Question On Restoring Encrypted Databases On Different Servers

Jul 3, 2006

I have run into problems trying to use backed-up encrypted databases. I have an ASP.Net/SqlServer 2005 website for which I have production, test, and development environments, each on its own box. I have set up encryption using Master Keys, Certificates, and Symmetric Keys using the following commands:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'

CREATE CERTIFICATE CERTIFICATE_NAME WITH SUBJECT = 'My Website'

CREATE SYMMETRIC KEY KEY_NAME WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE CERTIFICATE_NAME.

All databases have the same certificate and symmetric key names. The Production database has a different password than the development and test databases.

I am running into problems when I back up the development database and try to move it to the test environment. When I do the move, and then try to access the encrypted data, I get an error "An error occurred during decryption", even though they are the "same" database (I originally detached and copied the development database to the test box when I set up the test environment) with the same password.

I then try the following commands, which I used when I brought the development database over to the test box the first time:

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'password'

This caused the following error:
"An error occurred while decrypting certificate 'CERTIFICATE_NAME' that was encrypted by the old master key. The FORCE option can be used to ignore this error and continue the operation, but data that cannot be decrypted by the old master key will become unavailable."

So, how do you set up encrypted databases so that you can backup from one database server and restore on another? This problem will be very important when I set up a backup production database server.

View 12 Replies View Related

Transact SQL :: How To Compare Columns On 2 Databases On 2 Different Servers

Aug 12, 2015

I need to compare columns in tables on 1 database on one server versus the same on a 2nd server.

I'm looking for added columns in dbase 1.

Is there a system T-SQL script that can be used for this?

View 4 Replies View Related

How To Access 2 Databases On Separate Servers From Within The Same Query

Apr 10, 2008

Hi,

Im trying to access data from a database on another server in a SQL 2005 query.


use Bury2k29.ServiceDeskForms
select .......


but I get the message


could not locate entry in sysdatabases for database 'Burky2k29'. No entry found with that name. Make sure that the name is entered correctly.


Bury2k29 is the name of the server, and ServiceDeskForms is the database I want to access.

When I open a blank query and enter only the code to access that database it runs fine.

Any ideas?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved