Setting Up Linked Server

Setting Up Linked Server To IBM AS400

I am trying to set up a linked server in MSSQL to an IBM AS400 using the IBM AS400 OLE DB Provider. The New Linked Server dialog box asks for properties Product Name and Data Source. I would like to know from someone who has successfully set up a linked server to an AS400 what the specific syntax in the properties needs to be. I have reviewed the OLB section on sp_addlinkedserver, and while this is helpful and gives many specific examples, I need an example for an AS400. Thank you to anyone who can help!

Setting Up Linked Servers With SQL Server And Oracle

Does anyone know where I can get some good examples of how to set up a linked
server to an Oracle data source in SQL 2000? I can't seem to get a link
set up to my Oracle database. In particular I am wondering how the communication works between OLEDB to the Oracle Instance and how to trouble shoot issues (for example, would is the Oracle Listener what OLEDB is talking to?) Thanks!!

Setting Up SQL 2005 Linked Server Connecting To A DB2 Database

Hi,

I have setup a linked server to a DB2 database using "Microsoft OLE DB  Provider for ODBC Drivers",

the connections works fine i am able to run select queries.

but the number of rows returned from the two following statements are different.

select * from linkedserver...tablename

select count(*) from linkedserver...tablename

e.g. The First statement returns  116 rows, whereas the second query returns count as 144....

I am a bit confused ?????

could anybody think of any possible reasons..

Cheers

ARAW012 

Data Access :: Setting Up Oracle Linked Server

I have a requirement to set up an Oracle linked server, Ive never done this before and in fact never touched Oracle so I dont really know what I am doing.

Instructions For Setting Up A Sybase ASE Server As A SQL Server 2005 Linked Server?

I have a Sybase Adaptive Server Enterprise server which I need to set up as a linked server in SQL Server 2005.  The Sybase server is version 12.5.2, and the Sybase ODBC driver version is 4.20.00.67.  I have already installed the Sybase client software on the server.


I also created a SystemDSN on the SQL Server to connect to the Sybase server.  I tested the connection and it was able to connect.

I ran the following code to create the linked server:

<code>

EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServerName', @srvproduct=N'Sybase', @provider=N'MSDASQL', @datasrc=N'Sybase System DSN', @provstr=N'"Provider=Sybase.ASEOLEDBProvider;Server Name=servername,5000;Initial Catalog=databasename;User Id=username;Password=password"'

</code>

I then ran sp_tables_ex to make sure I could view the tables in the Sybase database.  Here is the error message I get:

<code>

OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[DataDirect][ODBC Sybase Wire Protocol driver]Error parsing connect string at offset 13. ".

Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName".

</code>

Any ideas what is happening here?

Setting Up Oracle Linked Server : Need Help : Sql2005 Running On XP Linking In Oracle 10.2

Is there any step by step help sites for setting up SQL 2005 linked (oracle 10) server?

I find MSDN articles but they referance winNT and 2000, I'm not getting very far and I'm not a DBA but need to get this working asap.

Linked Server ( Not Able To Access Any Tables Under LINKED SERVER From My DESKTOP Enterprise Manager

Hi ,
On my Desktop i registered Production Server in Enterprise Manager
on that Server if i go to SecurityLinked Servers
There is another Server is already mapped, when i am trying to see the Tables under that one of the
Linked Server i am getting the Error message saying that
"Error 17 SQL Server does not exist or access denied"

if i went to Production Server location and if i try to see the tables i am able to see properly, no problems
why i am not able to see from my Desk top
i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER)

And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem
What might the Problem how can i see the Tables in Linked Server from my DESKTOP

Thanks

DB Engine :: How To Point Linked Server To Specific Database / Rename Linked Server

I am using Linked Server in SQL Server 2008R2 connecting to a couple of Linked Servers.

I was able to connect Linked Servers, but I cannot point to a specific database in a Linked Server, also, I cannot rename Linked Server's name.

How to point the linked server to a specific database? How to rename the Linked Server?

The following is the code that I am using right now:

USE [master]
GO
EXEC master.dbo.sp_addlinkedserver
    @server = N'Machine123Instance456',
    @srvproduct=N'SQL Server' ;
GO
EXEC sp_addlinkedsrvlogin 'Machine123Instance456', 'false', NULL, 'username', 'password'  

Scripting Stored Procedure Add With Linked Server Reference When Linked Server Is Not Available

Is there a way to bypass the syntax checking when adding a stored procedure via a script?

I have a script that has a LINKed server reference (see below) .

INSERT
INTO ACTDMSLINKED.ACTDMS.DBO.COILS ..etc.

ACTDMSLINKED does not exist at the time I need to add the stored procedure that references it.

PLEASE to not tell me to add the LINK and then run the script. This is not an option in this scenerio.

Thanks,

Terry

Setting Timeout In ASP.NET Vs Setting Timeout In SQL Server

