dbTalk Databases Forums  

SSMS 2005 on Vista SP1 can't find new named cluster instance

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SSMS 2005 on Vista SP1 can't find new named cluster instance in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ant-nee
 
Posts: n/a

Default SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 09:29 AM






All,

I have two Vista SP1 machines that have SSMS 2005 installed on them. These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS. Both
developers have permissions to connect to the instance. One developer with a
trouble PC says he can run a query against the instance from the same trouble
PC using Visual Studio 2005. I can't figure out what's going on but I need
to fix this. Any suggestions?

Reply With Quote
  #2  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM






One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #3  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #4  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #5  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #6  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #7  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #8  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #9  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
  #10  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: SSMS 2005 on Vista SP1 can't find new named cluster instance - 08-19-2008 , 11:32 AM



One possibility is loose source mapping. See the Multiple Server IP
Addresses section in Troubleshooting: Timeout Expired
http://msdn.microsoft.com/en-us/library/ms190181.aspx
Basically Vista (and Windows Server 2008) throws away UDP responses that
didn't come from the correct IP Address. (It's not a bug, it's a feature.
<g>)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Ant-nee" <Antnee (AT) discussions (DOT) microsoft.com> wrote

Quote:
All,

I have two Vista SP1 machines that have SSMS 2005 installed on them.
These
two machines (both used by developers) cannot see my new named SQL cluster
instance when trying to connect using SSMS. Every other PC in the office
with SSMS can find the instance. The two trouble machines can ping the
virtual cluster by name. They just can't pull up the instance in SSMS.
Both
developers have permissions to connect to the instance. One developer
with a
trouble PC says he can run a query against the instance from the same
trouble
PC using Visual Studio 2005. I can't figure out what's going on but I
need
to fix this. Any suggestions?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.