473,851 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Developer Edition having issues connecting to server via TCP/IP

Don't know if there is a simple solution for this one or not. When
running SQL server on a machine with 2000 loaded and the complete SQL
package I don't have any issues. Now I'm trying to login using my XP
machine with MSSQL developer edition, and I can not connect to my
remote servers via TCP/IP. It can see the server, and it establishes a
connection, but I can't access my files, and the connection seems
incredibly slow. I have checked my firewall, and its fine. I'm just
wondering why my 2000 system can access it, but my XP can't. Any
ideas???

Jun 26 '06 #1
3 2642
Chris (ch***********@ kenblanchard.co m) writes:
Don't know if there is a simple solution for this one or not. When
running SQL server on a machine with 2000 loaded and the complete SQL
package I don't have any issues. Now I'm trying to login using my XP
machine with MSSQL developer edition, and I can not connect to my
remote servers via TCP/IP. It can see the server, and it establishes a
connection, but I can't access my files, and the connection seems
incredibly slow. I have checked my firewall, and its fine. I'm just
wondering why my 2000 system can access it, but my XP can't. Any
ideas???


I'm confused, can't you connect at all, or is the communication just slow?

On which machine does the SQL Server you are connecting to run? Is the XP
machine in the same domain as the SQL Server machine?

What files are you unable to access? You usually don't use SQL Server
to access files.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 26 '06 #2
Erland Sommarskog wrote:
Chris (ch***********@ kenblanchard.co m) writes:
Don't know if there is a simple solution for this one or not. When
running SQL server on a machine with 2000 loaded and the complete SQL
package I don't have any issues. Now I'm trying to login using my XP
machine with MSSQL developer edition, and I can not connect to my
remote servers via TCP/IP. It can see the server, and it establishes a
connection, but I can't access my files, and the connection seems
incredibly slow. I have checked my firewall, and its fine. I'm just
wondering why my 2000 system can access it, but my XP can't. Any
ideas???


I'm confused, can't you connect at all, or is the communication just slow?

On which machine does the SQL Server you are connecting to run? Is the XP
machine in the same domain as the SQL Server machine?

What files are you unable to access? You usually don't use SQL Server
to access files.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

I can connect to the server, but it is slow. But I can't access
information such as the databases. It comes up with no items. I also
can't backup any of the data to a local machine. There wasn't any
issue until we loaded the 2003 Developer Edition on our XP machines.
I've loaded both service packs 3 and 4 hoping that would solve the
problem. I've checked TCP/IP setting, and the firewall.

The server I'm trying to access is a remote server running Windows
2000, with service pack 4, and it is in a different domain.

Jun 26 '06 #3
Chris (ch***********@ kenblanchard.co m) writes:
I can connect to the server, but it is slow. But I can't access
information such as the databases. It comes up with no items. I also
can't backup any of the data to a local machine. There wasn't any
issue until we loaded the 2003 Developer Edition on our XP machines.
I've loaded both service packs 3 and 4 hoping that would solve the
problem. I've checked TCP/IP setting, and the firewall.

The server I'm trying to access is a remote server running Windows
2000, with service pack 4, and it is in a different domain.


I realise that I should have asked what you are connecting with and
with which credentials.

From what you say, it sounds as it you connect with Enterprise Manager
with integrated security, but your Windows login has not been added to
BUILTIN\Adminis trators and on top of all databases are set to autoclose.
When databases are set to autoclose, and you connect as a non-priv user,
EM has to access every database to see if you are permitted, and this
can take forever.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 27 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1623
by: Greg | last post by:
I'm trying to install a default instance of Developer edition on a laptop. I'm getting the following promblems shown in sqltp log. The laptop has previously had the SQL Developer installed but has since had OS installed. I've tested named pipes to another server (net view, net use) and it seems to be working. any ideas ?
4
2115
by: Shyguy | last post by:
I have a small app that I want to distribute to users of various Operating systems from 97 to XP. Does the latest edition of Developer Edition contain the runtimes for all previous versions or do I need to get the Developer Edition for each version? Thanks for any info. ShyGuy
16
2229
by: deko | last post by:
Is there any reason, other than the distributable Access runtime, to use Office XP developer? I tried installing it on my system, but apparently I need to install/update a bunch of components - "Windows Component Update" or something... not sure I want to do this. What can I do with the Developer edition that I can't do with the Professional edition? I found this on the net, but it sounds like marketing hype:
4
1627
by: T Martin | last post by:
We have a database that we would want to deploy among 6-10 users to access. They don't need to edit the design of the application, but I would need to be able to customize the application on occasion to met some of the users requirements. We were considering purchasing Access for each user, but I was wondering if the Access Developer's version would be sufficient for our needs. What are the pros/cons for using the Developer's Edition...
5
12937
by: Jim Devenish | last post by:
I am having some problems in the process of moving an Access back-end to an SQL Server back-end. Everything works but there are severe problems of response times when the number of users builds up. At present we are using the Developer version before committing to the Enterprise version. BOL (quoted below) seems to suggest that, apart from licensing, they are the same. Can anyone please confirm that this is so. If not, what is the...
1
2885
by: adi8085 | last post by:
hello there, i m having windows xp 2002 sp2 version, i want to know whether i will be able to install ms sql server 2005 developer edition on it or there will be some problems . i heard that ms sql server 2005 developer edition requires 512MB of RAM, but i m using 256MB RAM only. is there any one who could help me on this ?? thanks
0
1643
by: antonyliu2002 | last post by:
I am having a hard time connecting to an oracle database from within Visual Web Developer (VWD) 2005 Express Edition. Check out the screen snap shot here: http://static.flickr.com/97/241874792_aebbadac2b_o.gif Here is the situation: 1. The oracle database runs on Machine A.
10
4099
by: khalid galal | last post by:
Hi, i am having a problem with connecting ASP with MSSQL SEVER 2005 EXPRESS EDITION, i am writing ASP code using javascript. look at this peace of code: var myConnect = "Provider=SQLNCLI;Data Source=.\SQLEXPRESS;Initial Catalog=quiz;User ID=factory1;Password = 123;"; var ConnectObj = Server.CreateObject("ADODB.Connection"); var RS = Server.CreateObject("ADODB.Recordset"); var sql="select * from .dbo.Question"; ...
0
9897
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...
0
11019
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10670
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10728
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
10356
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
9506
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
7906
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...
2
4143
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3179
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.