Linking Two SQL Server Express Servers

Oct 26, 2006

Hello all!

How do I go about linking two SQL Server Express servers? I can't seem to find information on this.

Also, I need to import data from MSDE. Is there anyway to do this?



Regards,



Andrew Cappella-Pakos

View 1 Replies


ADVERTISEMENT

Linking SQL Server 2000 Servers In Express 2005

Jun 5, 2006

Hello,

I was wondering whether it is possible to query linked servers in SQL Server Management Studio Express 2005 if those servers linked to are SQL Server 2000 machines?

I have added some linked servers to express and queried them, however the login timeout is expiring. I thought it might be because of an incompatability.

Cheers,
Damien.

View 1 Replies View Related

Linking SQL 2005 Servers To SQL 2000 Servers Problems

Sep 27, 2007

I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.

1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.

Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)

If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.

Thanks!


Brandon Forest

Database Administrator

Data & Web Services Team

Sutter Connect Information Technologyforesb@sutterhealth.org

View 2 Replies View Related

Linking Servers 7.0 To 6.5

Jun 27, 2001

I need to have database access via an
application to both sql server 6.5 & 7
the 6.5 uses mixed mode security,
the 7.0 uses trusted. Using
sp_addlinkedsrvlogin I can get from a client to
the 7.0 server, but not to the 6.5.
Is this even possible?

View 2 Replies View Related

Linking Two SQL Servers

Jul 23, 2005

Two SQL Servers1) "Test"Payroll DBTransaction Tablepr_SubmitTransaction in Payroll DB********************************************2) "Production"Payroll DBTransaction TablePr_SubmitTransaction in Payroll DBAccounts DBPr_VerifyAccounts (@AcctNumber)********************************************I want to use same pr_VeriftAccounts in both test and productionPr_SubmitTransaction stored procedure.The pr_SubmitTransaction in production works fine when I sayExec Payroll.dbo.pr_VerifyAccounts as it is on same server. (WORKSFINE)Exec [PRODUCTION].Payroll.dbo.pr_VerifyAccounts (DOES NOT WORK)Should I use sp_addlinkedServer ?? to do this ?. Please provide me somefeedback.I know I can acheive this by front end, but I was do it in one storedprocedure.

View 7 Replies View Related

Linking Servers

Sep 6, 2007



We have reporting services on 1 server, while the data comes off of another which does not have rs and on sql server 2000. I was able to build the reports and deploy it. But the report wont render. The error message is shown below.

My question is will linking servers work and if anyone has done this could you pl provide an example?

Thanks in advance

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'sds1'. (rsErrorOpeningConnection)


For more information about this error navigate to the report server on the local server machine, or enable remote errors

View 2 Replies View Related

Problem Linking Servers

Nov 6, 2000

I'm using SQl 7.0. After setting up a linked server. I recieve this
error when attempting to connect to the linked server: 'Error 7302 -
could not create an instance of OLEDB provider 'SQLOLEDB'. Any ideas??

I do not recieve this error when linking from another server.


Thanks,

Steve Bajada

View 2 Replies View Related

Problem With Linking Servers

Jul 20, 2005

