Re-Installation problem (prev installations not removed completely)

I have installed SQL server 2005 on Win SERVER 2003, then uninstalled and then re-installed but I have found out that the previous instances are still listed and the the previous collation too (I have changed reg setting and and language option re-installation).

It looks like that removing program does not remove completely every object, probably registry values

Do you know how to perform a good uninstallation removing everything (add/remove program does not work properly as written before) ?

Any help will be very appreciated.

Thank

After uninstalling SQL Server, check the ARP to confirm that the SQL Server Native Client was also removed. There are a few other support-type components that remain on your box from time to time. This is one of them.

Thanks,
Sam Lester (MSFT)|||

Because some modules are shared among instances on the same machine, I will not be able to unstall the shared modules, like SQL Native Client,etc.

If I had installed several instances of SQL 2005, will I get problems if I uninstall and reinstall some instances later?

NP

Reinstall 2nd Node - SQLServer

Cluster active-active. The installation in one server was lost and the S.O.
was reinstalled. Now in one node there are two instances. How can I reinstall
de second node and move the instance to it ?
Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
step instructions on how to replace a failed cluster node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
> Cluster active-active. The installation in one server was lost and the
> S.O.
> was reinstalled. Now in one node there are two instances. How can I
> reinstall
> de second node and move the instance to it ?
>
|||I found on Technet a guideline about "Restoring a Node After a Catastrophic
Failure"
In one of the steps is necessary Remove the node from a virtual server (SQL
Server). My doubt is if in this moment the instance will be unavailable.
The last step is install SQL Server. Is it possible rebuild node to the
virtual server before install SQL Server ?
"Geoff N. Hiten" wrote:

> Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
> step instructions on how to replace a failed cluster node.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
>
>
|||Again, Books-On-line has specific step-by step instructions on how to
restore a node under these exact circumstances. If you do the installation
according to the instructions, the instance will not need to go offline. If
you do not follow the instructions, you may damage your installation.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...[vbcol=seagreen]
>I found on Technet a guideline about "Restoring a Node After a Catastrophic
> Failure"
> In one of the steps is necessary Remove the node from a virtual server
> (SQL
> Server). My doubt is if in this moment the instance will be unavailable.
> The last step is install SQL Server. Is it possible rebuild node to the
> virtual server before install SQL Server ?
> "Geoff N. Hiten" wrote:
|||Thanks for your informations.
I tried to follow the instructions and the setup asked me to Uninstall the
Instance. What does it mean ? The instance will be removed physically ? My
doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
instances will keep available or not. I'm in production environment and the
instances can't be unavailable.
thanks,
Simone
"Geoff N. Hiten" wrote:

> Again, Books-On-line has specific step-by step instructions on how to
> restore a node under these exact circumstances. If you do the installation
> according to the instructions, the instance will not need to go offline. If
> you do not follow the instructions, you may damage your installation.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...
>
>
|||The SQL installer needs to modify the remaining bits on Node 1 to remove all
references to Node 2. In essence, it is erasing all traces of Node 2 from
the SQL instance. It will not completely remove your SQL instance. If this
is done correctly, the SQL instance currently running on Node 1 will not be
affected.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:64C2F5EB-54A1-4233-87FA-122081210718@.microsoft.com...[vbcol=seagreen]
> Thanks for your informations.
> I tried to follow the instructions and the setup asked me to Uninstall the
> Instance. What does it mean ? The instance will be removed physically ? My
> doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
> instances will keep available or not. I'm in production environment and
> the
> instances can't be unavailable.
> thanks,
> Simone
> "Geoff N. Hiten" wrote:

Registration error

