| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2005-02-23 : 12:11:00
|
| Got some bizzare things happening.I have server's registered and have had no problems connecting to them with EM, QA, ect.I have 2 clients, 1 XP, 1 2000, and niether can connect. A coworker has xp and a new laptop and has no problem. Another coworker (java developer) just got the same exact machine and has my connectivity problem.Server Ops is in the process of a NT - 2003 migration. None of my NT servers have this problem.A 2003 default instance doesn't have this problem either, only named instances.Yet when I use an alias, there's no problem.But I don't want to use an alias. Also the problem seems to come and go.Any ideas?Everything seems to point that it's my client. Maybe it's a registrey thing, but why would it happenBrett8-) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-02-23 : 15:48:12
|
Too much of a mystery, huh.... Brett8-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-23 : 15:50:38
|
| I don't understand why you don't want to use an alias. I would guess that your client machine is not able to figure out what port the instance is listening on. Not sure how to make it smarter except with an alias. The registry thing would be an alias.Tara |
|
|
|
wayxiu
Starting Member
3 Posts |
Posted - 2005-02-23 : 22:40:27
|
| I have a problem . it define difficult .My Application had used VB6 and SQL Server 2000. My Application run database on SQl Server . when my Aplication (client) connect to SQl server . it can not connect to sql server . but when client log on to server Exam: " \\server " then my Application can connect to database on Sql server. and when i log off or shut down client. Next time i must log on server "\\server" . so i can connect to database on sqlserver . if not , my Application can not connect to sql server.who can help me ! thanks |
|
|
|
wayxiu
Starting Member
3 Posts |
Posted - 2005-02-23 : 22:52:02
|
| I don't know why? Anybody can help us.Thanks. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-02-24 : 11:06:20
|
quote:
Originally posted by tduggan
I don't understand why you don't want to use an alias. I would guess that your client machine is not able to figure out what port the instance is listening on. Not sure how to make it smarter except with an alias. The registry thing would be an alias.Tara
Well I got a guy "near shore" (They drink a lot of guiness) that was using an Access mdb to connect via ODBC and now can't as well, so the alias wouldn't help him either.NOTE: His Access Data Project I gave him has no problems. Same Server, same DBBrett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
wayxiu
Starting Member
3 Posts |
Posted - 2005-02-24 : 21:57:45
|
| thanks X002548 but if this problem is Windows 2000 server You can help me detail, about document or link |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-03-01 : 12:45:17
|
| I believe it's 2003Brett8-) |
|
|
|
|
Connection Failed