Hi.I have two sql servers and have ran exec sp_addlinkedserver 'ACSPSM', N'SQLServer' to link one to the other and also vise versa.Each server has two users permissioned.My problem is when ever I try to do something that does a remote write I getthe follow error messageMicrosoft OLE DB Provider for SQL Server error '80040e14'[OLE/DB provider returned message: Cannot start more transactions on thissession.]Alsowhen I try and manually run a stored procedure, I get:Remote tables are not updatable. Updatable keyset-driven cursors on remotetables require a transaction with the REPEATABLE_READ or SERIALIZABLEisolation level spanning the cursor.(1 row(s) affected)(1 row(s) affected)(50 row(s) affected)Server: Msg 7395, Level 16, State 2, Procedure ams_Move_Stock_To_PSM, Line65Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. Anested transaction was required because the XACT_ABORT option was set toOFF.[OLE/DB provider returned message: Cannot start more transactions on thissession.]Can anyone suggest how I resolve this.FYIDatabase Creation Script: (both database are the same scripts but db namesare changed)CREATE DATABASE [msmprim] ON (NAME = N'msmprim_Data', FILENAME =N'D:ACS_DBdatamsmprim_Data.MDF' , SIZE = 2000, FILEGROWTH = 10%) LOG ON(NAME = N'msmprim_Log', FILENAME = N'D:ACS_DBlogsmsmprim_Log.LDF' , SIZE= 2000, FILEGROWTH = 10%)COLLATE Latin1_General_CI_ASGOexec sp_dboption N'msmprim', N'autoclose', N'false'GOexec sp_dboption N'msmprim', N'bulkcopy', N'false'GOexec sp_dboption N'msmprim', N'trunc. log', N'false'GOexec sp_dboption N'msmprim', N'torn page detection', N'true'GOexec sp_dboption N'msmprim', N'read only', N'false'GOexec sp_dboption N'msmprim', N'dbo use', N'false'GOexec sp_dboption N'msmprim', N'single', N'false'GOexec sp_dboption N'msmprim', N'autoshrink', N'false'GOexec sp_dboption N'msmprim', N'ANSI null default', N'false'GOexec sp_dboption N'msmprim', N'recursive triggers', N'false'GOexec sp_dboption N'msmprim', N'ANSI nulls', N'false'GOexec sp_dboption N'msmprim', N'concat null yields null', N'false'GOexec sp_dboption N'msmprim', N'cursor close on commit', N'false'GOexec sp_dboption N'msmprim', N'default to local cursor', N'false'GOexec sp_dboption N'msmprim', N'quoted identifier', N'false'GOexec sp_dboption N'msmprim', N'ANSI warnings', N'false'GOexec sp_dboption N'msmprim', N'auto create statistics', N'true'GOexec sp_dboption N'msmprim', N'auto update statistics', N'true'GOUser Creation Script:/****** Object: Login MSM Script Date: 31/10/2002 10:41:26 ******/use [msmprim]GOdeclare @sqlLoginName nvarchar(32) select @sqlLoginName = N'msm'declare @UserPassword nvarchar(32) select @UserPassword = N'wibble'declare @logindb nvarchar(132) select @logindb = N'msmprim'declare @loginlang nvarchar(132) select @loginlang = N'British English'if not exists (select * from master.dbo.syslogins where loginname =@sqlLoginName)BEGINif @logindb is null or not exists (select * from master.dbo.sysdatabaseswhere name = @logindb)select @logindb = N'master'if @loginlang is null or (not exists (select * from master.dbo.syslanguageswhere name = @loginlang) and @loginlang <> N'British English')select @loginlang = @@languageexec sp_addlogin @sqlLoginName, @UserPassword, @logindb, @loginlangEND/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/if not exists (select * from dbo.sysusers where name = @sqlLoginName and uid< 16382)EXEC sp_grantdbaccess @sqlLoginName, @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datareader', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datawriter', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_owner', @sqlLoginNameGOuse [msmprim]GOdeclare @sqlLoginName nvarchar(32) select @sqlLoginName = N'psm'declare @UserPassword nvarchar(32) select @UserPassword = N'wibble'declare @logindb nvarchar(132) select @logindb = N'msmprim'declare @loginlang nvarchar(132) select @loginlang = N'British English'if not exists (select * from master.dbo.syslogins where loginname =@sqlLoginName)BEGINif @logindb is null or not exists (select * from master.dbo.sysdatabaseswhere name = @logindb)select @logindb = N'master'if @loginlang is null or (not exists (select * from master.dbo.syslanguageswhere name = @loginlang) and @loginlang <> N'British English')select @loginlang = @@languageexec sp_addlogin @sqlLoginName, @UserPassword, @logindb, @loginlangEND/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/if not exists (select * from dbo.sysusers where name = @sqlLoginName and uid< 16382)EXEC sp_grantdbaccess @sqlLoginName, @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datareader', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_datawriter', @sqlLoginName/****** Object: User sm_web Script Date: 31/10/2002 10:41:26 ******/exec sp_addrolemember N'db_owner', @sqlLoginNameGO

View 1 Replies View Related

Linking Oracle View To SQL Server Express

Sep 6, 2007

Hi,

I was able to link SQL Server Express to Oracle views using Linked Manager. However, when I run the query, the performance is very slow.

Is there a way to improve performance in querying?

Previously I was using Access to link to Oracle view. But the performance is not good. Takes about 8 hours for approx 6000 records.

Thanks a lot,
Stara

View 3 Replies View Related

Linking Database Tables On Different Servers?

Oct 16, 2015

I have two production servers with two different databases and I was thinking about using Linked Servers, but never did this before.Found this stored procedure

sp_addlinkedserver('servername').Would you just execute this and then run your query after the SP?

View 8 Replies View Related

MS SQL Linked Servers(Linking MySQL To MS SQL) Collation Problem.

Jun 21, 2007