In my ASP.NET app, I'm executing a stored procedure via a SQLCommand the searches a customer database. I believe the default timeout is 90 seconds. I'm curious of what happens to the SQL Server Stored Procedure after timing out from the ASP.NET application. Does it timeout at the same time or do you have to set up a value in SQL Server?

Setting Up Replication On SQL Server 2000 Using Distributor Running On SQL Server 2005

Hi

I have a setup where I need to replicate the database which is actually subscribing from another database. The current setup is all in SQL Server 2000. I need to now setup a Distrbutor on a SQL server 2005 and publish the database using this distributor to another server on SQL server 2000.



Has anybody done this before. If yes what will I need to check. Can you please let me know :-



1) SQL Server 2000 which SP should be installed to support this enviroment.

2) SQL Server 2005 which SP should be installed to support this environment.

3) Any thing that I need to look out for.



Thanks for any inputs on this.



Regards

Setting Back Up Sql Server Express And The Sql Server Management Studio

I am having a nightmare of a time with my Sql Server 2005 Express. My computer crashed on Friday the 13th - of course. I saved all my files onto another drive and wiped out C: I brought everything back in but I started a new file for my Visual Basic projects. After asking questions I found this was a major no-no So I brought my original folder back in. This solved some of my problems I was having with Visual Studio and Visual Web, but I am continuing to have problems with Sql Server. I will explain these two problem they may be related, I don't know. When I run my Visual Website on a server I get this message:

An attempt to attach an auto-named database for file(then my file name)failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

And my second problem is when I attempt to run Sql Server Management Studio Express I get this error message:

There is no editor available for (then my file name) .mdf

Make sure the application for file type(.mdf)is installed.

Setting Up An SQL Server

Hello, Iam new at this SQL stuff and want to setup an SQL Server at work and need to know what do i need to use this software. I have a EVAL version of 6.5 and was told you need MSACCES or Visual Basic. Is there anything else that i need to use this? Thanks!!

Setting Up SQL Server

What is the best way to set up a sql server db that will be accessed via web(asp/ado) and windows (vb/ado) environemnts. I am concerned with security and authentication.

Thanks!

Setting Server Name In Trace

I am working with 3 sql 7.0 servers (Servers A, B, C) and am trying to create a trace via profiler to run against server B.

Every trace that I create keeps pointing to server A even though I have server B defined in the properties of the trace - (when I edit the trace properties it REALLY does show server B). I have server B defined in the screen where you 'Select the SQL Server to run the trace on'. I even used the wizard to run one of the canned traces and it still points to server A. Every trace I set up runs against server A. Can anyone think of what the heck I'm doin' wrong? Is is a configuration setting somewhere?

Setting Up NT Security In SQL Server 7

Does anyone know the best way to set up NT security. It seems a little confusing as to how to set up NT groups and assign permissions (where do the roles come into it?).

Any help would be much appreciated

thanks

Paul

Setting Up Email With SQL Server 7.0

Is there anyway to set up SQLMail without using Windows Messaging and using a MAPI Client?


Thanks,
Scott Hughes

Setting Up Database On A New Server

Hi,

There has been a lot of discussion about moving single databases or devices in same server. Can someone suggest the most simplest method to set up a identical server with all the logins, permissions and password etc?

Building a new server with sp_help_revdatabase and dumps/loads is relatively easy but moving the master is confusing to me. I should run the new server and databases for a little testing period (with diffrent server name, of course) and then go live by dropping the old and by adding the new. I remember someone said that this would be as easy as copying master.dat to new machine (when servers are identical), any experience or other suggestions?

TIA,
Al

Setting Up OLAP Server: Need Help!

:eek:
I am having trouble setting my SQL databases up as analysis services databases in SQL Server '05. Does anyone know how to help me???? I have lots of cubes to build, but I can't get the datasources there.
Thanks much for any advice.
mbunch@bighammer.com

How To Change SQL Server Setting So That It Allows

How to change SQL Server setting so that it allows remote control?

Help With Setting Up SQL Server Express.

How do I find out what port my server is listening on? I'm trying to connect to my database locally to install Vignette Portal. And no matter what I try, nothing works. I think it is listening on port 1433. But there is no way to be sure. Should something come up if I hit localhost:1433 in my browser? Because, when I do that, nothing comes up.

Please help.

Registry Key Setting For MS SQL Server

I am installing my application thru Installshield Professional 5. Howto know whether MS SQL Server is installed or not on the machine onwhich i am installing my application. What is the registry key thruwhich we can find this.

Setting Up New SQL Server System.

Hi all,


I am soon to be setting up a new server that is to have SQL Server 2005 on it.

The server has 2 x Quad Core Xeon CPUs, 16Gb of RAM and 2x73Gb HDDs in RAID1 configuration - the whole running under Windows Server 2003 x64. (The data will be on an external RAID disk array, so the 73Gb is just for the O/S and utils.)


