Hello,
I am not sure if this is the right forum, but here goes.
I need to document the members of about 1000 Active Directory Group in a SQL
database. The groups are all in the same OU. I also need to document the
nested members (both groups and users). Putting the root groups in a table i
s
no problem. I am having trouble with maintaining the relationships between
the root groups\nested groups\nested members. A typical example would be:
Root group
Nested Group 1
Nested User 1
Nested User 2
Nested Group 2
Nested User 1
Nested User 2
Thanks in advance for any suggestions.Hi
You may want to check previous ADSI threads and the ADSI newsgroup such as
http://tinyurl.com/e7vtb
John
"bxr222" wrote:
> Hello,
> I am not sure if this is the right forum, but here goes.
> I need to document the members of about 1000 Active Directory Group in a S
QL
> database. The groups are all in the same OU. I also need to document the
> nested members (both groups and users). Putting the root groups in a table
is
> no problem. I am having trouble with maintaining the relationships between
> the root groups\nested groups\nested members. A typical example would be:
> Root group
> Nested Group 1
> Nested User 1
> Nested User 2
> Nested Group 2
> Nested User 1
> Nested User 2
> Thanks in advance for any suggestions.
>|||John,
Thanks for responding. I have seen similar info before but do not think this
suits my needs. Particularily, no info exists on getting the members of
groups. I can do this easily using VBScript, but need a table structure to
input it into. Additionally, I need to be able to track changes to these
groups on a quarterly basis. I may be overlooking something here though.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may want to check previous ADSI threads and the ADSI newsgroup such as
> http://tinyurl.com/e7vtb
> John
> "bxr222" wrote:
>|||Hi
The recursion is best handled in the script example, you can then decide on
what you wish to store in the database.
John
"bxr222" wrote:
[vbcol=seagreen]
> John,
> Thanks for responding. I have seen similar info before but do not think th
is
> suits my needs. Particularily, no info exists on getting the members of
> groups. I can do this easily using VBScript, but need a table structure to
> input it into. Additionally, I need to be able to track changes to these
> groups on a quarterly basis. I may be overlooking something here though.
> "John Bell" wrote:
>
Showing posts with label group. Show all posts
Showing posts with label group. Show all posts
Wednesday, March 28, 2012
Modelling Active Directory Data
Hello,
I am not sure if this is the right forum, but here goes.
I need to document the members of about 1000 Active Directory Group in a SQL
database. The groups are all in the same OU. I also need to document the
nested members (both groups and users). Putting the root groups in a table is
no problem. I am having trouble with maintaining the relationships between
the root groups\nested groups\nested members. A typical example would be:
Root group
Nested Group 1
Nested User 1
Nested User 2
Nested Group 2
Nested User 1
Nested User 2
Thanks in advance for any suggestions.Hi
You may want to check previous ADSI threads and the ADSI newsgroup such as
http://tinyurl.com/e7vtb
John
"bxr222" wrote:
> Hello,
> I am not sure if this is the right forum, but here goes.
> I need to document the members of about 1000 Active Directory Group in a SQL
> database. The groups are all in the same OU. I also need to document the
> nested members (both groups and users). Putting the root groups in a table is
> no problem. I am having trouble with maintaining the relationships between
> the root groups\nested groups\nested members. A typical example would be:
> Root group
> Nested Group 1
> Nested User 1
> Nested User 2
> Nested Group 2
> Nested User 1
> Nested User 2
> Thanks in advance for any suggestions.
>|||John,
Thanks for responding. I have seen similar info before but do not think this
suits my needs. Particularily, no info exists on getting the members of
groups. I can do this easily using VBScript, but need a table structure to
input it into. Additionally, I need to be able to track changes to these
groups on a quarterly basis. I may be overlooking something here though.
"John Bell" wrote:
> Hi
> You may want to check previous ADSI threads and the ADSI newsgroup such as
> http://tinyurl.com/e7vtb
> John
> "bxr222" wrote:
> > Hello,
> >
> > I am not sure if this is the right forum, but here goes.
> >
> > I need to document the members of about 1000 Active Directory Group in a SQL
> > database. The groups are all in the same OU. I also need to document the
> > nested members (both groups and users). Putting the root groups in a table is
> > no problem. I am having trouble with maintaining the relationships between
> > the root groups\nested groups\nested members. A typical example would be:
> >
> > Root group
> > Nested Group 1
> > Nested User 1
> > Nested User 2
> > Nested Group 2
> > Nested User 1
> > Nested User 2
> >
> > Thanks in advance for any suggestions.
> >|||Hi
The recursion is best handled in the script example, you can then decide on
what you wish to store in the database.
John
"bxr222" wrote:
> John,
> Thanks for responding. I have seen similar info before but do not think this
> suits my needs. Particularily, no info exists on getting the members of
> groups. I can do this easily using VBScript, but need a table structure to
> input it into. Additionally, I need to be able to track changes to these
> groups on a quarterly basis. I may be overlooking something here though.
> "John Bell" wrote:
> > Hi
> >
> > You may want to check previous ADSI threads and the ADSI newsgroup such as
> > http://tinyurl.com/e7vtb
> >
> > John
> >
> > "bxr222" wrote:
> >
> > > Hello,
> > >
> > > I am not sure if this is the right forum, but here goes.
> > >
> > > I need to document the members of about 1000 Active Directory Group in a SQL
> > > database. The groups are all in the same OU. I also need to document the
> > > nested members (both groups and users). Putting the root groups in a table is
> > > no problem. I am having trouble with maintaining the relationships between
> > > the root groups\nested groups\nested members. A typical example would be:
> > >
> > > Root group
> > > Nested Group 1
> > > Nested User 1
> > > Nested User 2
> > > Nested Group 2
> > > Nested User 1
> > > Nested User 2
> > >
> > > Thanks in advance for any suggestions.
> > >
I am not sure if this is the right forum, but here goes.
I need to document the members of about 1000 Active Directory Group in a SQL
database. The groups are all in the same OU. I also need to document the
nested members (both groups and users). Putting the root groups in a table is
no problem. I am having trouble with maintaining the relationships between
the root groups\nested groups\nested members. A typical example would be:
Root group
Nested Group 1
Nested User 1
Nested User 2
Nested Group 2
Nested User 1
Nested User 2
Thanks in advance for any suggestions.Hi
You may want to check previous ADSI threads and the ADSI newsgroup such as
http://tinyurl.com/e7vtb
John
"bxr222" wrote:
> Hello,
> I am not sure if this is the right forum, but here goes.
> I need to document the members of about 1000 Active Directory Group in a SQL
> database. The groups are all in the same OU. I also need to document the
> nested members (both groups and users). Putting the root groups in a table is
> no problem. I am having trouble with maintaining the relationships between
> the root groups\nested groups\nested members. A typical example would be:
> Root group
> Nested Group 1
> Nested User 1
> Nested User 2
> Nested Group 2
> Nested User 1
> Nested User 2
> Thanks in advance for any suggestions.
>|||John,
Thanks for responding. I have seen similar info before but do not think this
suits my needs. Particularily, no info exists on getting the members of
groups. I can do this easily using VBScript, but need a table structure to
input it into. Additionally, I need to be able to track changes to these
groups on a quarterly basis. I may be overlooking something here though.
"John Bell" wrote:
> Hi
> You may want to check previous ADSI threads and the ADSI newsgroup such as
> http://tinyurl.com/e7vtb
> John
> "bxr222" wrote:
> > Hello,
> >
> > I am not sure if this is the right forum, but here goes.
> >
> > I need to document the members of about 1000 Active Directory Group in a SQL
> > database. The groups are all in the same OU. I also need to document the
> > nested members (both groups and users). Putting the root groups in a table is
> > no problem. I am having trouble with maintaining the relationships between
> > the root groups\nested groups\nested members. A typical example would be:
> >
> > Root group
> > Nested Group 1
> > Nested User 1
> > Nested User 2
> > Nested Group 2
> > Nested User 1
> > Nested User 2
> >
> > Thanks in advance for any suggestions.
> >|||Hi
The recursion is best handled in the script example, you can then decide on
what you wish to store in the database.
John
"bxr222" wrote:
> John,
> Thanks for responding. I have seen similar info before but do not think this
> suits my needs. Particularily, no info exists on getting the members of
> groups. I can do this easily using VBScript, but need a table structure to
> input it into. Additionally, I need to be able to track changes to these
> groups on a quarterly basis. I may be overlooking something here though.
> "John Bell" wrote:
> > Hi
> >
> > You may want to check previous ADSI threads and the ADSI newsgroup such as
> > http://tinyurl.com/e7vtb
> >
> > John
> >
> > "bxr222" wrote:
> >
> > > Hello,
> > >
> > > I am not sure if this is the right forum, but here goes.
> > >
> > > I need to document the members of about 1000 Active Directory Group in a SQL
> > > database. The groups are all in the same OU. I also need to document the
> > > nested members (both groups and users). Putting the root groups in a table is
> > > no problem. I am having trouble with maintaining the relationships between
> > > the root groups\nested groups\nested members. A typical example would be:
> > >
> > > Root group
> > > Nested Group 1
> > > Nested User 1
> > > Nested User 2
> > > Nested Group 2
> > > Nested User 1
> > > Nested User 2
> > >
> > > Thanks in advance for any suggestions.
> > >
model db owner
I have a request to add a user to the model db dbo group.
Can you provide pros/cons to this request
thanks again
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
Pro:
That user will be created in any new databases you create.
Con:
That user will be created in any new databases you create.
|||What they're asking is for someone to have dbo access to every database ever
created in that server. I suppose if the user is the CEO that might be
justified but that's a lot of privileged access to give to anyone.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
|||"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ACF4C5D7-F192-4B68-B05D-B1BF5D951204@.microsoft.com...
> What they're asking is for someone to have dbo access to every database
> ever created in that server. I suppose if the user is the CEO that might
> be justified but that's a lot of privileged access to give to anyone.
>
Oops, missed the dbo part. That's probably not a good idea.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Can you provide pros/cons to this request
thanks again
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
Pro:
That user will be created in any new databases you create.
Con:
That user will be created in any new databases you create.
|||What they're asking is for someone to have dbo access to every database ever
created in that server. I suppose if the user is the CEO that might be
justified but that's a lot of privileged access to give to anyone.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
|||"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ACF4C5D7-F192-4B68-B05D-B1BF5D951204@.microsoft.com...
> What they're asking is for someone to have dbo access to every database
> ever created in that server. I suppose if the user is the CEO that might
> be justified but that's a lot of privileged access to give to anyone.
>
Oops, missed the dbo part. That's probably not a good idea.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
model db owner
I have a request to add a user to the model db dbo group.
Can you provide pros/cons to this request
thanks again"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
Pro:
That user will be created in any new databases you create.
Con:
That user will be created in any new databases you create.|||What they're asking is for someone to have dbo access to every database ever
created in that server. I suppose if the user is the CEO that might be
justified but that's a lot of privileged access to give to anyone.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again|||"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ACF4C5D7-F192-4B68-B05D-B1BF5D951204@.microsoft.com...
> What they're asking is for someone to have dbo access to every database
> ever created in that server. I suppose if the user is the CEO that might
> be justified but that's a lot of privileged access to give to anyone.
>
Oops, missed the dbo part. That's probably not a good idea.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Can you provide pros/cons to this request
thanks again"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
Pro:
That user will be created in any new databases you create.
Con:
That user will be created in any new databases you create.|||What they're asking is for someone to have dbo access to every database ever
created in that server. I suppose if the user is the CEO that might be
justified but that's a lot of privileged access to give to anyone.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again|||"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ACF4C5D7-F192-4B68-B05D-B1BF5D951204@.microsoft.com...
> What they're asking is for someone to have dbo access to every database
> ever created in that server. I suppose if the user is the CEO that might
> be justified but that's a lot of privileged access to give to anyone.
>
Oops, missed the dbo part. That's probably not a good idea.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
model db owner
I have a request to add a user to the model db dbo group.
Can you provide pros/cons to this request
thanks again"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
Pro:
That user will be created in any new databases you create.
Con:
That user will be created in any new databases you create.|||What they're asking is for someone to have dbo access to every database ever
created in that server. I suppose if the user is the CEO that might be
justified but that's a lot of privileged access to give to anyone.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again|||"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ACF4C5D7-F192-4B68-B05D-B1BF5D951204@.microsoft.com...
> What they're asking is for someone to have dbo access to every database
> ever created in that server. I suppose if the user is the CEO that might
> be justified but that's a lot of privileged access to give to anyone.
>
Oops, missed the dbo part. That's probably not a good idea.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>>I have a request to add a user to the model db dbo group.
>> Can you provide pros/cons to this request
>> thanks again
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Can you provide pros/cons to this request
thanks again"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again
Pro:
That user will be created in any new databases you create.
Con:
That user will be created in any new databases you create.|||What they're asking is for someone to have dbo access to every database ever
created in that server. I suppose if the user is the CEO that might be
justified but that's a lot of privileged access to give to anyone.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>I have a request to add a user to the model db dbo group.
> Can you provide pros/cons to this request
> thanks again|||"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:ACF4C5D7-F192-4B68-B05D-B1BF5D951204@.microsoft.com...
> What they're asking is for someone to have dbo access to every database
> ever created in that server. I suppose if the user is the CEO that might
> be justified but that's a lot of privileged access to give to anyone.
>
Oops, missed the dbo part. That's probably not a good idea.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "stoney" <stoney@.discussions.microsoft.com> wrote in message
> news:DA0A3CE6-26BD-41C9-91D3-1257A1C8B513@.microsoft.com...
>>I have a request to add a user to the model db dbo group.
>> Can you provide pros/cons to this request
>> thanks again
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Wednesday, March 21, 2012
Mixing Types
Hello Group,
our company had a database on SQL Server 2000 Standard as the source for a
Report Server 2000 Standard. Well, the source databases had to be moved to a
brand new server. As it happened, the SQL Server 2000 on the new server is
Enterprise. Now, the report server will not work. We changed the connection
strings for the reports to point to the new server but no good. We just keep
getting "server not trusted".
Does the type of database server matter to the report server?
RichFirst, I assume that it is just the data that is an issue. Not the
reportserver database itself (where Report server keeps its metadata/object
caching).
My guess is that something else is going on with regards to the security. If
you are using integrated security there might be some issue with RS server
passing on credentials to
What I prefer to do is to have a read only SQL login. I use that for
credentials. I just use the windows domain login to determine who gets to
run what report.
It does not matter in the least where the data is coming from. I report off
of SQL Server standard, SQL Server Enterprise, Sybase, In-SQL (a real time
control historian).
Now, if you are not even having Report Manager come up (i.e. you never even
get where you can select the report to run) then it sounds like RS database
was moved. Again, you have a configuration/security problem going on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:E44CB1AD-A386-40E2-BBE6-F1BB1872F817@.microsoft.com...
> Hello Group,
> our company had a database on SQL Server 2000 Standard as the source for a
> Report Server 2000 Standard. Well, the source databases had to be moved
> to a
> brand new server. As it happened, the SQL Server 2000 on the new server
> is
> Enterprise. Now, the report server will not work. We changed the
> connection
> strings for the reports to point to the new server but no good. We just
> keep
> getting "server not trusted".
> Does the type of database server matter to the report server?
> Rich|||Hello Bruce,
thanks...the Report Manger comes up just fine. It displays the folders and
reports and user just like always. I thought that if I changed the
Connection String in the Report Manager, this would be enough. I need to
come up with a stradigy as to how to narrow down the location of the problem.
Rich
"Bruce L-C [MVP]" wrote:
> First, I assume that it is just the data that is an issue. Not the
> reportserver database itself (where Report server keeps its metadata/object
> caching).
> My guess is that something else is going on with regards to the security. If
> you are using integrated security there might be some issue with RS server
> passing on credentials to
> What I prefer to do is to have a read only SQL login. I use that for
> credentials. I just use the windows domain login to determine who gets to
> run what report.
> It does not matter in the least where the data is coming from. I report off
> of SQL Server standard, SQL Server Enterprise, Sybase, In-SQL (a real time
> control historian).
> Now, if you are not even having Report Manager come up (i.e. you never even
> get where you can select the report to run) then it sounds like RS database
> was moved. Again, you have a configuration/security problem going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:E44CB1AD-A386-40E2-BBE6-F1BB1872F817@.microsoft.com...
> > Hello Group,
> >
> > our company had a database on SQL Server 2000 Standard as the source for a
> > Report Server 2000 Standard. Well, the source databases had to be moved
> > to a
> > brand new server. As it happened, the SQL Server 2000 on the new server
> > is
> > Enterprise. Now, the report server will not work. We changed the
> > connection
> > strings for the reports to point to the new server but no good. We just
> > keep
> > getting "server not trusted".
> >
> > Does the type of database server matter to the report server?
> >
> > Rich
>
>sql
our company had a database on SQL Server 2000 Standard as the source for a
Report Server 2000 Standard. Well, the source databases had to be moved to a
brand new server. As it happened, the SQL Server 2000 on the new server is
Enterprise. Now, the report server will not work. We changed the connection
strings for the reports to point to the new server but no good. We just keep
getting "server not trusted".
Does the type of database server matter to the report server?
RichFirst, I assume that it is just the data that is an issue. Not the
reportserver database itself (where Report server keeps its metadata/object
caching).
My guess is that something else is going on with regards to the security. If
you are using integrated security there might be some issue with RS server
passing on credentials to
What I prefer to do is to have a read only SQL login. I use that for
credentials. I just use the windows domain login to determine who gets to
run what report.
It does not matter in the least where the data is coming from. I report off
of SQL Server standard, SQL Server Enterprise, Sybase, In-SQL (a real time
control historian).
Now, if you are not even having Report Manager come up (i.e. you never even
get where you can select the report to run) then it sounds like RS database
was moved. Again, you have a configuration/security problem going on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:E44CB1AD-A386-40E2-BBE6-F1BB1872F817@.microsoft.com...
> Hello Group,
> our company had a database on SQL Server 2000 Standard as the source for a
> Report Server 2000 Standard. Well, the source databases had to be moved
> to a
> brand new server. As it happened, the SQL Server 2000 on the new server
> is
> Enterprise. Now, the report server will not work. We changed the
> connection
> strings for the reports to point to the new server but no good. We just
> keep
> getting "server not trusted".
> Does the type of database server matter to the report server?
> Rich|||Hello Bruce,
thanks...the Report Manger comes up just fine. It displays the folders and
reports and user just like always. I thought that if I changed the
Connection String in the Report Manager, this would be enough. I need to
come up with a stradigy as to how to narrow down the location of the problem.
Rich
"Bruce L-C [MVP]" wrote:
> First, I assume that it is just the data that is an issue. Not the
> reportserver database itself (where Report server keeps its metadata/object
> caching).
> My guess is that something else is going on with regards to the security. If
> you are using integrated security there might be some issue with RS server
> passing on credentials to
> What I prefer to do is to have a read only SQL login. I use that for
> credentials. I just use the windows domain login to determine who gets to
> run what report.
> It does not matter in the least where the data is coming from. I report off
> of SQL Server standard, SQL Server Enterprise, Sybase, In-SQL (a real time
> control historian).
> Now, if you are not even having Report Manager come up (i.e. you never even
> get where you can select the report to run) then it sounds like RS database
> was moved. Again, you have a configuration/security problem going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:E44CB1AD-A386-40E2-BBE6-F1BB1872F817@.microsoft.com...
> > Hello Group,
> >
> > our company had a database on SQL Server 2000 Standard as the source for a
> > Report Server 2000 Standard. Well, the source databases had to be moved
> > to a
> > brand new server. As it happened, the SQL Server 2000 on the new server
> > is
> > Enterprise. Now, the report server will not work. We changed the
> > connection
> > strings for the reports to point to the new server but no good. We just
> > keep
> > getting "server not trusted".
> >
> > Does the type of database server matter to the report server?
> >
> > Rich
>
>sql
Monday, March 12, 2012
missing system databases folder from management studio
Hi All
My view of database on management studio does not have folder with system
databases. I am sysadmin on server and member of local admins group. Do you
know what could be a problem?In Management Studio take a look at Tools, Options, Hide system objects in
Object Explorer. Is the box checked?
Hope this helps,
Ben Nevarez
"Gene." wrote:
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do you
> know what could be a problem?|||Hi Gene
There is an option available that turns system objects visible or invisible.
Look at the Options in the Tools menu. The General tab has the checkbox
"Hide system objects in Object Explorer"
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do
> you
> know what could be a problem?|||Hi Ben, Kalen
This is genious!
I did not change those settings but that was a fix!
Thank you so much. I am happy again now.
"Kalen Delaney" wrote:
> Hi Gene
> There is an option available that turns system objects visible or invisible.
> Look at the Options in the Tools menu. The General tab has the checkbox
> "Hide system objects in Object Explorer"
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> > Hi All
> > My view of database on management studio does not have folder with system
> > databases. I am sysadmin on server and member of local admins group. Do
> > you
> > know what could be a problem?
>
>
>
My view of database on management studio does not have folder with system
databases. I am sysadmin on server and member of local admins group. Do you
know what could be a problem?In Management Studio take a look at Tools, Options, Hide system objects in
Object Explorer. Is the box checked?
Hope this helps,
Ben Nevarez
"Gene." wrote:
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do you
> know what could be a problem?|||Hi Gene
There is an option available that turns system objects visible or invisible.
Look at the Options in the Tools menu. The General tab has the checkbox
"Hide system objects in Object Explorer"
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> Hi All
> My view of database on management studio does not have folder with system
> databases. I am sysadmin on server and member of local admins group. Do
> you
> know what could be a problem?|||Hi Ben, Kalen
This is genious!
I did not change those settings but that was a fix!
Thank you so much. I am happy again now.
"Kalen Delaney" wrote:
> Hi Gene
> There is an option available that turns system objects visible or invisible.
> Look at the Options in the Tools menu. The General tab has the checkbox
> "Hide system objects in Object Explorer"
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:FAEC8F2B-9E3E-467C-B368-756773D1BD16@.microsoft.com...
> > Hi All
> > My view of database on management studio does not have folder with system
> > databases. I am sysadmin on server and member of local admins group. Do
> > you
> > know what could be a problem?
>
>
>
Friday, March 9, 2012
Missing Row in CSV Export
Hi Everyone,
I'm having an issue with a row of data missing when exporting to CSV.
The report structure is as follows:
Group 1 Header - Grouping on State (Displays the State)
Group 2 Header - Grouping on Customer ID (Displays a summary for each
customer)
Detail Row - <This Row has Been Removed>
Group 2 Footer - <This Row has Been Removed>
Group 1 Footer - Displays totals for the state
The report renders fine to PDF and will export all data to XML. When I
export to CSV, the first row is always missing. I have two reports with
similar structure and suffers from the same issue.
Any help would be greatly appreciated.
Thanks
ChadIf you add rectangle/ blank image / blank label above your report, CSV export
will work.
"Chad McKee" wrote:
> Hi Everyone,
> I'm having an issue with a row of data missing when exporting to CSV.
> The report structure is as follows:
> Group 1 Header - Grouping on State (Displays the State)
> Group 2 Header - Grouping on Customer ID (Displays a summary for each
> customer)
> Detail Row - <This Row has Been Removed>
> Group 2 Footer - <This Row has Been Removed>
> Group 1 Footer - Displays totals for the state
> The report renders fine to PDF and will export all data to XML. When I
> export to CSV, the first row is always missing. I have two reports with
> similar structure and suffers from the same issue.
> Any help would be greatly appreciated.
> Thanks
> Chad
>|||We have posted a hotfix that includes a fix for this issue at
http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chad McKee" <cmckee@.startech-comp.com> wrote in message
news:%2340961OeFHA.3048@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I'm having an issue with a row of data missing when exporting to CSV. The
> report structure is as follows:
> Group 1 Header - Grouping on State (Displays the State)
> Group 2 Header - Grouping on Customer ID (Displays a summary for each
> customer)
> Detail Row - <This Row has Been Removed>
> Group 2 Footer - <This Row has Been Removed>
> Group 1 Footer - Displays totals for the state
> The report renders fine to PDF and will export all data to XML. When I
> export to CSV, the first row is always missing. I have two reports with
> similar structure and suffers from the same issue.
> Any help would be greatly appreciated.
> Thanks
> Chad|||> The report renders fine to PDF and will export all data to XML. When I
> export to CSV, the first row is always missing. I have two reports with
> similar structure and suffers from the same issue.
Hmm, haven't looked into the problem but maybe the CSV export is getting
confused with header rows. In case you just can't find a work-around, a
custom CSV rendering extension might be the solution. I imagine that
shouldn't be too hard to accomplish.
Christoph|||Thanks to everyone who replied. The Hotfix fixed the issue.
Thanks
Chad
Brian Welcker [MSFT] wrote:
> We have posted a hotfix that includes a fix for this issue at
> http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en.
>
I'm having an issue with a row of data missing when exporting to CSV.
The report structure is as follows:
Group 1 Header - Grouping on State (Displays the State)
Group 2 Header - Grouping on Customer ID (Displays a summary for each
customer)
Detail Row - <This Row has Been Removed>
Group 2 Footer - <This Row has Been Removed>
Group 1 Footer - Displays totals for the state
The report renders fine to PDF and will export all data to XML. When I
export to CSV, the first row is always missing. I have two reports with
similar structure and suffers from the same issue.
Any help would be greatly appreciated.
Thanks
ChadIf you add rectangle/ blank image / blank label above your report, CSV export
will work.
"Chad McKee" wrote:
> Hi Everyone,
> I'm having an issue with a row of data missing when exporting to CSV.
> The report structure is as follows:
> Group 1 Header - Grouping on State (Displays the State)
> Group 2 Header - Grouping on Customer ID (Displays a summary for each
> customer)
> Detail Row - <This Row has Been Removed>
> Group 2 Footer - <This Row has Been Removed>
> Group 1 Footer - Displays totals for the state
> The report renders fine to PDF and will export all data to XML. When I
> export to CSV, the first row is always missing. I have two reports with
> similar structure and suffers from the same issue.
> Any help would be greatly appreciated.
> Thanks
> Chad
>|||We have posted a hotfix that includes a fix for this issue at
http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chad McKee" <cmckee@.startech-comp.com> wrote in message
news:%2340961OeFHA.3048@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I'm having an issue with a row of data missing when exporting to CSV. The
> report structure is as follows:
> Group 1 Header - Grouping on State (Displays the State)
> Group 2 Header - Grouping on Customer ID (Displays a summary for each
> customer)
> Detail Row - <This Row has Been Removed>
> Group 2 Footer - <This Row has Been Removed>
> Group 1 Footer - Displays totals for the state
> The report renders fine to PDF and will export all data to XML. When I
> export to CSV, the first row is always missing. I have two reports with
> similar structure and suffers from the same issue.
> Any help would be greatly appreciated.
> Thanks
> Chad|||> The report renders fine to PDF and will export all data to XML. When I
> export to CSV, the first row is always missing. I have two reports with
> similar structure and suffers from the same issue.
Hmm, haven't looked into the problem but maybe the CSV export is getting
confused with header rows. In case you just can't find a work-around, a
custom CSV rendering extension might be the solution. I imagine that
shouldn't be too hard to accomplish.
Christoph|||Thanks to everyone who replied. The Hotfix fixed the issue.
Thanks
Chad
Brian Welcker [MSFT] wrote:
> We have posted a hotfix that includes a fix for this issue at
> http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en.
>
Wednesday, March 7, 2012
Missing Program group
Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt
"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
[vbcol=seagreen]
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
server).[vbcol=seagreen]
> there
happened?
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> server).
> happened?
>
>
|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows[vbcol=seagreen]
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> server).
QL
> happened?
>
>
|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> Windows
> QL
>
>
|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well[vbcol=seagreen]
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
would[vbcol=seagreen]
> Windows
S[vbcol=seagreen]
> QL
except
>
>
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt
"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
[vbcol=seagreen]
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
server).[vbcol=seagreen]
> there
happened?
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> server).
> happened?
>
>
|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows[vbcol=seagreen]
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> server).
QL
> happened?
>
>
|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> Windows
> QL
>
>
|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well[vbcol=seagreen]
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
would[vbcol=seagreen]
> Windows
S[vbcol=seagreen]
> QL
except
>
>
Missing Program group
Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000
server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to
SQL Server and deleted all files. I have rebooted the server.
I have run an install of 6.5. It seems to have worked all right except
there is no program groups on my start menu. Any ideas what might have
happened?
Regards
Matt<john.bandettini@.rbs.co.uk> wrote in message
news:1117786641.708591.159230@.g49g2000cwa.googlegr oups.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to
> SQL Server and deleted all files. I have rebooted the server.
> I have run an install of 6.5. It seems to have worked all right except
> there is no program groups on my start menu. Any ideas what might have
> happened?
> Regards
> Matt
No idea, but presumably you can easily create your own group and add
shortcuts to the various executables? You could even copy the group from
another machine, if you have one available.
Simon
Missing Program group
Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000
server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have
happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to SQL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to S
QL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You
would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to
S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right
except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000 server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > Guys and Girls
> >
> > I have a server that was running SQL Server 2000 (on Windows 2000
server).
> > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > un-installed 2000. I edited the registry to remove all references to SQL
> > Server and deleted all files.
> >
> > I have run an install of 6.5. It seems to have worked all right except
> there
> > is no program groups on my start menu. Any ideas what might have
happened?
> >
> > Regards
> >
> > Matt
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to SQL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
> >
> > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > Guys and Girls
> > >
> > > I have a server that was running SQL Server 2000 (on Windows 2000
> server).
> > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > un-installed 2000. I edited the registry to remove all references to S
QL
> > > Server and deleted all files.
> > >
> > > I have run an install of 6.5. It seems to have worked all right except
> > there
> > > is no program groups on my start menu. Any ideas what might have
> happened?
> > >
> > > Regards
> > >
> > > Matt
> >
> > Have you rebooted?
> >
> >
> > Rick Sawtell
> > MCT, MCSD, MCDBA
> >
> >
> >
> >
>
>|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
> > Sounds like leftovers to me. Things like MDAC levels and such. You
would
> > be better off reimaging the system. Also, you can't install 6.5 on
> Windows
> > 2000, sorry. Scale it back down to NT 4.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> > news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> > Rick
> >
> > Yes, several times.
> >
> > Regards
> >
> > Matt
> >
> > "Rick Sawtell" wrote:
> >
> > >
> > > "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> > > news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> > > > Guys and Girls
> > > >
> > > > I have a server that was running SQL Server 2000 (on Windows 2000
> > server).
> > > > In preperation for an upgrade from an old SQL Server 6.5 system. I
> > > > un-installed 2000. I edited the registry to remove all references to
S
> QL
> > > > Server and deleted all files.
> > > >
> > > > I have run an install of 6.5. It seems to have worked all right
except
> > > there
> > > > is no program groups on my start menu. Any ideas what might have
> > happened?
> > > >
> > > > Regards
> > > >
> > > > Matt
> > >
> > > Have you rebooted?
> > >
> > >
> > > Rick Sawtell
> > > MCT, MCSD, MCDBA
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
Missing Program group
Guys and Girls
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
server).[vbcol=seagreen]
> there
happened?[vbcol=seagreen]
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a
.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Window
s
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
>
> server).
> happened?
>
>|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
>
> server).
QL[vbcol=seagreen]
> happened?
>
>|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT
4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that
.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim th
at
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as wel
l
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
>
> Windows
> QL
>
>|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
>
would[vbcol=seagreen]
> Windows
S[vbcol=seagreen]
> QL
except[vbcol=seagreen]
>
>
I have a server that was running SQL Server 2000 (on Windows 2000 server).
In preperation for an upgrade from an old SQL Server 6.5 system. I
un-installed 2000. I edited the registry to remove all references to SQL
Server and deleted all files.
I have run an install of 6.5. It seems to have worked all right except there
is no program groups on my start menu. Any ideas what might have happened?
Regards
Matt"Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> Guys and Girls
> I have a server that was running SQL Server 2000 (on Windows 2000 server).
> In preperation for an upgrade from an old SQL Server 6.5 system. I
> un-installed 2000. I edited the registry to remove all references to SQL
> Server and deleted all files.
> I have run an install of 6.5. It seems to have worked all right except
there
> is no program groups on my start menu. Any ideas what might have happened?
> Regards
> Matt
Have you rebooted?
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
> there
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Sounds like leftovers to me. Things like MDAC levels and such. You would
be better off reimaging the system. Also, you can't install 6.5 on Windows
2000, sorry. Scale it back down to NT 4.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
Rick
Yes, several times.
Regards
Matt
"Rick Sawtell" wrote:
> "Matt Helm" <Matt Helm@.discussions.microsoft.com> wrote in message
> news:896F4725-DB82-4774-B600-30E75090F1A0@.microsoft.com...
server).[vbcol=seagreen]
> there
happened?[vbcol=seagreen]
> Have you rebooted?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running sp5a
.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on Window
s
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
>
> server).
> happened?
>
>|||Yes, but you're pushing technologies way beyond their design by doing that.
Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim that
7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
opposed to trying to compare Win NT 4 with either of the other OSes as well
as SS 6.5 with its counterparts.
Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
Anyway, in your case, apparently not. I would still recommend you reimage
the OS before attempting to reinstall 6.5. I've even had trouble with the
6.5 tools on workstations after 7.0 component had been installed. Even if
removed, I had trouble appling 6.5 service packs.
Then, again, you could always recreate them manually-I think it would be
quicker to reinstall the OS.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
Anthony
Thanks for the reply but 6.5 does run on W2K as long as you are running
sp5a.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
Regards
Matt
"Anthony Thomas" wrote:
> Sounds like leftovers to me. Things like MDAC levels and such. You would
> be better off reimaging the system. Also, you can't install 6.5 on
Windows
> 2000, sorry. Scale it back down to NT 4.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:DC23EBE0-2591-4EA8-A9C9-BDBA7972B0EC@.microsoft.com...
> Rick
> Yes, several times.
> Regards
> Matt
> "Rick Sawtell" wrote:
>
> server).
QL[vbcol=seagreen]
> happened?
>
>|||Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and NT
4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing that
.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim th
at
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as wel
l
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
>
> Windows
> QL
>
>|||No, no, I got that. The problem is that you have already installed SS2K
components on that system. It would be a very valid test to start of with
configurations that your upgrade systems do not yet have on them.
However, I would recommend that you build new SS2K installations and then
use the Upgrade Wizard to migrate the data from one host to the next, NOT an
inplace upgrade. I have never had much luck with those and for the very
reason you are seeing now: too many old components and configurations
around. You would be better served starting fresh and just migrating the
contents. Then you can scrub the old box, rebuild it fresh for the next
migration.
Sincerely,
Anthony Thomas
"Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
news:2B075981-64DA-4491-B616-9A5EE19C861E@.microsoft.com...
Anthony
You are probably right that I need to rebuild the operating system. I was
hoping not to. I perhaps should have explained that i was installing 6.5
before installing 2000. The server is going to be used to upgrade some old
legacy 6.5 databases to 2000 so that we can finally get away from 6.5 and
NT4.
Regards
Matt
"Anthony Thomas" wrote:
> Yes, but you're pushing technologies way beyond their design by doing
that.
> Hmm, 6.5 is supported on Win2K but 7.0 is not on Win2K3. I would claim
that
> 7.0 and SS2K are more similar to each other as well as Win2K and Win2K3 as
> opposed to trying to compare Win NT 4 with either of the other OSes as
well
> as SS 6.5 with its counterparts.
> Let's face it, 6.5 was an NT 4, even NT 3.51 technology.
> Anyway, in your case, apparently not. I would still recommend you reimage
> the OS before attempting to reinstall 6.5. I've even had trouble with the
> 6.5 tools on workstations after 7.0 component had been installed. Even if
> removed, I had trouble appling 6.5 service packs.
> Then, again, you could always recreate them manually-I think it would be
> quicker to reinstall the OS.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Matt helm" <Matthelm@.discussions.microsoft.com> wrote in message
> news:3AF2B053-0FF2-4161-8B30-3BD38C39B046@.microsoft.com...
> Anthony
> Thanks for the reply but 6.5 does run on W2K as long as you are running
> sp5a.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8532
> Regards
> Matt
> "Anthony Thomas" wrote:
>
would[vbcol=seagreen]
> Windows
S[vbcol=seagreen]
> QL
except[vbcol=seagreen]
>
>
Subscribe to:
Posts (Atom)