Hi,
I am able to register other SQL server instances but when
I try to register one in particular I am getting this
error on the main server to which I need to register all
of the satelite servers. Can anyone help with this
problem? I don't understand why it is using a null
account instead of the guest account to try to log into
this particular instance.
Login failed for user '(null)'. Reason: Not associated
with a Trusted SQl Server connectionthat server is setup for Windows Authentication and you are logging in using
SQL login?
"Narine" <narinep@.siu.edu> wrote in message
news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
> Hi,
> I am able to register other SQL server instances but when
> I try to register one in particular I am getting this
> error on the main server to which I need to register all
> of the satelite servers. Can anyone help with this
> problem? I don't understand why it is using a null
> account instead of the guest account to try to log into
> this particular instance.
>
> Login failed for user '(null)'. Reason: Not associated
> with a Trusted SQl Server connection|||I am just using windows authentication only because I am
using the datbase with MS VB.NET 2002 and I am doing
merge replication with subscribers.
>--Original Message--
>that server is setup for Windows Authentication and you
are logging in using
>SQL login?
>"Narine" <narinep@.siu.edu> wrote in message
>news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
>> Hi,
>> I am able to register other SQL server instances but
when
>> I try to register one in particular I am getting this
>> error on the main server to which I need to register
all
>> of the satelite servers. Can anyone help with this
>> problem? I don't understand why it is using a null
>> account instead of the guest account to try to log into
>> this particular instance.
>>
>> Login failed for user '(null)'. Reason: Not associated
>> with a Trusted SQl Server connection
>
>.
>|||Check if the server you are trying to connect to is set to
Windows Authentication Only and change the security
settings to SQL Server and Windows. It seems that you are
using SQL authentication yourself and the other machine is
set to Windows Authentication only.
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>Hi,
>I am able to register other SQL server instances but when
>I try to register one in particular I am getting this
>error on the main server to which I need to register all
>of the satelite servers. Can anyone help with this
>problem? I don't understand why it is using a null
>account instead of the guest account to try to log into
>this particular instance.
>
>Login failed for user '(null)'. Reason: Not associated
>with a Trusted SQl Server connection
>.
>|||All of the servers are set to use Windows authentication
only originally when I installed them and this is stil so
when i just checked them. Could there be another reason
the main server is using the null account instead of the
guest account to register with the satelite server? How
can I set this parameter?
>--Original Message--
>Check if the server you are trying to connect to is set
to
>Windows Authentication Only and change the security
>settings to SQL Server and Windows. It seems that you
are
>using SQL authentication yourself and the other machine
is
>set to Windows Authentication only.
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>.
>|||Check this article and see if it applies to you:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q279526
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>All of the servers are set to use Windows authentication
>only originally when I installed them and this is stil so
>when i just checked them. Could there be another reason
>the main server is using the null account instead of the
>guest account to register with the satelite server? How
>can I set this parameter?
>
>>--Original Message--
>>Check if the server you are trying to connect to is set
>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>are
>>using SQL authentication yourself and the other machine
>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>>.
>.
>|||I have installed SP3 for MSSQL server for the desktop and
server version of mssql server 2000 and these included
the latest MDAC components. Should I go ahead and install
MDAC 8? could this be an SP3 problem? should I install
SP3a?
>--Original Message--
>Check this article and see if it applies to you:
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;Q279526
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>All of the servers are set to use Windows
authentication
>>only originally when I installed them and this is stil
so
>>when i just checked them. Could there be another reason
>>the main server is using the null account instead of
the
>>guest account to register with the satelite server? How
>>can I set this parameter?
>>
>>--Original Message--
>>Check if the server you are trying to connect to is
set
>>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>>are
>>using SQL authentication yourself and the other
machine
>>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log
into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not
associated
>>with a Trusted SQl Server connection
>>.
>>.
>>.
>.
>

Registering SQL Server in Enterprise Manager

I have followed all sugestions for this problem to no avail. I have 2 w2000 boxes connected via local network. Both are running instances of MSSQL8. From Box 2 I can register the MSSQL7 version on box1 and from box1 I can register the MSSQL7 version on box2. However I cannot register the MSSQL8 instancance either way. I can see the instance but get the message
"Specified SQL Server not found ConnectionOpen(Connect())
I have tried registering with the ip address but same problem
I have tried aliases.
In Client Network Utility and Server Network Utility I have both Named pipes(\\.\pipe\sql\query) and tcp/ip (port 1433)
on both machines
Any ideas ??
Regards ClemAre both boxes running both SQL2000 and SQL7? If so, and they are both listening on 1433, then only SQL7 will be accessible since it is not aware of multiple instancing in SQL2000. You may wish to have SQL2k listen on a different port.|||Thanks loach, sounds a likley fix. Excuse my ignorance but what port number can I use? Are port numbers listed somewhere?
Thanks for you time,
Regards Clem|||You can use any port number that is not already in use. It's typically a good idea to use port numbers over 10000 since they are rarely reserved. You can change the port number by starting up the server network utility (in the SQL Server program group), selecting the TCP/IP netowrk library and clicking on properties. To determine which ports are in use on the server, drop to a command prompt and run 'netstat -a'

