mssql8 AND mssql 2005

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kitspid
    New Member
    • Sep 2007
    • 8

    #1

    mssql8 AND mssql 2005

    I have both 8 and 2005 installed on a windows 2003 server. However from a remote machine I can only see the 2005 instance. Is there a configuration I have missed or is this not possible?
  • davef
    New Member
    • Sep 2007
    • 98

    #2
    Are you using SQL Server 2005 Management Studio to connect to a remote database engine? If so, you may wanna try to select <Browse for more...> option from the Server Name dropdown list and then switch to the Network Servers tab. Let me know how you're getting along.

    Comment

    • kitspid
      New Member
      • Sep 2007
      • 8

      #3
      I can see both instances on the Windows 2003 system and can connect to the v8 thru sql server management as you suggest. My issue is a remote machine with only 8's client cannot connect to the mssql v8 instance.

      Comment

      • davef
        New Member
        • Sep 2007
        • 98

        #4
        Are you getting any error at all? Try to quickly create a .udl file on the remote machine to see if you could make and test a connection to the server.

        Comment

        • kitspid
          New Member
          • Sep 2007
          • 8

          #5
          I get a server not found message.

          Comment

          • davef
            New Member
            • Sep 2007
            • 98

            #6
            How did you name your 2000 and 2005 instances on the same box?

            Comment

            • kitspid
              New Member
              • Sep 2007
              • 8

              #7
              2005 = server
              other is server\server20 03

              Comment

              • davef
                New Member
                • Sep 2007
                • 98

                #8
                And server\server20 03 is not visible from 2000 client, right?

                Comment

                • kitspid
                  New Member
                  • Sep 2007
                  • 8

                  #9
                  Yes. I wonder if I should name it something else maybe it doesn;t like that name. Maybe OldSQL?

                  Comment

                  • davef
                    New Member
                    • Sep 2007
                    • 98

                    #10
                    Originally posted by kitspid
                    Yes. I wonder if I should name it something else maybe it doesn;t like that name. Maybe OldSQL?
                    Try to name it without slash. I doubt though it'll help. I once experienced a very funny problem with my replication whereby the distributor wouldn't connect to the subscriber. I had to enable Naming Pipes on the subscriber via the SQL config console to fix it. Just a thought.

                    Comment

                    • kitspid
                      New Member
                      • Sep 2007
                      • 8

                      #11
                      Tried the name pipes didn;t help. Don;t think I can rename it as the machine is called server which is where that comes from shoulf just be server2003 to connect. Going to move this db to a different machine and not worry about it anymore. Chalk it up to a 2005 quirk I think.

                      Comment

                      • kitspid
                        New Member
                        • Sep 2007
                        • 8

                        #12
                        Thanx for your help anyway.

                        Comment

                        • davef
                          New Member
                          • Sep 2007
                          • 98

                          #13
                          Good luck to you. Sorry couldn't help you better. Try to search in MSDN troubleshooting articles.

                          Comment

                          • kitspid
                            New Member
                            • Sep 2007
                            • 8

                            #14
                            I had to change the port for the mssql8 version to get it to work.

                            Comment

                            Working...