473,574 Members | 2,777 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 2600
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
1611
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
2101
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
2204
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...
4
1601
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...
5
12918
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...
1
2881
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
1625
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
4075
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 =...
0
7813
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...
0
8066
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. ...
0
8106
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...
0
6461
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...
0
5305
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3743
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...
0
3755
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1350
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1066
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...

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.