Thanks for the follow up. The subject installation is a small experimental system I’m working on
partly to gain some knowledge and experience with Team Foundation and SQL Server.
Unfortunately, I have not had any time to devote to this in the last few days.
I’ll take a look at this over the weekend.
I’m issuing the sqlcmd command from an RDP session (logged on with and administrative user account)
of the server that is running SQL Server, NOT from another server. I will try logging on at the
console of that server, but I can’t see that making any difference.
As to your questions:
1.. Don’t know – never tried
2.. I believe so, but will verify
3.. Never tried – I use the SQL Server Management Studio only from an RDP session (logged on with
and administrative user account) of the server running SQL Server
--
Bruce Sanderson
http://members.shaw.ca/bsanders/
It's perfectly useless to know the right answer to the wrong question.
""Charles Wang [MSFT]""
online.microsoft.com> wrote in message
news:NW8xPSG8IHA.4912@TK2MSFTNGHUB02.phx.gbl...> Hi Bruce,
> I understand that you could not connect to your SQL Server 2005 instance from another
> Windows Server 2008 server.
> If I have misunderstood, please let me know.
>
> To narrow down this issue, would you mind first answering me the following two questions?
> 1. Did this issue happen before you change the database files location?
>
> 2. Did you try the steps of "Enable the SQL Server Browser service" and "Create exceptions in
> Windows Firewall" in the KB article,
http://support.microsoft.com/kb/914277/en-us? If not,
> please try it first.
>
> 3. Could you connect to your SQL Server 2005 instance from SQL Server Management Studio
> on your remote client server?
>
> Generally regarding the error message, there are several typical causes that documented in
> this article,
http://msdn.microsoft.com/en-us/library/ms190181.aspx. I recommend that you
> refer to the section "Typical Causes of this Error" and check if the resolutions work for you.
>
> Please feel free to let me know if you have any other questions or concerns. Have a nice day!
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ===========================================================
> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@
microsoft.com.
> ===========================================================
> Get notification to my posts through email? Please refer to
>
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.
>
> Note: The MSDN Managed Newsgroup support offering is for
> non-urgent issues where an initial response from the community
> or a Microsoft Support Engineer within 1 business day is acceptable.
> Please note that each follow up response may take approximately
> 2 business days as the support professional working with you may
> need further investigation to reach the most efficient resolution.
> The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by
> contacting Microsoft Customer Support Services (CSS) at
>
http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ============================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
> =========================================================
>
>
>