I was reading that Windows will, by default, create a page file of (RAM size) + 1Mb, though my old-school education says use a page file of 1.5 times the RAM size. Then again, 16Gb is a whole pile of RAM and do I really want a page file of 24Gb when I only have 73Gb of HD space..? Is it worth partitioning the HDD into two or just leave it whole?


I'm looking for guidance from knowledgeable types (that's you chaps) who could offer advice on how best to implement SQL Server on a system of this spec.

I've also thought about assigning different processor affinitie to Analysis Services and the Database Engine - does anyone have any strong thoughts either way on the benefits of this?


Many thanks,
Robo

Is It Secure Setting FTP On Server

Is it secure setting ftp on the server so that i can use this ftp task in ssis.

I want to get some files located on the sever to my machine.

right now it does not work.

Is it safe setting ftp on the server???????

Setting Up An Sql Server To Allow Remote Connections To It

I have a database on my computer with a series of tables in it.
I have sql server management studio express 2005 handling them.
How would I make it so I can access the database remotely, over the internet (a non-local network)

Setting The Server&#39;s Clock Back

How does SQL Server respond when the NT Server's clock is set to a time that is earlier than the current time? Someone on my team seems to think that this is a problem for SQL Server, but I am not sure.

SQL Server 7.0 And Setting Column Privileges

How do you set column privileges in the SQL Server 7.0’s Enterprise Manager. It was so easy in 6.5’s but now it seems that the only way to do it is through the stored procedure.

Hash Bucket Setting For Server With 1 Gig Of RAM ?

Need Help In Setting Up Sql Mail On Sql Server 2000

Iam not sure why Iam not able to successfully set up sql mail. here are the steps I follow:

1. I Created a user account and password to be used for sql server and sql agent as a service account.( Domain Namesqlservice )
2. Logged off window 2000 then log in with the same account I created in step one.
3. double clicked mail icon in control panel to set up a mail account by specifying the following:
pop :pop.erols.com
smtp: smtp.erols.com
I choose POP instead of IMAP to set up the mail account
4.tested the account by opening Outlook and was able to send and recieve mail via Outlook.

So far so good
I assume that I have already (a)created a service account to be used for sql server and sql agen mail account (b) created a mail account (c)tested the mail.
5. I opened sql server and clicked on the mail in the management console to test the sql mail by typing the same mail account in the text box, then clicking test.... I got an error message the MAPI is not set up and it is not connecting to any profile.

another error I got was Error :xp_mapi profile : failed with mail error 0x80040106
Here are some questions that I am not sure about.
Q1. Do I need to set up smtp service in service tab to use same account as sql server/ sql agent. It is using local system account now
Q2. the above steps are correct, I guess so, so what is the reason not being able to set up the mail profile to be used by sql server mail

Thanks for your help
Ali

Setting Up A Testing Server To MS SQL Using Dreamweaver MX

Hi,
I'm new to the whole MS SQL server thing, have been using Access in past developments via the development platform in Dreamweaver.

Now I'm making the leap to MS SQL and still want to use Dreamweaver to handle some of the development aspects, does anyone know how or what i would need to do to have a direct connection with the server in dreamweaver?

I've setup an ODBC connection with my hosting providers already.

THANKS!

SQL Server 2008 :: Min And Max Memory Setting

I have an issue with my production server regarding memory usage (Memory Utilization is above 95%.). Memory is : 12 GB and the service that is consuming the majority of memory 88%/10.5GB is sqlserver.exe. So it would appear that MSSQL is not set to restrict the amount of memory it uses ? How much should I set for min and max memory ? the defauld is min memory : 0 and max : 2 TB

Assistance Setting Up Master Job Server

What considerations do I need to take into account if trying to enlist a server into a master server when (a) both instances are on different physical servers and the SQL Server and SQL Server Agent services run under different domain accounts?

The reason I ask is when attempting to create a master server through the SSMS wizard, I receive these errors:


Enlist TSX Progress

- Create MSXOperator (Success)
* Checking for an existing MSXOperator.
* Updating existing MSXOperator.
* Successfully updated MSXOperator.

- Make sure the Agent service for 'MYMSXINSTANCE' is running (Error)
Messages
* An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)

- Ensure the agent startup account for 'MYTSXINSTANCE' has rights to login as a target server (Error)
* Checking to see if the starup account for 'MYTSXINSTANCE' already exists.
Messages
* An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)

- Enlist 'MYTSXINSTANCE' into 'MYMSXINSTANCE' (Error)
* Enlisting target server 'MYTSXINSTANCE' with master server 'MYMSXINSTANCE'.
* Using new enlistment method.
Messages
* MSX enlist failed for JobServer 'MYTSXINSTANCE'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=MSX+enlist+JobServer&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'MYMSXINSTANCE'.) (Microsoft SQL Server, Error: 22026)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476


Now, the first two errors are what are puzzling me. I'm certain I can address the third and last error by making the accounts the SQL Server Agent services run as the necessary SQL permissions on each instance.

I've tried making NT AuthoritySYSTEM accounts on both servers, no luck. Any suggestions?