SQL Server 2000 and Windows Server 2003

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • df
    #1

    SQL Server 2000 and Windows Server 2003

    I have several database on a Windows Server 2003. I re-registered this SQL
    server, which is local, and after that I cannot see any of the databases in
    the Enterprise Manager. The databases still work, since my applications work
    fine. I have no clue how can I make these databases visible in Enterprise
    Manager. I tried registering this SQL Server in Enterprise Manager under
    Windows accounts and SQL Server accounts. Nothing works.
    Can anybody help?


    Tags: None
    • Erland Sommarskog
      #2
      Re: SQL Server 2000 and Windows Server 2003

      df (df@df.com) writes:[color=blue]
      > I have several database on a Windows Server 2003. I re-registered this
      > SQL server, which is local, and after that I cannot see any of the
      > databases in the Enterprise Manager. The databases still work, since my
      > applications work fine. I have no clue how can I make these databases
      > visible in Enterprise Manager. I tried registering this SQL Server in
      > Enterprise Manager under Windows accounts and SQL Server accounts.[/color]

      I have no idea, but my guess is that you registered as a user that
      does not have permission to these databases, and not as a user
      that has admin priviledges.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server SP3 at
      Microsoft SQL Server
      http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
      Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

        Comment

        • Aquila Deus
          #3
          Re: SQL Server 2000 and Windows Server 2003

          df wrote:[color=blue]
          > I have several database on a Windows Server 2003. I re-registered[/color]
          this SQL[color=blue]
          > server, which is local, and after that I cannot see any of the[/color]
          databases in[color=blue]
          > the Enterprise Manager. The databases still work, since my[/color]
          applications work[color=blue]
          > fine. I have no clue how can I make these databases visible in[/color]
          Enterprise[color=blue]
          > Manager. I tried registering this SQL Server in Enterprise Manager[/color]
          under[color=blue]
          > Windows accounts and SQL Server accounts. Nothing works.
          > Can anybody help?[/color]

          The account you use in Enterprse Manager probably has no admin
          permission. Did you try "sa"? If your SQL Server doesn't allow SQL
          login you need to RTFM and enable it.

            Comment

            • df
              #4
              Re: SQL Server 2000 and Windows Server 2003

              Tried "sa", the same story. Tried Windows auth., no diff.
              Only default databases are visible.

              "Aquila Deus" <aquila.deus@gm ail.com> wrote in message
              news:1112170808 .553461.149460@ f14g2000cwb.goo glegroups.com.. .[color=blue]
              > df wrote:[color=green]
              >> I have several database on a Windows Server 2003. I re-registered[/color]
              > this SQL[color=green]
              >> server, which is local, and after that I cannot see any of the[/color]
              > databases in[color=green]
              >> the Enterprise Manager. The databases still work, since my[/color]
              > applications work[color=green]
              >> fine. I have no clue how can I make these databases visible in[/color]
              > Enterprise[color=green]
              >> Manager. I tried registering this SQL Server in Enterprise Manager[/color]
              > under[color=green]
              >> Windows accounts and SQL Server accounts. Nothing works.
              >> Can anybody help?[/color]
              >
              > The account you use in Enterprse Manager probably has no admin
              > permission. Did you try "sa"? If your SQL Server doesn't allow SQL
              > login you need to RTFM and enable it.
              >[/color]


                Comment

                • df
                  #5
                  Re: SQL Server 2000 and Windows Server 2003

                  When I looked in the Windows services I see another instance of SQL Server
                  running. There are the following services:
                  MSSQL$DELLSRV
                  MSSqlSever

                  I have no clue how this could happen. But the question is how can I get to
                  the old instance???

                  "Aquila Deus" <aquila.deus@gm ail.com> wrote in message
                  news:1112170808 .553461.149460@ f14g2000cwb.goo glegroups.com.. .[color=blue]
                  > df wrote:[color=green]
                  >> I have several database on a Windows Server 2003. I re-registered[/color]
                  > this SQL[color=green]
                  >> server, which is local, and after that I cannot see any of the[/color]
                  > databases in[color=green]
                  >> the Enterprise Manager. The databases still work, since my[/color]
                  > applications work[color=green]
                  >> fine. I have no clue how can I make these databases visible in[/color]
                  > Enterprise[color=green]
                  >> Manager. I tried registering this SQL Server in Enterprise Manager[/color]
                  > under[color=green]
                  >> Windows accounts and SQL Server accounts. Nothing works.
                  >> Can anybody help?[/color]
                  >
                  > The account you use in Enterprse Manager probably has no admin
                  > permission. Did you try "sa"? If your SQL Server doesn't allow SQL
                  > login you need to RTFM and enable it.
                  >[/color]


                    Comment

                    • Aquila Deus
                      #6
                      Re: SQL Server 2000 and Windows Server 2003

                      df wrote:[color=blue]
                      > When I looked in the Windows services I see another instance of SQL[/color]
                      Server[color=blue]
                      > running. There are the following services:
                      > MSSQL$DELLSRV
                      > MSSqlSever
                      >
                      > I have no clue how this could happen. But the question is how can I[/color]
                      get to[color=blue]
                      > the old instance???[/color]

                      Depends on the network interface you configured for the two instances.
                      The default share memory is exclusive and can't be used by both (and
                      you may not be able to know who uses it exactly), so I suggest you to
                      enable named pipe for them, and re-register them in Enterprise Manager
                      by the named pipe path you set.

                        Comment

                        • Erland Sommarskog
                          #7
                          Re: SQL Server 2000 and Windows Server 2003

                          df (df@df.com) writes:[color=blue]
                          > When I looked in the Windows services I see another instance of SQL Server
                          > running. There are the following services:
                          > MSSQL$DELLSRV
                          > MSSqlSever
                          >
                          > I have no clue how this could happen. But the question is how can I get to
                          > the old instance???[/color]

                          So you have two instances of SQL Server on your machine, and you have
                          connected to the one that does not have any databases.

                          To connect to the default instance, specify "." or servername. To
                          connect to the other, specify ".\DELLSRV" or "servername\DEL LSRV".

                          You might also want to check the Client Network Utility whether you
                          have any aliases.


                          --
                          Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

                          Books Online for SQL Server SP3 at
                          Microsoft SQL Server
                          http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
                          Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

                            Comment

                            • df
                              #8
                              Re: SQL Server 2000 and Windows Server 2003

                              Thanks,

                              I have fixed the problem. I suspect that when I installed service packs, it
                              created the second instance, since I did not do it explicitly. I shut it
                              down, and registered the original one.


                              "Erland Sommarskog" <esquel@sommars kog.se> wrote in message
                              news:Xns9629EB8 19DA24Yazorman@ 127.0.0.1...[color=blue]
                              > df (df@df.com) writes:[color=green]
                              >> When I looked in the Windows services I see another instance of SQL
                              >> Server
                              >> running. There are the following services:
                              >> MSSQL$DELLSRV
                              >> MSSqlSever
                              >>
                              >> I have no clue how this could happen. But the question is how can I get
                              >> to
                              >> the old instance???[/color]
                              >
                              > So you have two instances of SQL Server on your machine, and you have
                              > connected to the one that does not have any databases.
                              >
                              > To connect to the default instance, specify "." or servername. To
                              > connect to the other, specify ".\DELLSRV" or "servername\DEL LSRV".
                              >
                              > You might also want to check the Client Network Utility whether you
                              > have any aliases.
                              >
                              >
                              > --
                              > Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
                              >
                              > Books Online for SQL Server SP3 at
                              > http://www.microsoft.com/sql/techinf...2000/books.asp[/color]


                                Comment

                                • Erland Sommarskog
                                  #9
                                  Re: SQL Server 2000 and Windows Server 2003

                                  df (df@df.com) writes:[color=blue]
                                  > I have fixed the problem. I suspect that when I installed service packs,
                                  > it created the second instance, since I did not do it explicitly. I shut
                                  > it down, and registered the original one.[/color]

                                  I don't know which of the instances was the unexpected one, but it
                                  could be an MSDE instance that slipped in with some 3rd party software.
                                  DELLSRV hints a certain vendor.


                                  --
                                  Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

                                  Books Online for SQL Server SP3 at
                                  Microsoft SQL Server
                                  http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
                                  Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

                                    Comment

                                    • df
                                      #10
                                      Re: SQL Server 2000 and Windows Server 2003

                                      DELLSRV is my server name, I named it this way, no mistery here, it's DELL
                                      server.

                                      "Erland Sommarskog" <esquel@sommars kog.se> wrote in message
                                      news:Xns962A5F6 E379A3Yazorman@ 127.0.0.1...[color=blue]
                                      > df (df@df.com) writes:[color=green]
                                      > > I have fixed the problem. I suspect that when I installed service packs,
                                      > > it created the second instance, since I did not do it explicitly. I shut
                                      > > it down, and registered the original one.[/color]
                                      >
                                      > I don't know which of the instances was the unexpected one, but it
                                      > could be an MSDE instance that slipped in with some 3rd party software.
                                      > DELLSRV hints a certain vendor.
                                      >
                                      >
                                      > --
                                      > Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
                                      >
                                      > Books Online for SQL Server SP3 at
                                      > http://www.microsoft.com/sql/techinf...2000/books.asp[/color]


                                        Comment

                                        Previous template Next
                                        Working...