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?
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
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
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
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
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 RelatedI 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?
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
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.
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 RelatedI 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
I have a report that was designed using SQL Reporting Services that sits on a SQL reporting server. It's nothing too exciting, it is essentially a three page application with legal jumbo on pages 2 and 3 and applicant data in fields on page 1.
We use rectangles to force page breaks to page 2 and to page 3.
When running the report on the report server, it shows and prints fine.
When running the report from the QA website internally, it shows and prints just fine.
When running the report from the production website from a machine internally, it shows and prints just fine.
When running the report from outside of the company network, the report is jacked. It obliterates large chunks of text, crams text together, and creates blank pages.
I need help in determining where I even begin with trouble shooting this!
can anyone tell me if they know of a way to automate the update process from development servers to live server, with little interference from an administrator
I have a development team that are constantly updating their databases along with their ASP code, and want to publish changes an a weekly basis. They have asked me for a way to take their new structures, tables, procedures etc, and copy them to the live servers, but NOT to interfere with existing customer data.
Funny I know – and I hate the idea btw :(
Any references, contacts, 3rd party tool recommendations welcome,
Thanx,
Darren
i already find the answer
thanks
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
Can anyone tell me how to link to a oracle user? DO I use a predefined DSN? Do I just specify the server and the user and password?
Your assistance is appreciated,
David
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 RelatedHow would you link an online application form done in php to an SQL 7 server?
View 1 Replies View Relatedthis is the query I need help with
select a.RecordID,a.RelocateID,a.WhenConfirmed,b.RequestI D,b.DocumentID,b.RequestWhen from RelocateeDTA a inner join
docRequests b on ({a.RecordID}=' + CONVERT(VARCHAR, a.RecordID)'= b.WhereClause)
because I am trying to link RelocateeDTA that has RecordID to docRequests that has the same piece of data in field WhereClause but is a varchar, and I am getting an error message (syntax error or access violation)
Could somebody help me please
Hello there, im new here and wanted some help, i would be very grateful to anyone that can help:
I am setting up a DSN for my website (www.t-f-l.com, it may make more sense if you visit the site) i need it so members can sign up to the site (for the exact problem, click 'sign up now' on the website
I have set up the DSN but it says i need to link it to the database tables via MS access, im not sure at all how to do this...please can someone help
please explain in real idiot language....as i am new to this
dear experts,
i have two tables, tblcustomer and tblform. in tblcustomer i have cutomerid PK and i have also a field that link these two tables customername. in tblforms i have formname. customername and formname are not PK and customername has a lot of null values.
my question is that i want to link these two tables in customerid not the name and also to get the forms used by this customer. the thing is that i have to write a join query.
any suggestion to do that?
thanks my friends
I am not a database manager, but I work with people that use databases for sales and customer service... so I am not too familiar with the code and lingo... please bear with me.
We use two databases - one is in SQL, and it is for pre-sales customer service... i.e. tracking notes, phone calls, emails, and opportunities.
The second database is in Progress, and it is for actual quotes, tracking time, labor, materials, cost, and revenue.
As of now, our sales people have to enter new customers in the SQL database, and then duplicate the information in the Progress database. It's very frustrating, because everything needs to be entered twice - name, address, phone, shipping info, etc. etc. etc... When we first started this - 10 years ago - we were told that it could all be linked.
So my question is - is it possible to link these databases together? When our sales people enter a new contact in CRM, I'd like it to be automatically entered into the Progress database. If they make a change to a phone number, I'd like that to be updated in the Progress database. Also the other way around - if a shipping address is changed in the Progress database, I'd like it updated automatically in the SQL database.
Please tell me this is possible - and easy!!! Thanks for any help you can provide at all.
Jon
Does Exchange 2000 and SQL 2000 have to be the same machine to use exoledb.dll?
I want to link to an Exchange server and gain access to a Public Folder Contact Object for use as a lookup table within an Access front end. Someone directed me to use the Exchange OLE DB Provider, but it does not exist on my SQL machine.
Any help is appreciated
Sorry If I have posted this in the wrong head,
I would like to Establish connectivity to a Oracle9i DB thro Linked Server, Can any of you guide me to suitable links...
Thanks
I would like to use MVJ's formula for creating a date table.
I would like to use it with our main ERP database. However, I am reluctant to make changes to it because I fear that at some point when we upgrade that software and it's database that the upgrade program will delete my table.
So, here is my question. Performance wise, does it matter whether I add the date table to our ERP database or if I create another database (on the same server) for the custom date table? Does linking between databases take substantially longer than linking within the same database?
I know it's possible to link tables between Access and SQL Server using ODBC....however can u use DAO to do this? If there's a way i would appreciate some help. Thanks in advance.
View 2 Replies View RelatedI link to a sql server for the first time.
I change my .provider and .connectionstring to ADO
And know in one of my forms i get a debug Error; Invalid table Name "tablename"
can someone help me with this.
Thanks eddied
We are considering to implement Microsoft CRM 3.0 in our (small) organization. But we already have some customer information in another system (Unit4). We want to duplicate this information to our new CRM-system. This data will be read-only in the CRM-application.
Both the applications are installed on different servers with their own SQL databases(server 2000 and server 2005)
How can we duplicate the customer information from the unit4-system to Microsoft CRM? Can we simply link those databases using ?ODBC? (I heard something about ODBC but don’t know what it really is.)
Could someone clearly explain me what we have to do to make a construction as described above. (you don't have to give me all details) Is this construction possible anyway?
Thanks!
I am have created a test table in enterprise manager v8 and linked this table to an access database. I am able to append to the table from access but cant delete or update.
Ive set the permission settings to allow the user to update and del so cant work out why this isnt working?
ANyone got any ideas?
Hi,
I have a default instance that is Server1 (2000) and a named instance Server12005 (2005)
How do I link theses servers together so that my 2005 database can query the 2000 database.
Cheers
Leon
Little puzzle this.I need to link from SQL2000 to Access to get to a table held within anAccess DB. Now you can link within Access to a SQL table, but can thisbe done the other way round ? It's the first time I've needed to dosomething like this.What I have is an application which was written (by me) with an Accessbackend (to run on a CD) and now it needs to run on SQL. However, Iwant to be able to swap over between backends so that I can choosewhere this runs from. I've done this with the sole exception of onetable. Previously most of the data was held in one MDB file and a linkto another (one local copy and one on CD). My queries use the link toquery both local and the CD copy data together.I can re-write things if I need to, but I was curious about there beinga way of doing this. What I want in effect is to query a view on SQL,but the data will be held in Access instead of on SQL.I suppose I can import as I need it as the data is purely read only. Idon't think this can be done, but wanted to check first. I can alwaysmove the remainder of the data over to SQL if needed. It's not a bigproblem, just something I'm curious about.Any pointers would be appreciated.Thanks in advanceRyanp.s. In case anyone wonders why I have taken this approach it isbecause we have a query tool and data that we send out to clients onCD. Some now want this web based, so I will publish the application ona Citrix server, and by changing a config file can swap within theapplication to point to SQL (by changing the ODBC settings). This way,I only need one copy of the application and can change backends as Ineed to.
View 2 Replies View RelatedI am trying to compile a simple ODBC and C example on Windows XP SP2.I have Cygwin_NT 5.1.This is the code (obtained fromhttp://www.easysoft.com/developer/l...#dm_fns_drivers)i am attempting to compile.ODBCTest.c
Quote:
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