Wednesday, March 28, 2012

Instance

I installed a new instance on SQL 2k, but it is reading
the information about the instance has already installed.What's "it" in this context? Can you elaborate?
"Simon" <anonymous@.discussions.microsoft.com> wrote in message
news:12be601c44336$8203f950$a601280a@.phx
.gbl...
> I installed a new instance on SQL 2k, but it is reading
> the information about the instance has already installed.
>|||When you say reading information from albout the already installed instance
what do you mean?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||When I open the new instance the objects of first instance
are available. All the databases and logins.
The directory installation is different and on Data folder
there are master, model, temp and msdb databases. >--
Original Message--
>When you say reading information from albout the already
installed instance
>what do you mean?
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||<anonymous@.discussions.microsoft.com> wrote in message
news:1307601c44344$0b7b17b0$a101280a@.phx
.gbl...
> When I open the new instance the objects of first instance
> are available. All the databases and logins.
> The directory installation is different and on Data folder
> there are master, model, temp and msdb databases. >--
Please describe your exact procedure when you "open" the instance. What
client are you using (Enterprise Manager? Query Analyzer? ISQL? OSQL?
something else?), etc. Go into a lot of detail. It's probably something
subtle that you'll catch as you write up the description.|||SQL 2k Standard
On the first installation of SQL Server was created a
named instance and not a Default instance. Now during the
new instance installation when I try to install a new
instance the screen where the instance is created the
Default Instance option is enable. Then I choose a new
instance. End of installation with successfull.
The mssqlserver service is started and the two instances
are enabled.
The problem is both instance are the same. If I create a
database in the new instance it (the new database) shows
up in the first instance also.

>--Original Message--
><anonymous@.discussions.microsoft.com> wrote in message
> news:1307601c44344$0b7b17b0$a101280a@.phx
.gbl...
instance[vbcol=seagreen]
folder[vbcol=seagreen]
> Please describe your exact procedure when you "open"
the instance. What
>client are you using (Enterprise Manager? Query
Analyzer? ISQL? OSQL?
>something else?), etc. Go into a lot of detail. It's
probably something
>subtle that you'll catch as you write up the description.
>
>.
>|||Can you verify that you're actually connected to a different instance?
Please run:
SELECT @.@.SERVERNAME
And make sure the instance name is what you think it should be before you
create your database.
<anonymous@.discussions.microsoft.com> wrote in message
news:12ebd01c44354$44fc3630$a001280a@.phx
.gbl...[vbcol=seagreen]
> SQL 2k Standard
> On the first installation of SQL Server was created a
> named instance and not a Default instance. Now during the
> new instance installation when I try to install a new
> instance the screen where the instance is created the
> Default Instance option is enable. Then I choose a new
> instance. End of installation with successfull.
> The mssqlserver service is started and the two instances
> are enabled.
> The problem is both instance are the same. If I create a
> database in the new instance it (the new database) shows
> up in the first instance also.
>
>
> instance
> folder
> the instance. What
> Analyzer? ISQL? OSQL?
> probably something|||I'm connected to a new instance. And I saw all the objects
that are in old instance. The sa is the same, but I
created a sa with different password.
The default instance was not installed, only the named
instance. Is there some problem ?
Can I install a defaul instance in this moment or it is
only possible during the first SQL Server installation ?
Thanks,
>--Original Message--
>Can you verify that you're actually connected to a
different instance?
>Please run:
>SELECT @.@.SERVERNAME
>And make sure the instance name is what you think it
should be before you
>create your database.
>
><anonymous@.discussions.microsoft.com> wrote in message
> news:12ebd01c44354$44fc3630$a001280a@.phx
.gbl...
the[vbcol=seagreen]
--[vbcol=seagreen]
you "open"[vbcol=seagreen]
description.[vbcol=seagreen]
>
>.
>

No comments:

Post a Comment