473,698 Members | 2,615 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Connecting to an SQLServer

19 New Member
Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.

Thanks,
Mar 12 '08 #1
9 1567
FredSovenix
10 New Member
Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.

Thanks,
First, you need to resolve any connectivity issues between the two servers. Is the remote SQL server on a host that can be resolved via DNS, or do you have to specify an IP address? Are they on the same subnet? Is the remote server listening on port 1433 for requests (Network Configuration applet)?

If you only have an IP address, then I suggest using the Client Configuration applet to create an alias for the remote server and map it to the IP address and port number.

Once your connectivity issues are resolved, adding a linked server is a snap; if they are in different domains that have no trust relationship, you have to use native SQL server authentication; otherwise, if one server can access the same Active Directory as the other, you can use Windows authentication.

Hope this helps. Please post additional details if you need additional help.

Cheers!
Mar 13 '08 #2
ck9663
2,878 Recognized Expert Specialist
Can someone please explain me how to connect from my SQLServer to a remote SQLServer. Both the servers are 2000. I have tried linked servers but it is quite confusing.

Thanks,
Are you trying to connect inside an sp? from sql server console (enterprise manager)? query analyzer?

-- CK
Mar 13 '08 #3
raviva
19 New Member
Are you trying to connect inside an sp? from sql server console (enterprise manager)? query analyzer?

-- CK
I am trying to connect from enterprize manager...
Mar 17 '08 #4
ck9663
2,878 Recognized Expert Specialist
You have to register the new server.

-- CK
Mar 17 '08 #5
raviva
19 New Member
You have to register the new server.

-- CK
Thanks. However, can you a bit more specific. I have added a new datasource, but of no use. I have the IP address of the other server.

Thanks
Mar 17 '08 #6
ck9663
2,878 Recognized Expert Specialist
1. Open your enterprise manager
2. Expand your sql servers
3. Right-click on of the groups
4. Choose New SQL Server Registration
5. Follow the instruction.... ..

-- CK
Mar 18 '08 #7
raviva
19 New Member
1. Open your enterprise manager
2. Expand your sql servers
3. Right-click on of the groups
4. Choose New SQL Server Registration
5. Follow the instruction.... ..

-- CK
Thanks, but the server which I want to connect doesnt appear in the available servers list. I wonder, if I have enough data regarding that server. I know the server name, IP address. Are these parameters enough, or additional what information I need. Further, what needs to be done to appear our target server name in the available servers list. Sorry, but I am very much confused.

Thanks.
Mar 18 '08 #8
ck9663
2,878 Recognized Expert Specialist
Just type the IP or server name on the Available Server text box instead of looking for it on the listbox. Click Add.

Make sure that you are within the same network or at least your two network can communicate with each other.

- CK
Mar 18 '08 #9
raviva
19 New Member
Just type the IP or server name on the Available Server text box instead of looking for it on the listbox. Click Add.

Make sure that you are within the same network or at least your two network can communicate with each other.

- CK
Thank you very much. It worked.
Mar 21 '08 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

2
3382
by: rjp | last post by:
Hi all, I have to move my SQlServer 2000 instance from one server 'actual_server' to another server 'new_server'. But, the different applications connecting to the actual server can't easily change their connections address. i.e it connect to 'actual_server' server only. Is there a risk to declare a DNS alias 'actual_server' pointing to 'new_server' ?
2
1552
by: Jim | last post by:
I'm writing an Invoicing Windows app but I'm writing it to make the code as easy to maintain as possible. Basically, to get any records from my DB, I use two classes: one that sets up the SQL statement, and another that makes the connection (plus the class that contains the windows form). Now, is this the best way to divide my tasks? And by using this structure, how would I be able to update my dataset when I don't have direct access to...
1
966
by: Mohammad-Reza | last post by:
It is now 3 months that we are trying to connect ASP.NET to a SQLServer located on another system However we act,we get a fatal error We need someone to explain the way of connecting to SQLServer step by step from either VisualStudio.NET or FrontPage 2003 Our goal is to retrieve records from SQLServer and display them in ASP.NET pages,edit them,and return them to SQLServer Thanx in advance.
11
2422
by: Patrick | last post by:
I have an ASP.NET application that connects to a SQL Server database. The SQL Server resides on a seperate development server from the IIS5.1 on Windows XP SP2 on development PCs which host the ASP.NET application. I would like to use Integrated Windows Authentication like Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBName;Data Source=DevServer1 My problems!
12
2782
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed both the iis and sql server in a single machine. Not too long ago, the machine had some hardware problems, and management has decided to purchase new servers, for both asp.net and sql server.
2
2353
by: Jim Devenish | last post by:
I am in the early stages of converting a back-end .mdb file to SqlServer - my first attempt! I have used Data Transformation Services to copy all the tables to SqlServer into a database named JobSystem. When using Enterprise Manager, I can see all the data. So far, so good!! >From within the front-end I want to link my tables and have tried the following code: For Each tdf In CurrentDb.TableDefs
29
7050
by: Bryce K. Nielsen | last post by:
Suddenly this week, I've started getting this error message: System.Data.SqlClient.SqlConnection(GetOpenConnection)ExecuteNonQuery requires an open and available Connection. The connection's current state is connecting. I'm very puzzled since I'm not calling "ExecuteNonQuery" and I am calling "Open", which I've always assumed was Synchronous, i.e. would not return until either A) the connection was open or B) there was an error. Here...
0
3102
by: jags_32 | last post by:
Hello We use MFG-PRO as our ERP system which in turn uses Progress databases. In the old version of SQL 2000, using DTS packages, we used to set the code page via command prompts and execute DTS packages within that command prompt to fetch data from our double byte ERP databases. In SSIS, we are able to connect and fecth data from NON Double Byte databases, however, when we set the code page first and execute via a command prompt the...
6
3082
by: bill ramsay | last post by:
Hi I have successfully connected to SQL2000 and MSDEE databases in the past, however I have to move to SQL2005 and SQLEXPRESS databases now. I've tried the following but with no luck Conn = Dispatch('ADODB.Connection') Conn.ConnectionString = "Provider=SQLNCLI;Server=10.1.1.2; Database=csrctest;Uid=bill;Pwd=bill"
4
1305
by: =?Utf-8?B?Y2hyaXM=?= | last post by:
Hi, My webserver is in DMZ zone, not in domain. I created a local user on it and an application pool for assigning it to my web site (ASP.NET 2005 - IIS 6.0). The application pool has a configurable identity (Test_User) for connection to SQL server 2005. In SQL Server I created a local account (mirrored user for the one create on webserver). I create a login for this user (SQLServer\Test_User) and a database user and gave permission to...
0
8685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
8905
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8880
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7743
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6532
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4373
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4625
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3053
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2342
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.