Hello,I have a problem. I've linked MySql server to MsSql, in MySql I have atable with Latvian data(character set is ucs2, ucs2_general_ci) andthe problem is that when I use openquery to read data from MySQLserver, some characters are not translated correctly! I receivequestion symbols instead of Latvian special characters.Maybe someone had this kind of problem with collation?

View 2 Replies View Related

SQL 2000 Enterprise Linking Of Servers Not Pulling Data.

Dec 8, 2006

I know this is an easy one for most of you but this is new territory for me.
I am trying to link a production application database to an existing SMS database.
Both of these databases are SQL 2000. I have sa access to both of them.
I have an accreditation application that deals with internal processes within our active directory network. We are using SMS database collections to provide the discovery for reporting of this application database and I want to compare the collection to the existing data between the 2 databases.


For simplicity I will define them both.
Application Database we will call €œA-Database€?
SMS Database we will call €œB-Database€?

I have gone into the A-Database and gone to linked Servers under the security node in enterprise manager. I created a new linked database and selected the SQL Server option in the general Tab.
In the Security Tab I selected the €œBe made using the security context€? and used €œsa€? for the Remote login and the CORRECT sa password for the With password option.
The server options tab remain the same with €?RPC, RPC Out, & Use Remote Collation€? selected.

It appears to connect but there is not any Table or Views showing up. What am I doing wrong here and what do I need to do to link these 2 database engines so I can move forward?

Thanks,
Gene Godsey

View 7 Replies View Related

Connect Multiple Servers In MS SQL Server Express

Jun 26, 2007

How do I connect DB's on different servers? I can't find a good explanation that works for me.

View 1 Replies View Related

Linking To EXCEL Database Sheet Using SQL 2005 Express

Aug 9, 2006

I'm followed instructions to create a linked server to an EXCEL document that has data in 1 sheet.

Used the instructions from http://support.microsoft.com/kb/306397/EN-US/

Was planning to import data using a linked server as describe in http://support.microsoft.com/kb/Q321686

"How to import data from EXCEL to SQL Server (using linked servers). All went well until...

The EXCEL document shows up under linked servers correctly, but there were no tables.

I'm using the following:

Server: Microsoft SQL Server 2000

SQL Server Managerment Studio (2005)

Does anyone have Idea what I may do to correct this problem?

I 'm using this because I didn't see any other way to import Excel into SQL Database using SMO 2005.

SMO 2005 doesn't have DTS import export commands.



View 5 Replies View Related

SQL Express Data On Web Servers - Will It Work?

Jul 7, 2007

I am preparing a new website that will contain names, address and phone numbers of people in my region of Costa Rica. Will I be able to post a database prepared in Visual Basic 2005 Express / SQL Server 2005 Express on the website's MySQL Server and utilize the data to populate webpages?

If not, what should I use to prepare the database and drive the webpage.

New to SQL and VB
Don Johnson
Latitude 8 Lodge
Costa Rica

View 2 Replies View Related

SQL Express On Load Balanced Servers

Sep 21, 2006



Hi,

I have two 2003 servers which are load balanced - not for high demand but for resiliance. The application that is being run on both servers shares data on a NAS raid 5 device.

Can I install SQL Express on each of these servers and have them share the databases on the NAS device?

Help please anybody?

Paul

View 3 Replies View Related

Linking To SQL Server 5.0

Sep 2, 2007

I'm writing my first web site using VS 2005 and with my login page I'm trying to link with my SQL database using the following setting in my web.config file
<appSettings> <add key="SQLDB" value="server=STEVE-LT; database=MasterDB; uid=sa pwd="/></appSettings>
Then in my Login.aspx file I use the following code to access the SQL database
Dim Sc As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("SQLDB"))Dim SqlCmd As SqlCommand = New SqlCommand("Select Password, Name from Login")SqlCmd.CommandType = CommandType.StoredProcedure
Sc.Open()SqlCmd.Connection = Sc
 This raises the following error message
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Could someone please tell me where I am going wrong. Thanks

View 2 Replies View Related

Linking 6.5 Server

Mar 8, 1999

I can't seem to link a 6.5 database from 7.0 and there's nothing in help which seems to help. Is it a "SQL Server" or do you have to use the OLE DB Provider? If the latter, what's supposed to be in the Product, Data Source, Provider String and Catalog fields? What about security? I've tried everything I can think of and can't get it to work. I also get errors creating a new DTS package that says "Could ot create Component Categories Manager", and then "Error during creation of DTS Package". I installed the desktop version of 7 on an NT Workstation. Has anyone successfully linked a 6.5 server in this environment?

View 4 Replies View Related

About Linking Server

Oct 27, 2007

