Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2006-01-30 : 12:44:55
|
| We have several cases where clients have been upgraded from windows 2000 to windows xp.In this transformation, several users have lost connection to their favorite sql servers instances. I figured that by creating an alias, e.g qadbserver\test1 as test1 and specifying the tcp/ip port in the connection, I am able to resolve this problem. But this is extra work for our support department. Besides i don't find it specifically secure, giving out ports like that.Is there anything that I can do at server level to overcome this hurdle?you can respond at pareshmotiwala@yahoo.comthanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-30 : 13:48:52
|
| There is nothing that you can do at the database server to fix this problem. You could help out the support department by providing the reg file to add the alias so that they can add it via a login script.Tara Kizeraka tduggan |
 |
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2006-01-30 : 14:53:54
|
| thank you Tara, will try that. |
|
|
|
|
|
|
Connection to certain SQL Server 2000 instances