You must then configure any client that accesses the server to also use that port using either the Client Network Utility or the ODBC connection properties.|||OK did that. Sql log now shows listening on [ip adds]:10000 but still same problem. tried connecting with ip adds but no go and also now on box1 I can't access the local mssql8 (7 is still ok) so i changed back to port 1433. (Is it using this port because it is not 'local'?)
At this stage I think I give up... I have been looking at this problem for about 3 months... so I guess i dont need the 7 databases any more. Any ideas how to remove the original 7 instance?
I am thinking a clean install might be the go?
Regards Clem|||Mmmmmmm clean install *drool* that's definately the way I would go,.. atleast you know where you stand then.|||try using port 1434.

try changing it in MS SQL2k on both machines (both changed at the same time)

is there any form of firewall on the individual computers, or between them? if so, make sure it isn't blocking port 1434 (or whatever port your using)

Try turning off mssql 7.

I don't know the details, but mssql is a registered system process, it integrates to an extent (i believe) with the OS.

Is it possible to successfully run multiple versions on MS SQL server on 1 machine? perhaps it isn't and that is why only ms sql 7 works correctly?

Using ports:

Yes, you can use any port, not in use. If you select a port that is in use, you should find out on the next boot. (something will probably crash, or stop working properly)

Hope this helps,|||Hi Ashleigh,
Yes it is possible to run both instances of mssql on the one server, it is the connecting to the mssql8 version on another machine that is the problem. When doing the connection the target server is even visible as a valid server...
Connecting to mssql7 on either machine is OK and of course both versions are OK if accessed on the local machine.
I believe this problem has been compounded by microsofts slammer virus fixes...

Register Multiple Servers in Enterprise Manager

I am looking for a way to register several hundred SQL Servers/Instances in
Enterprise manager without having to do them one by one.
Does anybody know of a way to do this?
Doing this via VBScript would be nice.Although I haven't tried it...you might take a look at RegisteredServer
Object in the SQL Server Books Online.
HTH
Jerry
"brimhj" <brimhj@.discussions.microsoft.com> wrote in message
news:854EA219-DF4B-4EF4-9C9F-785C5419E9DF@.microsoft.com...
>I am looking for a way to register several hundred SQL Servers/Instances in
> Enterprise manager without having to do them one by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.|||Use the SQLDMO.Application Object and script a solution
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_ob_a_8zw4.asp
"brimhj" <brimhj@.discussions.microsoft.com> wrote in message
news:854EA219-DF4B-4EF4-9C9F-785C5419E9DF@.microsoft.com...
>I am looking for a way to register several hundred SQL Servers/Instances in
> Enterprise manager without having to do them one by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.|||brimhj wrote:
> I am looking for a way to register several hundred SQL
> Servers/Instances in Enterprise manager without having to do them one
> by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.
You might be able to copy the registry keys as they appear in the
following key:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Under that key is one or more SQL Server Groups. The servers are listed
under each group as a binary key.
The actual name of the server as it appears in SQLEM is in the binary
value, not the name of the value. The name is descriptive only.
If you export the group and apply the entries to another computer, it
might work. I've only tried copying an entry locally and same server
appears twice in SQLEM.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Use at your own risk !
----
Const DefServerGroup = "SQL Server Group"
Set objDMOApp = CreateObject("SQLDMO.Application")
'Call AddServersFromFile("C:\Temp\ServerList.txt")
'Call AddRegServer("SERVERNAME",1)
'Call RemRegServer("TEST")
For Each ServerGroup In objDMOApp.ServerGroups
Call IterateGroups(ServerGroup)
Next
Sub IterateGroups(ParentGroup)
WScript.StdOut.WriteLine ParentGroup.Name
For Each RegisteredServer In ParentGroup.RegisteredServers
WScript.StdOut.WriteLine RegisteredServer.Name
Next
For Each ServerGroup In ParentGroup.ServerGroups
WScript.StdOut.WriteLine ServerGroup.Name
Next
End Sub
Sub AddRegServer(Name,UseTrustedConnection)
Set NewRegServer = CreateObject("SQLDMO.RegisteredServer")
NewRegServer.Name = Name
NewRegServer.UseTrustedConnection = UseTrustedConnection
Set DefaultGroup = objDMOApp.ServerGroups(DefServerGroup)
DefaultGroup.RegisteredServers.Add NewRegServer
End SUb
Sub RemRegServer(Name)
Set DefaultGroup = objDMOApp.ServerGroups(DefServerGroup)
DefaultGroup.RegisteredServers.Remove Name
End Sub
Sub AddServersFromFile(FileSpec)
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTS = objFSO.OpenTextFile(FileSpec)
While NOT objTS.AtEndOfStream
Call AddRegServer(objTS.ReadLine,1)
Wend
End Sub
----
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:OgFzuC6vFHA.1012@.TK2MSFTNGP09.phx.gbl...
> Use the SQLDMO.Application Object and script a solution
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_ob_a_8zw4.asp
>
> "brimhj" <brimhj@.discussions.microsoft.com> wrote in message
> news:854EA219-DF4B-4EF4-9C9F-785C5419E9DF@.microsoft.com...
>>I am looking for a way to register several hundred SQL Servers/Instances
>>in
>> Enterprise manager without having to do them one by one.
>> Does anybody know of a way to do this?
>> Doing this via VBScript would be nice.
>