About linking server













Hi,
I am using sqlserver2005, when i make linked server connection between sqlserver2005 and oracle10g . It shows an error like that " Particular table doesnot exist or user doesn't have permission to connect ti this table"and below this one message is shown which is " Message 7314, line16".But i am giving it a proper "username/password ". In this linked server i am using Oracle10g new provider "ODAC101040.exe". so, please elaborate my such problem and also gives me the solution of this problem.
Thanx
regards
gautam

View 3 Replies View Related

Linking From SQL Server To MySQL

Dec 13, 2004

Hi all, hoping someone can help.
I have created an ODBC connection to a remote MySQL database.
I can then go into DTS wizard and specify this ODBC connection, it all goes through fine and I can see the tables on the remote server and import data.
The problem arises when I try and create a linked server using the same ODBC connection. I get the following error, when I try to view the tables.
I am so stuck. Any help would be very much appreciated.

View 3 Replies View Related

Linking SQL Server To Frontpage

Feb 26, 2005

Is this possible?

View 2 Replies View Related

Linking To SQL Server In Access

Feb 6, 2006

We recently upgraded a number of databases from MS Access 2000 to SQL Server 2000. I need to make it so that users can display the data from the SQL Server so I created some link tables in Access for them to view the data without using SQL Server Enterprise Manager. This works fine in tables with only a few thousand rows of data. However some of the tables have 100K+ rows of data, and these are not displaying the data. When someone tries to view the data in one of these tables all they see is #Deleted in every column. Is it possible to link to tables in SQL Server with large numbers of rows and view this info in Access?

Miranda

View 5 Replies View Related

Linking To An SQL Server Table

Apr 3, 2006

Rather than using the upsize wizard in MS Access to connect to tables on a backend SQL server, how would I go about linking an Access Database to an existing table on an SQL server?

Thanks, Phil

View 11 Replies View Related

Linking To SQL Server To Access 97

Dec 7, 2007

