I have installed MS sql server 2005 developer edition beta2.
In report designer,i have given a parameter to a multi value and when see in
preview i am able to see the multi valued parameter.
but when i run it and see it in reportserver,even though i select multi
values,while displaying the results its taking only the last value selected.
please help me in this regard.I think that with Beta 2 there were some problems with multi-value. It is
working in the release version. If you have MSDN you can download it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sirisha" <sirisha@.discussions.microsoft.com> wrote in message
news:D7D10346-8D31-4810-A287-AD6D1D41030B@.microsoft.com...
>I have installed MS sql server 2005 developer edition beta2.
> In report designer,i have given a parameter to a multi value and when see
> in
> preview i am able to see the multi valued parameter.
> but when i run it and see it in reportserver,even though i select multi
> values,while displaying the results its taking only the last value
> selected.
> please help me in this regard.
>sql
Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Multi Server Administration (Error Enlist MSX)
With Sql-Server 2000 i am using since a long time the jobserver (MSX) with TSX-servers.
Now I installed Sql-Server 2005 Standard Edition (the same i have tested with developer edition) on NT-2003 SP1.
I have 2 Sql-Server instances installed.
Now i tryed to configure one instance as MSX-Server and the other one as TSX-Server.
No Chance. When i do it with Management-Studio the following error ist displayed:
The enlist operation failed (reason:SqlServerAgent Error: Unable to connect to 'MSX HG-ALV-012\I1'). (Microsoft Sql Server,Error:22026).
In the Agent-log i found after every try the following error-messages:
Date 06.12.2005 17:29:42
Log SQL Agent (Current - 06.12.2005 17:29:00)
Message
[298] SQLServer Error: 805, SSL Provider: Die Zertifikatkette wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle ausgestellt. [SQLSTATE 08001]
[298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]
Message in Eventlog:
Date 06.12.2005 17:29:42
Log Windows NT (System)
Source Schannel
Category (0)
Event 3221262354
Computer HG-ALV-012
Message
Das vom Remoteserver erhaltene Zertifikat wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle
ausgestellt. Aus diesem Grund k?nnen keine der im Zertifikat enthalten Daten verifiziert werden. Die
SSL-Verbindungsanforderung ist fehlgeschlagen. Die angeh?ngten Daten enthalten das Serverzertifikat.
I don't know what this has to do with certificates? The Configuration for the connections on the server (tcp) is definitely set to "ForceEncrypten=No".
Both Sql Server instances are ru
Has anyone an idea how to solve that problem?
There is a good Webcast exactly on this topic recorded at Dec 15 2005.
Theme: Upgrading SQL Server Agent to SQL Server 2000.
EventID is 1032285816
Look at http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032285816&EventCategory=5&culture=en-US&CountryCode=US
Regards
Ralph Kemperdick
Multi Server Administration (Error Enlist MSX)
With Sql-Server 2000 i am using since a long time the jobserver (MSX) with TSX-servers.
Now I installed Sql-Server 2005 Standard Edition (the same i have tested with developer edition) on NT-2003 SP1.
I have 2 Sql-Server instances installed.
Now i tryed to configure one instance as MSX-Server and the other one as TSX-Server.
No Chance. When i do it with Management-Studio the following error ist displayed:
The enlist operation failed (reason:SqlServerAgent Error: Unable to connect to 'MSX HG-ALV-012\I1'). (Microsoft Sql Server,Error:22026).
In the Agent-log i found after every try the following error-messages:
Date 06.12.2005 17:29:42
Log SQL Agent (Current - 06.12.2005 17:29:00)
Message
[298] SQLServer Error: 805, SSL Provider: Die Zertifikatkette wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle ausgestellt. [SQLSTATE 08001]
[298] SQLServer Error: 805, Client unable to establish connection [SQLSTATE 08001]
Message in Eventlog:
Date 06.12.2005 17:29:42
Log Windows NT (System)
Source Schannel
Category (0)
Event 3221262354
Computer HG-ALV-012
Message
Das vom Remoteserver erhaltene Zertifikat wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle
ausgestellt. Aus diesem Grund k?nnen keine der im Zertifikat enthalten Daten verifiziert werden. Die
SSL-Verbindungsanforderung ist fehlgeschlagen. Die angeh?ngten Daten enthalten das Serverzertifikat.
I don't know what this has to do with certificates? The Configuration for the connections on the server (tcp) is definitely set to "ForceEncrypten=No".
Both Sql Server instances are ru
Has anyone an idea how to solve that problem?
There is a good Webcast exactly on this topic recorded at Dec 15 2005.
Theme: Upgrading SQL Server Agent to SQL Server 2000.
EventID is 1032285816
Look at http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032285816&EventCategory=5&culture=en-US&CountryCode=US
Regards
Ralph Kemperdick
sql
Friday, March 23, 2012
Multable database on one machine
Total newbie question i know.
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
LeeYes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great Plains
>> 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the same
>> instance of SQL Server. Your limitations are: (a) two databases can't
>> have the same name, or expect their data/log files to have the same path,
>> and (b) the available resources on the server. If it's a low-powered box
>> it may perform acceptably hosting one application's database
>> As for the right way to perform the consolidation, if you are comfortable
>> that it is the right move, there are several options. Andrew Kelly has
>> posted this list of KB articles that should help you out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>> Great, Thank you, I am looking to be buying some new blade servers
>>
>> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the
>> same instance of SQL Server. Your limitations are: (a) two databases
>> can't have the same name, or expect their data/log files to have the
>> same path, and (b) the available resources on the server. If it's a
>> low-powered box it may perform acceptably hosting one application's
>> database
>> As for the right way to perform the consolidation, if you are
>> comfortable that it is the right move, there are several options.
>> Andrew Kelly has posted this list of KB articles that should help you
>> out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>>
>
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
LeeYes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great Plains
>> 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the same
>> instance of SQL Server. Your limitations are: (a) two databases can't
>> have the same name, or expect their data/log files to have the same path,
>> and (b) the available resources on the server. If it's a low-powered box
>> it may perform acceptably hosting one application's database
>> As for the right way to perform the consolidation, if you are comfortable
>> that it is the right move, there are several options. Andrew Kelly has
>> posted this list of KB articles that should help you out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>> Great, Thank you, I am looking to be buying some new blade servers
>>
>> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
>> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>> Yes, you can have multiple databases on the same machine, and on the
>> same instance of SQL Server. Your limitations are: (a) two databases
>> can't have the same name, or expect their data/log files to have the
>> same path, and (b) the available resources on the server. If it's a
>> low-powered box it may perform acceptably hosting one application's
>> database
>> As for the right way to perform the consolidation, if you are
>> comfortable that it is the right move, there are several options.
>> Andrew Kelly has posted this list of KB articles that should help you
>> out:
>> http://tinyurl.com/up5ok
>>
>> "Lee J" <faked@.fc.com> wrote in message
>> news:ejg6to$5ap@.dispatch.concentric.net...
>> Total newbie question i know.
>> The company i just started working for has SQL 2000 installed on four
>> machines. Is there any info i can get about putting all database on one
>> machine, Then having an application server running the apps (Great
>> Plains 7.5, Sharepoint, track-it, and a custom made database)
>> Thanks
>> Lee
>>
>>
>
Multable database on one machine
Total newbie question i know.
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
Lee
Yes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>
|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>
|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>
|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
Lee
Yes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>
|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>
|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>
|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>
Multable database on one machine
Total newbie question i know.
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
LeeYes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>
The company i just started working for has SQL 2000 installed on four
machines. Is there any info i can get about putting all database on one
machine, Then having an application server running the apps (Great Plains
7.5, Sharepoint, track-it, and a custom made database)
Thanks
LeeYes, you can have multiple databases on the same machine, and on the same
instance of SQL Server. Your limitations are: (a) two databases can't have
the same name, or expect their data/log files to have the same path, and (b)
the available resources on the server. If it's a low-powered box it may
perform acceptably hosting one application's database
As for the right way to perform the consolidation, if you are comfortable
that it is the right move, there are several options. Andrew Kelly has
posted this list of KB articles that should help you out:
http://tinyurl.com/up5ok
"Lee J" <faked@.fc.com> wrote in message
news:ejg6to$5ap@.dispatch.concentric.net...
> Total newbie question i know.
> The company i just started working for has SQL 2000 installed on four
> machines. Is there any info i can get about putting all database on one
> machine, Then having an application server running the apps (Great Plains
> 7.5, Sharepoint, track-it, and a custom made database)
> Thanks
> Lee
>|||Great, Thank you, I am looking to be buying some new blade servers
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
> Yes, you can have multiple databases on the same machine, and on the same
> instance of SQL Server. Your limitations are: (a) two databases can't
> have the same name, or expect their data/log files to have the same path,
> and (b) the available resources on the server. If it's a low-powered box
> it may perform acceptably hosting one application's database
> As for the right way to perform the consolidation, if you are comfortable
> that it is the right move, there are several options. Andrew Kelly has
> posted this list of KB articles that should help you out:
> http://tinyurl.com/up5ok
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg6to$5ap@.dispatch.concentric.net...
>|||Wow, I don't think I've come across anyone successfully running SQL Server
on a blade, but hey, all the best.
Actually I'm sitting with Geoff at PASS and he said that, unfortunately, he
has seen this, and it didn't work out too well. But again, all the best.
If it works out, please let us know. :-)
"Lee J" <faked@.fc.com> wrote in message
news:ejg8fo$5s5@.dispatch.concentric.net...
> Great, Thank you, I am looking to be buying some new blade servers
>
> "Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:u7yEr9QCHHA.5064@.TK2MSFTNGP02.phx.gbl...
>|||well, thats good to know, i am just in the discovery stage.
what kind of specs do you recommed?
My most heavly used database is on a dual 1GHz intel with 2GB of RAM. The
blades i was looking at were dual 1.8 xeons with 2GB.
this kind has landed on my lap
"Aaron Bertrand [MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OQi6PFRCHHA.4908@.TK2MSFTNGP03.phx.gbl...
> Wow, I don't think I've come across anyone successfully running SQL Server
> on a blade, but hey, all the best.
> Actually I'm sitting with Geoff at PASS and he said that, unfortunately,
> he has seen this, and it didn't work out too well. But again, all the
> best. If it works out, please let us know. :-)
>
>
> "Lee J" <faked@.fc.com> wrote in message
> news:ejg8fo$5s5@.dispatch.concentric.net...
>
Wednesday, March 21, 2012
MSSRS 2000 Restarts Windows XP system after the latest update
Hi Microsoft Sql server reproting services restarts the windows xp installed
desktops when we try to print using the print oprion in the report.
This is happening for lot of my clients.
How to fix this. This is happening only after the latest update in March.
My company has aroung 40,000 people who will be using the reports generated
by the reporting services most of them have windows xp with autometic update
switched on. Hence once the update happnes when they want to take a print out
of a report which shown using the MSSRS 2000 in internet explorere and
clicked onthe print icon in the report window system gets restarted.
Please help
Thanking you
SureshSuresh,
The first time you click the print icon a ActiveX control is installed. You
must have some sort of common desktop configuration that is blowing up when
you try to install this ActiveX.
First thing I would do is look at IE's security settings surrounding the
ActiveX downloading/installing.
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Suresh" <Suresh@.discussions.microsoft.com> wrote in message
news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> Hi Microsoft Sql server reproting services restarts the windows xp
> installed
> desktops when we try to print using the print oprion in the report.
> This is happening for lot of my clients.
> How to fix this. This is happening only after the latest update in March.
> My company has aroung 40,000 people who will be using the reports
> generated
> by the reporting services most of them have windows xp with autometic
> update
> switched on. Hence once the update happnes when they want to take a print
> out
> of a report which shown using the MSSRS 2000 in internet explorere and
> clicked onthe print icon in the report window system gets restarted.
> Please help
> Thanking you
> Suresh
>|||Thanks Andy.
But the issue is not with installing the active x.
In many systems the active x was installed long before.
It was working fine until recently a windws xp update was released.
After the update only when clicked on the print icon in the report displayed
in desktops the systems get restarted.
So this should be a bug introduced due to the recent update by Microsft
update for windows Xp. I am looking for a patch for this.
Regards
Suresh
"Andy Potter" wrote:
> Suresh,
> The first time you click the print icon a ActiveX control is installed. You
> must have some sort of common desktop configuration that is blowing up when
> you try to install this ActiveX.
> First thing I would do is look at IE's security settings surrounding the
> ActiveX downloading/installing.
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Suresh" <Suresh@.discussions.microsoft.com> wrote in message
> news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > Hi Microsoft Sql server reproting services restarts the windows xp
> > installed
> > desktops when we try to print using the print oprion in the report.
> >
> > This is happening for lot of my clients.
> > How to fix this. This is happening only after the latest update in March.
> >
> > My company has aroung 40,000 people who will be using the reports
> > generated
> > by the reporting services most of them have windows xp with autometic
> > update
> > switched on. Hence once the update happnes when they want to take a print
> > out
> > of a report which shown using the MSSRS 2000 in internet explorere and
> > clicked onthe print icon in the report window system gets restarted.
> >
> > Please help
> > Thanking you
> > Suresh
> >
> >
>
>|||Suresh,
We are facing the same problem..
I was searching around when i got something on this issue in the below
URL.
Not sure to what extent it will identify and solve this problem, but
may be worth a read.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
Please let us know if any body gets some solution to this
On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> Thanks Andy.
> But the issue is not with installing the active x.
> In many systems the active x was installed long before.
> It was working fine until recently a windws xp update was released.
> After the update only when clicked on theprinticon in the report displayed
> in desktops the systems get restarted.
> So this should be a bug introduced due to the recent update by Microsft
> update for windows Xp. I am looking for a patch for this.
> Regards
> Suresh
>
> "Andy Potter" wrote:
> > Suresh,
> > The first time you click theprinticon a ActiveX control is installed. You
> > must have some sort of common desktop configuration that is blowing up when
> > you try to install this ActiveX.
> > First thing I would do is look at IE's security settings surrounding the
> > ActiveX downloading/installing.
> > --
> > Andy Potter
> > blog :http://sqlreportingservices.spaces.live.com
> > info@.(NOSPAM)lakeclaireenterprises.com
> > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > installed
> > > desktops when we try toprintusing theprintoprion in the report.
> > > This is happening for lot of my clients.
> > > How to fix this. This is happening only after the latest update in March.
> > > My company has aroung 40,000 people who will be using the reports
> > > generated
> > > by thereporting servicesmost of them have windows xp with autometic
> > > update
> > > switched on. Hence once the update happnes when they want to take aprint
> > > out
> > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > clicked ontheprinticon in the report windowsystemgets restarted.
> > > Please help
> > > Thanking you
> > > Suresh- Hide quoted text -
> - Show quoted text -|||Hi Shocky,
It is really great. the link you have given actually solved my problem.
Thanks a lot for the help. This was the need of the hour for me.
Once again
Thanking you
Suresh
"Shocky" wrote:
> Suresh,
> We are facing the same problem..
> I was searching around when i got something on this issue in the below
> URL.
> Not sure to what extent it will identify and solve this problem, but
> may be worth a read.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
>
> Please let us know if any body gets some solution to this
>
> On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> > Thanks Andy.
> >
> > But the issue is not with installing the active x.
> >
> > In many systems the active x was installed long before.
> > It was working fine until recently a windws xp update was released.
> > After the update only when clicked on theprinticon in the report displayed
> > in desktops the systems get restarted.
> >
> > So this should be a bug introduced due to the recent update by Microsft
> > update for windows Xp. I am looking for a patch for this.
> >
> > Regards
> > Suresh
> >
> >
> >
> > "Andy Potter" wrote:
> > > Suresh,
> >
> > > The first time you click theprinticon a ActiveX control is installed. You
> > > must have some sort of common desktop configuration that is blowing up when
> > > you try to install this ActiveX.
> >
> > > First thing I would do is look at IE's security settings surrounding the
> > > ActiveX downloading/installing.
> >
> > > --
> > > Andy Potter
> > > blog :http://sqlreportingservices.spaces.live.com
> > > info@.(NOSPAM)lakeclaireenterprises.com
> > > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> > >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > > installed
> > > > desktops when we try toprintusing theprintoprion in the report.
> >
> > > > This is happening for lot of my clients.
> > > > How to fix this. This is happening only after the latest update in March.
> >
> > > > My company has aroung 40,000 people who will be using the reports
> > > > generated
> > > > by thereporting servicesmost of them have windows xp with autometic
> > > > update
> > > > switched on. Hence once the update happnes when they want to take aprint
> > > > out
> > > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > > clicked ontheprinticon in the report windowsystemgets restarted.
> >
> > > > Please help
> > > > Thanking you
> > > > Suresh- Hide quoted text -
> >
> > - Show quoted text -
>
>sql
desktops when we try to print using the print oprion in the report.
This is happening for lot of my clients.
How to fix this. This is happening only after the latest update in March.
My company has aroung 40,000 people who will be using the reports generated
by the reporting services most of them have windows xp with autometic update
switched on. Hence once the update happnes when they want to take a print out
of a report which shown using the MSSRS 2000 in internet explorere and
clicked onthe print icon in the report window system gets restarted.
Please help
Thanking you
SureshSuresh,
The first time you click the print icon a ActiveX control is installed. You
must have some sort of common desktop configuration that is blowing up when
you try to install this ActiveX.
First thing I would do is look at IE's security settings surrounding the
ActiveX downloading/installing.
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Suresh" <Suresh@.discussions.microsoft.com> wrote in message
news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> Hi Microsoft Sql server reproting services restarts the windows xp
> installed
> desktops when we try to print using the print oprion in the report.
> This is happening for lot of my clients.
> How to fix this. This is happening only after the latest update in March.
> My company has aroung 40,000 people who will be using the reports
> generated
> by the reporting services most of them have windows xp with autometic
> update
> switched on. Hence once the update happnes when they want to take a print
> out
> of a report which shown using the MSSRS 2000 in internet explorere and
> clicked onthe print icon in the report window system gets restarted.
> Please help
> Thanking you
> Suresh
>|||Thanks Andy.
But the issue is not with installing the active x.
In many systems the active x was installed long before.
It was working fine until recently a windws xp update was released.
After the update only when clicked on the print icon in the report displayed
in desktops the systems get restarted.
So this should be a bug introduced due to the recent update by Microsft
update for windows Xp. I am looking for a patch for this.
Regards
Suresh
"Andy Potter" wrote:
> Suresh,
> The first time you click the print icon a ActiveX control is installed. You
> must have some sort of common desktop configuration that is blowing up when
> you try to install this ActiveX.
> First thing I would do is look at IE's security settings surrounding the
> ActiveX downloading/installing.
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Suresh" <Suresh@.discussions.microsoft.com> wrote in message
> news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > Hi Microsoft Sql server reproting services restarts the windows xp
> > installed
> > desktops when we try to print using the print oprion in the report.
> >
> > This is happening for lot of my clients.
> > How to fix this. This is happening only after the latest update in March.
> >
> > My company has aroung 40,000 people who will be using the reports
> > generated
> > by the reporting services most of them have windows xp with autometic
> > update
> > switched on. Hence once the update happnes when they want to take a print
> > out
> > of a report which shown using the MSSRS 2000 in internet explorere and
> > clicked onthe print icon in the report window system gets restarted.
> >
> > Please help
> > Thanking you
> > Suresh
> >
> >
>
>|||Suresh,
We are facing the same problem..
I was searching around when i got something on this issue in the below
URL.
Not sure to what extent it will identify and solve this problem, but
may be worth a read.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
Please let us know if any body gets some solution to this
On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> Thanks Andy.
> But the issue is not with installing the active x.
> In many systems the active x was installed long before.
> It was working fine until recently a windws xp update was released.
> After the update only when clicked on theprinticon in the report displayed
> in desktops the systems get restarted.
> So this should be a bug introduced due to the recent update by Microsft
> update for windows Xp. I am looking for a patch for this.
> Regards
> Suresh
>
> "Andy Potter" wrote:
> > Suresh,
> > The first time you click theprinticon a ActiveX control is installed. You
> > must have some sort of common desktop configuration that is blowing up when
> > you try to install this ActiveX.
> > First thing I would do is look at IE's security settings surrounding the
> > ActiveX downloading/installing.
> > --
> > Andy Potter
> > blog :http://sqlreportingservices.spaces.live.com
> > info@.(NOSPAM)lakeclaireenterprises.com
> > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > installed
> > > desktops when we try toprintusing theprintoprion in the report.
> > > This is happening for lot of my clients.
> > > How to fix this. This is happening only after the latest update in March.
> > > My company has aroung 40,000 people who will be using the reports
> > > generated
> > > by thereporting servicesmost of them have windows xp with autometic
> > > update
> > > switched on. Hence once the update happnes when they want to take aprint
> > > out
> > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > clicked ontheprinticon in the report windowsystemgets restarted.
> > > Please help
> > > Thanking you
> > > Suresh- Hide quoted text -
> - Show quoted text -|||Hi Shocky,
It is really great. the link you have given actually solved my problem.
Thanks a lot for the help. This was the need of the hour for me.
Once again
Thanking you
Suresh
"Shocky" wrote:
> Suresh,
> We are facing the same problem..
> I was searching around when i got something on this issue in the below
> URL.
> Not sure to what extent it will identify and solve this problem, but
> may be worth a read.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1480005&SiteID=1
>
> Please let us know if any body gets some solution to this
>
> On Apr 17, 4:08 pm, Suresh <Sur...@.discussions.microsoft.com> wrote:
> > Thanks Andy.
> >
> > But the issue is not with installing the active x.
> >
> > In many systems the active x was installed long before.
> > It was working fine until recently a windws xp update was released.
> > After the update only when clicked on theprinticon in the report displayed
> > in desktops the systems get restarted.
> >
> > So this should be a bug introduced due to the recent update by Microsft
> > update for windows Xp. I am looking for a patch for this.
> >
> > Regards
> > Suresh
> >
> >
> >
> > "Andy Potter" wrote:
> > > Suresh,
> >
> > > The first time you click theprinticon a ActiveX control is installed. You
> > > must have some sort of common desktop configuration that is blowing up when
> > > you try to install this ActiveX.
> >
> > > First thing I would do is look at IE's security settings surrounding the
> > > ActiveX downloading/installing.
> >
> > > --
> > > Andy Potter
> > > blog :http://sqlreportingservices.spaces.live.com
> > > info@.(NOSPAM)lakeclaireenterprises.com
> > > "Suresh" <Sur...@.discussions.microsoft.com> wrote in message
> > >news:099AD7C4-D9BF-420A-A082-C0BB1438A79C@.microsoft.com...
> > > > Hi Microsoft Sql server reproting services restarts the windows xp
> > > > installed
> > > > desktops when we try toprintusing theprintoprion in the report.
> >
> > > > This is happening for lot of my clients.
> > > > How to fix this. This is happening only after the latest update in March.
> >
> > > > My company has aroung 40,000 people who will be using the reports
> > > > generated
> > > > by thereporting servicesmost of them have windows xp with autometic
> > > > update
> > > > switched on. Hence once the update happnes when they want to take aprint
> > > > out
> > > > of a report which shown using the MSSRS 2000 in internet explorere and
> > > > clicked ontheprinticon in the report windowsystemgets restarted.
> >
> > > > Please help
> > > > Thanking you
> > > > Suresh- Hide quoted text -
> >
> > - Show quoted text -
>
>sql
MSSQLServerOLAPService connection string name change
Hi all,
We had to rename the hostname of a server where SQL 2005 and Analysis
services were installed. SQL 2005 picked up the change no problem, but when
we try to connect to the Analysis services side of things, it's still
connecting to the old host name. I've been digging around and seen alot of
suggestions that say 'reinstall Analysis services' but I would prefer not to
if there is any other possibility.
If I do need to re-install, does anyone know if re-installing just analysis
services is possible, and how much of the existing data will be overwritten?
Any thoughts appreciated!!!
Edward
ebrooathealthydirectionsdotcomHit "rename sql server" on google. You'll get sites like
http://www.sql-server-performance.c...maintenance.asp which show
how to us sp_dropserver and sp_addserver. I have not had to do this very
often, but it works.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"EB" <ebroo@.healthydirections.com> wrote in message
news:eyuunmiaHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi all,
> We had to rename the hostname of a server where SQL 2005 and Analysis
> services were installed. SQL 2005 picked up the change no problem, but
> when we try to connect to the Analysis services side of things, it's still
> connecting to the old host name. I've been digging around and seen alot of
> suggestions that say 'reinstall Analysis services' but I would prefer not
> to if there is any other possibility.
> If I do need to re-install, does anyone know if re-installing just
> analysis services is possible, and how much of the existing data will be
> overwritten?
> Any thoughts appreciated!!!
> Edward
> ebrooathealthydirectionsdotcom
>
We had to rename the hostname of a server where SQL 2005 and Analysis
services were installed. SQL 2005 picked up the change no problem, but when
we try to connect to the Analysis services side of things, it's still
connecting to the old host name. I've been digging around and seen alot of
suggestions that say 'reinstall Analysis services' but I would prefer not to
if there is any other possibility.
If I do need to re-install, does anyone know if re-installing just analysis
services is possible, and how much of the existing data will be overwritten?
Any thoughts appreciated!!!
Edward
ebrooathealthydirectionsdotcomHit "rename sql server" on google. You'll get sites like
http://www.sql-server-performance.c...maintenance.asp which show
how to us sp_dropserver and sp_addserver. I have not had to do this very
often, but it works.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"EB" <ebroo@.healthydirections.com> wrote in message
news:eyuunmiaHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi all,
> We had to rename the hostname of a server where SQL 2005 and Analysis
> services were installed. SQL 2005 picked up the change no problem, but
> when we try to connect to the Analysis services side of things, it's still
> connecting to the old host name. I've been digging around and seen alot of
> suggestions that say 'reinstall Analysis services' but I would prefer not
> to if there is any other possibility.
> If I do need to re-install, does anyone know if re-installing just
> analysis services is possible, and how much of the existing data will be
> overwritten?
> Any thoughts appreciated!!!
> Edward
> ebrooathealthydirectionsdotcom
>
MSSQLServerOLAPService connection string name change
Hi all,
We had to rename the hostname of a server where SQL 2005 and Analysis
services were installed. SQL 2005 picked up the change no problem, but when
we try to connect to the Analysis services side of things, it's still
connecting to the old host name. I've been digging around and seen alot of
suggestions that say 'reinstall Analysis services' but I would prefer not to
if there is any other possibility.
If I do need to re-install, does anyone know if re-installing just analysis
services is possible, and how much of the existing data will be overwritten?
Any thoughts appreciated!!!
Edward
ebrooathealthydirectionsdotcom
Hit "rename sql server" on google. You'll get sites like
http://www.sql-server-performance.com/sql_server_maintenance.asp which show
how to us sp_dropserver and sp_addserver. I have not had to do this very
often, but it works.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"EB" <ebroo@.healthydirections.com> wrote in message
news:eyuunmiaHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi all,
> We had to rename the hostname of a server where SQL 2005 and Analysis
> services were installed. SQL 2005 picked up the change no problem, but
> when we try to connect to the Analysis services side of things, it's still
> connecting to the old host name. I've been digging around and seen alot of
> suggestions that say 'reinstall Analysis services' but I would prefer not
> to if there is any other possibility.
> If I do need to re-install, does anyone know if re-installing just
> analysis services is possible, and how much of the existing data will be
> overwritten?
> Any thoughts appreciated!!!
> Edward
> ebrooathealthydirectionsdotcom
>
sql
We had to rename the hostname of a server where SQL 2005 and Analysis
services were installed. SQL 2005 picked up the change no problem, but when
we try to connect to the Analysis services side of things, it's still
connecting to the old host name. I've been digging around and seen alot of
suggestions that say 'reinstall Analysis services' but I would prefer not to
if there is any other possibility.
If I do need to re-install, does anyone know if re-installing just analysis
services is possible, and how much of the existing data will be overwritten?
Any thoughts appreciated!!!
Edward
ebrooathealthydirectionsdotcom
Hit "rename sql server" on google. You'll get sites like
http://www.sql-server-performance.com/sql_server_maintenance.asp which show
how to us sp_dropserver and sp_addserver. I have not had to do this very
often, but it works.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"EB" <ebroo@.healthydirections.com> wrote in message
news:eyuunmiaHHA.4616@.TK2MSFTNGP03.phx.gbl...
> Hi all,
> We had to rename the hostname of a server where SQL 2005 and Analysis
> services were installed. SQL 2005 picked up the change no problem, but
> when we try to connect to the Analysis services side of things, it's still
> connecting to the old host name. I've been digging around and seen alot of
> suggestions that say 'reinstall Analysis services' but I would prefer not
> to if there is any other possibility.
> If I do need to re-install, does anyone know if re-installing just
> analysis services is possible, and how much of the existing data will be
> overwritten?
> Any thoughts appreciated!!!
> Edward
> ebrooathealthydirectionsdotcom
>
sql
mssqlserverADhelper service terminated, Access Denied when trying to connect
This problem just started recently. This computer connected to the database
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
----
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
.MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
----
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
----
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
----
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
.MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
----
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
----
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
mssqlserverADhelper service terminated, Access Denied when trying to connect
This problem just started recently. This computer connected to the database
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
..MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.
Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
..MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.
Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Monday, March 19, 2012
MSSQLServerADHelper
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
|||ah thks .. I thought it might have been something that did not belong ....
-BB
"TJ" <tunj@.hotmail.com> wrote in message news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
|||ah thks .. I thought it might have been something that did not belong ....
-BB
"TJ" <tunj@.hotmail.com> wrote in message news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
MSSQLServerADHelper
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BBThis is a multi-part message in MIME format.
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single =service handles the Active Directory objects for all instances of the =SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone =know
what it is?
Thx in advance..
-BB
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions: It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory objects =for the instance, as well as any replication publications and databases for =that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few sites =run their SQL Server service under either of these types of accounts. A =service application that does not perform network administration, such as SQL =Server, is rarely granted full domain administration rights. The localsystem =account cannot be given any privileges on remote computers; therefore, running =SQL Server under this account would prevent much of the SQL Server =distributed functionality from working. The MSSQLServerADHelper service is =run under the localsystem account so that it can add and remove objects =registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager applications =running on the computer.
"Brian Burgess" =wrote in message news:O$JIN2poEHA.3392=@.TK2MSFTNGP15.phx.gbl...Hi all,I have a service installed on my Win2KAdvancedServer called'MSSQLServerADHelper'. I cannot find any reference to this. Anyone knowwhat it is?Thx in advance..-BB
--=_NextPart_000_006B_01C4A28F.9FA9B9A0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
ah thks .. I thought it might have been something that did not belong =...
-BB
"TJ" <tunj@.hotmail.com> wrote in message =news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The =single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. =Anyone know
what it is?
Thx in advance..
-BB
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
ah thks .. I thought it might =have been something that did not belong ...
-BB
"TJ" wrote in message news:eLJLfiroEHA.2684=@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for = MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions:
It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and databases =for that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has = completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few =sites run their SQL Server service under either of these types of accounts. =A service application that does not perform network administration, such =as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote =computers; therefore, running SQL Server under this account would prevent much of =the SQL Server distributed functionality from working. The =MSSQLServerADHelper service is run under the localsystem account so that it can add =and remove objects registering SQL Server entities in the Active =Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances =of the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" =wrote in message news:O$JIN2poEHA.3392=@.TK2MSFTNGP15.phx.gbl...Hi all,I have a service installed on my Win2KAdvancedServer called'MSSQLServerADHelper'. I cannot find any reference =to this. Anyone knowwhat it is?Thx in advance..-BB
--=_NextPart_000_000B_01C4A3B3.808BDE20--
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BBThis is a multi-part message in MIME format.
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single =service handles the Active Directory objects for all instances of the =SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone =know
what it is?
Thx in advance..
-BB
--=_NextPart_000_006B_01C4A28F.9FA9B9A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions: It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory objects =for the instance, as well as any replication publications and databases for =that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few sites =run their SQL Server service under either of these types of accounts. A =service application that does not perform network administration, such as SQL =Server, is rarely granted full domain administration rights. The localsystem =account cannot be given any privileges on remote computers; therefore, running =SQL Server under this account would prevent much of the SQL Server =distributed functionality from working. The MSSQLServerADHelper service is =run under the localsystem account so that it can add and remove objects =registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager applications =running on the computer.
"Brian Burgess"
--=_NextPart_000_006B_01C4A28F.9FA9B9A0--|||This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
ah thks .. I thought it might have been something that did not belong =...
-BB
"TJ" <tunj@.hotmail.com> wrote in message =news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of =Microsoft=AE SQL ServerT 2000 relational database engine or Analysis =server in the Microsoft Windows=AE 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and =databases for that instance. The service is dynamically started by an instance of SQL Server or the =Analysis Manager when needed. The service is stopped as soon as it has =completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain =administration rights or that are running under the localsystem Windows =account. Few sites run their SQL Server service under either of these =types of accounts. A service application that does not perform network =administration, such as SQL Server, is rarely granted full domain =administration rights. The localsystem account cannot be given any =privileges on remote computers; therefore, running SQL Server under this =account would prevent much of the SQL Server distributed functionality =from working. The MSSQLServerADHelper service is run under the =localsystem account so that it can add and remove objects registering =SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The =single service handles the Active Directory objects for all instances of =the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message =news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. =Anyone know
what it is?
Thx in advance..
-BB
--=_NextPart_000_000B_01C4A3B3.808BDE20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
ah thks .. I thought it might =have been something that did not belong ...
-BB
"TJ"
According to Books Online: Search for = MSSQLServerADHelper
MSSQLServerADHelper =Service
The MSSQLServerADHelper service performs two functions:
It adds and removes the objects used to register instances of =Microsoft=AE SQL Server=99 2000 relational database engine or Analysis server in =the Microsoft Windows=AE 2000 Active Directory=99.
It ensures that the Windows account under which a SQL Server =service is running has permissions to update all of the Active Directory =objects for the instance, as well as any replication publications and databases =for that instance.
The service is dynamically started by an instance of SQL Server or =the Analysis Manager when needed. The service is stopped as soon as it has = completed its work.
Active Directory objects in a computer container can be created or =removed only by programs that have been assigned either domain administration =rights or that are running under the localsystem Windows account. Few =sites run their SQL Server service under either of these types of accounts. =A service application that does not perform network administration, such =as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote =computers; therefore, running SQL Server under this account would prevent much of =the SQL Server distributed functionality from working. The =MSSQLServerADHelper service is run under the localsystem account so that it can add =and remove objects registering SQL Server entities in the Active =Directory.
There is only one MSSQLServerADHelper service on a computer. =The single service handles the Active Directory objects for all instances =of the SQL Server relational database engine and all Analysis Manager =applications running on the computer.
"Brian Burgess"
--=_NextPart_000_000B_01C4A3B3.808BDE20--
MSSQLSERVER service isnt starting
Hi everybody!
I need to move data from SQL Server7 to SQLServer2000 that is installed on a different machine.
Could anybody please advise a good way to do that?
I've installed SQLServer7 on a new machine, stopped MSSQLSERVER service ,started SQLServer in a single user mode (using sqlservr.exe from Command Prompt),successfully restored master db from the backup. When I tried ro start MSSQLSERVER service via Services console, get message "Could not start the MSSQLSERVER service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error." I have Windows 2000 server.
Thank you in advanceHave you tried a detach and attach?|||detach and attach what? I use these sps dor databases. But I even can't start server|||check your private messages for my reply I hit the private message button by mistake when replying|||Thank you for your response. I know why I can't start server after restoring master db on the new machine from backup made on the old machine -- the physical names of the system dbs in the master backup point to the drives that do not exist on the new machine.
I need to move data from SQL Server7 to SQLServer2000 that is installed on a different machine.
Could anybody please advise a good way to do that?
I've installed SQLServer7 on a new machine, stopped MSSQLSERVER service ,started SQLServer in a single user mode (using sqlservr.exe from Command Prompt),successfully restored master db from the backup. When I tried ro start MSSQLSERVER service via Services console, get message "Could not start the MSSQLSERVER service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error." I have Windows 2000 server.
Thank you in advanceHave you tried a detach and attach?|||detach and attach what? I use these sps dor databases. But I even can't start server|||check your private messages for my reply I hit the private message button by mistake when replying|||Thank you for your response. I know why I can't start server after restoring master db on the new machine from backup made on the old machine -- the physical names of the system dbs in the master backup point to the drives that do not exist on the new machine.
Monday, March 12, 2012
MSSQLSERVER not showing in Services
Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10
Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>
|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another
>
|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>
|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10
Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>
|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another
>
|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>
|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?
MSSQLSERVER not showing in Services
Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
--
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
--
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> > Hello,
> >
> > We just installed SQL Server 2K on a user machine. For some reason,
> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
Services
> > to update the logon password when we change our NT password. First,
what do
> > we need to do to get MSSQLSERVER to show in Services and is there
another
> > way to update the logon password?
> >
> > --
> > Thanks in advance,
> >
> > sck10
> >
> >
>|||Perhaps you only installed the client components?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> Perhaps you installed it as a Named instance instead of a default
> instance. In that case, the
>> service name is MSSQL$InstanceName.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "sck10" <sck10@.online.nospam> wrote in message
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
>> > Hello,
>> >
>> > We just installed SQL Server 2K on a user machine. For some reason,
>> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
> Services
>> > to update the logon password when we change our NT password. First,
> what do
>> > we need to do to get MSSQLSERVER to show in Services and is there
> another
>> > way to update the logon password?
>> >
>> > --
>> > Thanks in advance,
>> >
>> > sck10
>> >
>> >
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
--
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance. In that case, the
service name is MSSQL$InstanceName.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
> to update the logon password when we change our NT password. First, what do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
--
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> > Hello,
> >
> > We just installed SQL Server 2K on a user machine. For some reason,
> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
Services
> > to update the logon password when we change our NT password. First,
what do
> > we need to do to get MSSQLSERVER to show in Services and is there
another
> > way to update the logon password?
> >
> > --
> > Thanks in advance,
> >
> > sck10
> >
> >
>|||Perhaps you only installed the client components?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> Perhaps you installed it as a Named instance instead of a default
> instance. In that case, the
>> service name is MSSQL$InstanceName.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "sck10" <sck10@.online.nospam> wrote in message
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
>> > Hello,
>> >
>> > We just installed SQL Server 2K on a user machine. For some reason,
>> > MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use
> Services
>> > to update the logon password when we change our NT password. First,
> what do
>> > we need to do to get MSSQLSERVER to show in Services and is there
> another
>> > way to update the logon password?
>> >
>> > --
>> > Thanks in advance,
>> >
>> > sck10
>> >
>> >
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?
MSSQLSERVER not showing in Services
Hello,
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance.
In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl..
.
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Service
s
> to update the logon password when we change our NT password. First, what
do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another[vbcol=seagreen]
>|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?
We just installed SQL Server 2K on a user machine. For some reason,
MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Services
to update the logon password when we change our NT password. First, what do
we need to do to get MSSQLSERVER to show in Services and is there another
way to update the logon password?
Thanks in advance,
sck10Perhaps you installed it as a Named instance instead of a default instance.
In that case, the
service name is MSSQL$InstanceName.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl..
.
> Hello,
> We just installed SQL Server 2K on a user machine. For some reason,
> MSSQLSERVER and SQLSERVERAGENT is not showing in Services. We use Service
s
> to update the logon password when we change our NT password. First, what
do
> we need to do to get MSSQLSERVER to show in Services and is there another
> way to update the logon password?
> --
> Thanks in advance,
> sck10
>|||Hi Tibor,
There isn't anything starting with MSSQL.
Thanks in advance,
sck10
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Perhaps you installed it as a Named instance instead of a default
instance. In that case, the
> service name is MSSQL$InstanceName.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "sck10" <sck10@.online.nospam> wrote in message
news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
Services[vbcol=seagreen]
what do[vbcol=seagreen]
another[vbcol=seagreen]
>|||Perhaps you only installed the client components?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:%23uMNzfihFHA.3544@.TK2MSFTNGP15.phx.gbl...
> instance. In that case, the
> news:%23c5Uv5hhFHA.720@.TK2MSFTNGP14.phx.gbl...
> Services
> what do
> another
>|||"sck10" <sck10@.online.nospam> wrote in message
news:OhdxPCjhFHA.1248@.TK2MSFTNGP12.phx.gbl...
> Hi Tibor,
> There isn't anything starting with MSSQL.
> --
> Thanks in advance,
> sck10
If you open a command prompt and type
net start mssqlserver
what happens?
MSSQLServer Express and Delphi application
Dear friends I have a problem with the use of DELPHI and MSSQLServer!
I have installed in a PC a MSSQLServer Express. The PC is connected
with a other via a small network. I have developed an application in DELPHI
which runs also in the two computers. I have regulated SQLServer so as
to is accessible via TCP/IP, make that I tryed after in the other PC I
installed SQL Server Management Studio Express and had access in the
database via the network. While in the beginning both applications
worked normaly and were connected regularly in the base suddenly
one day they couldn't be connected giving as message the following
"DataBase Server Error: SQL State: 08001, SQL Error Code: 17 ", as there was no server. That is to say without I have teased the
properties the access to DataBase was impossible via the application but possible via the SQL
Server Management Studio Express and the environment of Borland Delphi
2005 from both PC's. That is to say
suddenly only the application simply could not be connected. I tryed
a lot of solutions but no one it did not work. When I installed the
MSSQLServer Express in the other PC the application could be connected
from this but no from the other via network always giving the same
message. Has anyone any idea why I am in impasse from solutions!!!!
Thak you in advance!
It is hard to diagnose based on what you describe here. But it could be related to the connection protocols. The following article may help you :
http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx
|||Thank you my friend, I will use your advises as soon as possible and I wish they will help me!
MSSQLSERVER Error 17830
Hi,
Please help me with this before I get crazy....
Please help me with this before I get crazy....
I have VS 2005 and SQL server 2005 installed on XP ( with SP2 ) I create a new web project. Make a SQL connection to my database and configure the advanced options. Drag gridview component to my form and configure it to use the connection with edit option checked. When I run my form I can scroll and view the data with no problem at all. Even edit works fine BUT the changes to the row NEVER gets to the database. No error messages what so ever. XP:s Event View reports this:
Type: Error
Source: MSSQLSERVER
Class: Logon
Code: 17830
A network error occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 31 ms, enqueued 1 ms, network writes 1 ms, network reads 30 ms, establishing SSL 29 ms, negotiating SSPI 0 ms, validating login 0 ms. [CLIENT: <local machine>]
Any ideas what is wrong?
Regards, Jarmo
Is it possible that in the connection string in the client application you've specified the option to require encryption?If this is the case and the server doesn't have an SSL certificate configured from a trusted authority then the client driver may be dropping the connection during the SSL handshake because it doesn't trust the server's SSL certificate.
Hope this helps,
Vaughn
MSSQLSERVER and SQLExpress coexist?
i had sqlserver2000 (including the enterprise manager and desktop engine) and .net 2003 installed in my development machine, I developed a vb.net application that communicates with a locally hosted mssql db.
recently i had .net 2005 and MS Server 2005 installed, then I converted my application in .net 2005, after, I started having problem deploying the application and db together to client machine and even on my own development machine, it's all database communication sort of problems. (now i have SQL Server Management Studio Express CTP installed)
Did i make any mistake? should i uninstall sqlserver2000, .net 2003 before installing server2005 and .net 2005?
btw, in my explorer, C:\Program Files\Microsoft SQL Server, i have 5 subfolders: "80", "90", "MSSQL", "MSSQL.1" and "MSSQL$SETUPTESTAPPINS". i know that 80 and MSSQL are the folders for server2000, 90 and MSSQL.1 are probably server2005 folders. but what is "MSSQL$SETUPTESTAPPINS"? from the readme.txt i found it's related to server2000, but what is it about?
also, in my registry, HKEY_Local_Machine/Software/Microsoft/Microsoft SQL Server/, the value of "InstalledInstances" is MSSQL SETUP TESTAPPINS SQLEXPRESS, after i removed SQLServer2000 stuff, the key value became "SETUP TESTAPPINS SQLEXPRESS", Now i dont have server2000 in my system anymore, how come SETUP TESTAPPIN is still there?
sorry for my bad explanation, plz help
This question might be better answered in the Setup forum, but from what I can gather from your statements, I don't think you did anything wrong. SQL Server 2000 and SQL Server 2005 will coexist on a single machine, as will the .NET versions. That may be where your issue is.
If you can post the specific errors you're seeing, that might a better place to start.
Buck Woody
|||Hi,
Yes SQL 2000 and SQL Express / 2005 can coexists, i have MSDE and SQL Express installed on my system, it works without any problem.
Can you post error message from Windows Event Viewer and SQL Server Error Log
Hemantgiri S. Goswami
Subscribe to:
Posts (Atom)