Register Multiple Servers in Enterprise Manager

I am looking for a way to register several hundred SQL Servers/Instances in
Enterprise manager without having to do them one by one.
Does anybody know of a way to do this?
Doing this via VBScript would be nice.
Although I haven't tried it...you might take a look at RegisteredServer
Object in the SQL Server Books Online.
HTH
Jerry
"brimhj" <brimhj@.discussions.microsoft.com> wrote in message
news:854EA219-DF4B-4EF4-9C9F-785C5419E9DF@.microsoft.com...
>I am looking for a way to register several hundred SQL Servers/Instances in
> Enterprise manager without having to do them one by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.
|||Use the SQLDMO.Application Object and script a solution
http://msdn.microsoft.com/library/de..._ob_a_8zw4.asp
"brimhj" <brimhj@.discussions.microsoft.com> wrote in message
news:854EA219-DF4B-4EF4-9C9F-785C5419E9DF@.microsoft.com...
>I am looking for a way to register several hundred SQL Servers/Instances in
> Enterprise manager without having to do them one by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.
|||brimhj wrote:
> I am looking for a way to register several hundred SQL
> Servers/Instances in Enterprise manager without having to do them one
> by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.
You might be able to copy the registry keys as they appear in the
following key:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Under that key is one or more SQL Server Groups. The servers are listed
under each group as a binary key.
The actual name of the server as it appears in SQLEM is in the binary
value, not the name of the value. The name is descriptive only.
If you export the group and apply the entries to another computer, it
might work. I've only tried copying an entry locally and same server
appears twice in SQLEM.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Register Multiple Servers in Enterprise Manager

I am looking for a way to register several hundred SQL Servers/Instances in
Enterprise manager without having to do them one by one.
Does anybody know of a way to do this?
Doing this via VBScript would be nice.Although I haven't tried it...you might take a look at RegisteredServer
Object in the SQL Server Books Online.
HTH
Jerry
"brimhj" <brimhj@.discussions.microsoft.com> wrote in message
news:854EA219-DF4B-4EF4-9C9F-785C5419E9DF@.microsoft.com...
>I am looking for a way to register several hundred SQL Servers/Instances in
> Enterprise manager without having to do them one by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.|||Use the SQLDMO.Application Object and script a solution
http://msdn.microsoft.com/library/d... />
a_8zw4.asp
"brimhj" <brimhj@.discussions.microsoft.com> wrote in message
news:854EA219-DF4B-4EF4-9C9F-785C5419E9DF@.microsoft.com...
>I am looking for a way to register several hundred SQL Servers/Instances in
> Enterprise manager without having to do them one by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.|||brimhj wrote:
> I am looking for a way to register several hundred SQL
> Servers/Instances in Enterprise manager without having to do them one
> by one.
> Does anybody know of a way to do this?
> Doing this via VBScript would be nice.
You might be able to copy the registry keys as they appear in the
following key:
HKEY_CURRENT_USER\Software\Microsoft\Mic
rosoft SQL
Server\80\Tools\SQLEW\Registered Servers X
Under that key is one or more SQL Server Groups. The servers are listed
under each group as a binary key.
The actual name of the server as it appears in SQLEM is in the binary
value, not the name of the value. The name is descriptive only.
If you export the group and apply the entries to another computer, it
might work. I've only tried copying an entry locally and same server
appears twice in SQLEM.
David Gugick
Quest Software
www.imceda.com
www.quest.com