OK here is my situation: I work in a laboratory with a 10 year old instrument that stores results in an Access 97 DB. The DB is beautifully designed and implemented. The problem is that since the software is so old, once the DB gets above a few MB in size the application starts to fail. So their solution is to Backup (make a copy) and Cleanup (delete data older than X days) once a week. So what I end up with is a bunch of copies of the DB, which fragments the data that I need. In order to get the data results I have been using an Access 2003 DB linked to this one (because I can't create Views in that database). The lab users then use the linked DB directly or I have written some automation code in Excel VBA (ADO) to simplify it for the other users. This allows us to query data immediately as it is produced.

My hope is that I can somehow get all of the data into a SQL Server DB. Now I have imported one of the backup copies of the DB in and the table structure and data imports fine into SQL Server, but I end up with duplicate rows because the different DB backup files have overlapping data, and for some reason there aren't PKeys. Also, I'd prefer to have some way of automating the input. Something like a trigger on the Access table so that any new data is imported into the SQL DB automatically. I doubt this is possible, but that is generally what I am trying to do and I am out of ideas. The ultimate goal is that the SQL DB will always be "updated" and I can use that as my query source and take advantage of the power of SQL Server.

Hopefully that all made sense... if anyone has any ideas I would love to hear them.

Thanks for your time.

View 4 Replies View Related

Linking To Client Server

Nov 21, 2007

Our client wants some changes/modifications in his DB but he does notwant us to touch the original Server. What would be the best/ fastestsolution for two SQL Servers connecting each other?Thx.

View 1 Replies View Related

Linking Two Tables Within One Server

Mar 31, 2008

First off, I am a novice in regards to SQL server and have the rudimentary skills to navigate, execute, query under SQL Server Manager. So, please bear with me.

I am working on a program that was not developed by myself, it is for my business and the company that developed it has gone under, so I have no technical support. The program uses SQL Server and ASP.net. We had a recent hard drive crash and I am in the predicament of having to re-install a new instance of the server onto a new computer. I have the most recent saved "data" files within "Microsoft SQL server/MSSQL/Data" directory. It includes the master, model, MSDB, etc. files.

Long story short, I have been successful in making the program operational again and I can connect to the server properly. It even works when web connecting with internet explorer. The problem I am facing is that all of the data is missing. When I connect through SQL Server Manager, I can see that there are two databases, I will name them "data1" and "data2". When I run a query of the tables, all the data is in "data2". All the stored procedures and tables are identical in both "data1" and "data2".

I am assuming (hopefully I'm right) that "data1" and "data2" are somehow linked or joined in some way. Any insight in how to get these two tables to link would be very much appreciated. Again, I am a novice, and will need help with specific coding that I can put into a query window and execute.

Thanks in advanced.

View 6 Replies View Related

Linking Tables To SQL Server

Apr 23, 2007

I'm new to SQL Server 2000. I decided to purchase this server because my old company (UPS) used the server to help expedite queries and manage on-line reporting. So, now it's up to me to utilize and understand the new server. I have been using MS Access as my front-end for several ad-hoc databases, so I'd like to keep utilizing this method. I want to test my first database using the SQL Server.



I've got everything set up. The IT department has installed the server software on my computer. Within my Access database, I link in tables from a database called "Progress" using a Merant driver. Queries, forms, macros and modules are all pulling from these "linked" tables. Do I need to link these tables into the SQL Server? How do I transistion this database over to SQL? I guess I'm confused about the relationship of how all of this should work.



Right now it looks like this:



PROGRESS ..... linked....... MS Access ....... reporting/results



Where does SQL fit in?

View 1 Replies View Related

Linking Access To SQL Server

Jan 22, 2007

Hi,

I have an existing Access DB with many Tables, Forms, Queries and Reports. I need to put a SQL Server Back end on this database.

Do I need to code a mirror images of these objects or is there some way to export these into SQL Server?

Also, where do I deal with assigning usernames and passwords? Access or SQL Server. I need to have different views for different users based upon their rights (user, admin)

Thanks,

Mark

View 4 Replies View Related

Problem With Federated Server Linking

Apr 29, 2008

Hello everyone.

I am trying to implement linked servers and I am having some trouble. The setup is as follows: I have two machines with the same SA login/pwd. BOTH machines have a database called: Federated_Bridge.

On machine 1: Federated_Bridge contains a table Fed_Entity_1

On machine 2: Federated_Bridge contains a table Fed_Entity_2


Machine 1, when I look it up in SQL Enterprise Manager it says: (local)

Machine 2, when I look it up in SQL Enterprise Manager it says: REALIBM2


When I expand those, I can see the databases folder and I can then see Federated_Bridge respectively.


On machine 1 (local) I am trying to create a linked server. I use the following SP call:

---------

use master
go
EXEC sp_addlinkedserver
@server = 'TEST3',
@srvproduct = 'SQLServer OLEDB Provider',
@provider = 'SQLOLEDB',
@datasrc = 'REALIBM2Federated_Bridge'


EXEC sp_addlinkedsrvlogin 'TEST3', 'false', 'sa', 'sa', 'mysapwd'

--------

The above queries seem to execute fine. Afterwards, when I check in Enterprise manager, I can see under linked servers TEST3 .. but no tables or views are showing.

When I run the following select query from query analyzer, I get an error message:


SELECT * FROM Test3.Federated_Bridge.dbo.Fed_Entity_2

SQL Server Does Not Exist Or Access Denied


Please help!!

Thanks.

View 1 Replies View Related

Linking A Text File To SQL Server

Jul 18, 2006

Hi all.

I need to create a Linked Server in SQL 2000 to a text file. Importing the file is not an option. It has to be linked. I tried creating a ODBC link to it but I must be doing something wrong because it didn't work.

Please help.

Thanks,
ODaniels

View 2 Replies View Related

Linking A SQL Server 2000 DB To 2005

Aug 8, 2007

I am trying to link an existing SQL 2000 server to a new 2005 box, but for some reason it will not link. I tried another 2000 server and that one worked perfectly well.

When I link it and perform a simple query...
select a, b from [server1].[db1].[dbo].tablec

I receive a 7314 message with text "OLE DB provider "SQLNCLI" for linked server "server1" does not contain the table "].[db1].[dbo].tablec". The table either does not exist or the current user does not have permissions on that table.

What's odd is that I was able to link the problematic server to other SQL 2000 servers with no previous issues.

Any ideas?

Thanks,
Steve

View 3 Replies View Related

Linking SQL Server To Access MDB File

Mar 8, 2004

Hi,

I am using an MDB file to talk to a SQL Server. I would like to use pass-through queries to keep as much of the processing on the server as possible. However, I have been told that the results of such queries will be read-only. How do I keep the processing on the server but generate read-write answers to my queries?

Thanks
Matt

View 3 Replies View Related

SQL Server 2008 :: Linking Two Tables To One

Feb 6, 2015

I have table1(Client widgets) and Table2(Client Toys) I want to link both Table1 and table2 up to Table3(ClientNames)

All tables have a clientid field

I want to right join them so I get all the client widgets and Client toys for each client...

View 2 Replies View Related







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