Hello, I cannot install Reporting Services Developer Version, at the end of
the setup I got a message like:
Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify
that you have sufficient privileges to start system services.
I have SQL SP3a, IIS, .NET 2003 all in the same computer.
Just cannot find how to solve the problem, seems to be something with the
account used to start the service, but with neither the built in account, not
a computer admin account can continue. Have no problem creating the database,
just to start the service.
Help pleaseMy problem is solved; I think you only need to change the installation path
of RS during the setup, but the following are the steps I follow:
1. Uninstall RS
2. Clean all signs of RS in the registry, the service and components
Delete in the registry the entries in
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\RS Rep..
Delete the service from the command prompt
sc delete ReportServer
Delete the components in Component Services in
the control panel Administrative Tools in the COM+ Applications for the ISS
3. Install RS in a different path
I install RS in C:\Program Files\Microsoft SQL ServerRS
Also i rename the services in the setup to MSReportService, MSReports for
the
IIS part.
I have Windows XP with all in one box; I use a domain account, for the
services
and for the SQL login.
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Thursday, March 29, 2012
Error 18456" error message when you specify configuration database
I appreciate if some one please help me to solve the following problem
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
Regards
Error 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct password.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration. I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I click
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settings
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regards
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
Regards
Error 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct password.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration. I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I click
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settings
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regards
Error 18456" error message when you specify configuration database
I appreciate if some one please help me to solve the following problem
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
RegardsError 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct password.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration. I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I click
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settings
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regards|||Here it is not asking for any user, In database connection type, i have using
the option "user windows authentication" so i dont know which account its
going to use here to create the database.
Please help me out
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Error 18456
> Severity Level 14
> Message Text
> Login failed for user '%ls'.
>
> Make sure that the user you specified is correct and has the correct password.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Yakoob" wrote:
> > I appreciate if some one please help me to solve the following problem
> >
> >
> > SYMPTOMS
> >
> > I am runnning the Setup program to install Microsoft Windows SharePoint
> > Services. After the Setup program is completed successfully, I configure
> > Windows SharePoint Services settings in SharePoint Central Administration. I
> > then specify configuration database settings on the Set Configuration
> > Database Server page of SharePoint Central Administration, and then I click
> > OK. Then, I receive one of the following error messages:
> > "Error 18456" error message when you specify configuration database settings
> > on the Set Configuration Database Server page of SharePoint Central
> > Administrator"
> >
> > I have gone through the article on
> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> > Please let me know if some one came across this problem & i could solve it
> > with your support
> > Thanks in advance
> > Regards|||It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
error in the SQL Error log (Open SQL Enterprise Manager and connect to the
SQL Server instance in question and navigate to Management>SQL Server Logs)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> Here it is not asking for any user, In database connection type, i have
> using
> the option "user windows authentication" so i dont know which account its
> going to use here to create the database.
> Please help me out
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>> Error 18456
>> Severity Level 14
>> Message Text
>> Login failed for user '%ls'.
>>
>> Make sure that the user you specified is correct and has the correct
>> password.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Yakoob" wrote:
>> > I appreciate if some one please help me to solve the following problem
>> >
>> >
>> > SYMPTOMS
>> >
>> > I am runnning the Setup program to install Microsoft Windows SharePoint
>> > Services. After the Setup program is completed successfully, I
>> > configure
>> > Windows SharePoint Services settings in SharePoint Central
>> > Administration. I
>> > then specify configuration database settings on the Set Configuration
>> > Database Server page of SharePoint Central Administration, and then I
>> > click
>> > OK. Then, I receive one of the following error messages:
>> > "Error 18456" error message when you specify configuration database
>> > settings
>> > on the Set Configuration Database Server page of SharePoint Central
>> > Administrator"
>> >
>> > I have gone through the article on
>> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
>> > out.
>> > Please let me know if some one came across this problem & i could solve
>> > it
>> > with your support
>> > Thanks in advance
>> > Regards|||Thanks for your reply, yes i understand that it iw using NT AUTHORITY\NETWORK
SERVICE, but even this i didn't find in SQL server logs as you have
mentioned. If i have to check for correct password then where? because i am
not providing here any password during "set configuration database server". I
am selecting the following options which is mandatory as per installation
guide for MS project 2003 server.
1. Database server = "i give sql server name"
2. SQL server database name = "database name as sharepointdb"
3. selected the option "use windows authentication
4. then last option " users already have domain accounts. Do not creat
active directory accounts.
I dont see any NT AUTHORITY account in active directory to give permission
for database create or to see for its password, please let me know
Thanks & Regards
"Jasper Smith" wrote:
> It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
> error in the SQL Error log (Open SQL Enterprise Manager and connect to the
> SQL Server instance in question and navigate to Management>SQL Server Logs)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
> news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> > Here it is not asking for any user, In database connection type, i have
> > using
> > the option "user windows authentication" so i dont know which account its
> > going to use here to create the database.
> > Please help me out
> >
> > Thanks
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Error 18456
> >> Severity Level 14
> >> Message Text
> >> Login failed for user '%ls'.
> >>
> >>
> >> Make sure that the user you specified is correct and has the correct
> >> password.
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Yakoob" wrote:
> >>
> >> > I appreciate if some one please help me to solve the following problem
> >> >
> >> >
> >> > SYMPTOMS
> >> >
> >> > I am runnning the Setup program to install Microsoft Windows SharePoint
> >> > Services. After the Setup program is completed successfully, I
> >> > configure
> >> > Windows SharePoint Services settings in SharePoint Central
> >> > Administration. I
> >> > then specify configuration database settings on the Set Configuration
> >> > Database Server page of SharePoint Central Administration, and then I
> >> > click
> >> > OK. Then, I receive one of the following error messages:
> >> > "Error 18456" error message when you specify configuration database
> >> > settings
> >> > on the Set Configuration Database Server page of SharePoint Central
> >> > Administrator"
> >> >
> >> > I have gone through the article on
> >> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
> >> > out.
> >> > Please let me know if some one came across this problem & i could solve
> >> > it
> >> > with your support
> >> > Thanks in advance
> >> > Regards
>
>
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
RegardsError 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct password.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration. I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I click
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settings
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regards|||Here it is not asking for any user, In database connection type, i have using
the option "user windows authentication" so i dont know which account its
going to use here to create the database.
Please help me out
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Error 18456
> Severity Level 14
> Message Text
> Login failed for user '%ls'.
>
> Make sure that the user you specified is correct and has the correct password.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Yakoob" wrote:
> > I appreciate if some one please help me to solve the following problem
> >
> >
> > SYMPTOMS
> >
> > I am runnning the Setup program to install Microsoft Windows SharePoint
> > Services. After the Setup program is completed successfully, I configure
> > Windows SharePoint Services settings in SharePoint Central Administration. I
> > then specify configuration database settings on the Set Configuration
> > Database Server page of SharePoint Central Administration, and then I click
> > OK. Then, I receive one of the following error messages:
> > "Error 18456" error message when you specify configuration database settings
> > on the Set Configuration Database Server page of SharePoint Central
> > Administrator"
> >
> > I have gone through the article on
> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> > Please let me know if some one came across this problem & i could solve it
> > with your support
> > Thanks in advance
> > Regards|||It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
error in the SQL Error log (Open SQL Enterprise Manager and connect to the
SQL Server instance in question and navigate to Management>SQL Server Logs)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> Here it is not asking for any user, In database connection type, i have
> using
> the option "user windows authentication" so i dont know which account its
> going to use here to create the database.
> Please help me out
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>> Error 18456
>> Severity Level 14
>> Message Text
>> Login failed for user '%ls'.
>>
>> Make sure that the user you specified is correct and has the correct
>> password.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Yakoob" wrote:
>> > I appreciate if some one please help me to solve the following problem
>> >
>> >
>> > SYMPTOMS
>> >
>> > I am runnning the Setup program to install Microsoft Windows SharePoint
>> > Services. After the Setup program is completed successfully, I
>> > configure
>> > Windows SharePoint Services settings in SharePoint Central
>> > Administration. I
>> > then specify configuration database settings on the Set Configuration
>> > Database Server page of SharePoint Central Administration, and then I
>> > click
>> > OK. Then, I receive one of the following error messages:
>> > "Error 18456" error message when you specify configuration database
>> > settings
>> > on the Set Configuration Database Server page of SharePoint Central
>> > Administrator"
>> >
>> > I have gone through the article on
>> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
>> > out.
>> > Please let me know if some one came across this problem & i could solve
>> > it
>> > with your support
>> > Thanks in advance
>> > Regards|||Thanks for your reply, yes i understand that it iw using NT AUTHORITY\NETWORK
SERVICE, but even this i didn't find in SQL server logs as you have
mentioned. If i have to check for correct password then where? because i am
not providing here any password during "set configuration database server". I
am selecting the following options which is mandatory as per installation
guide for MS project 2003 server.
1. Database server = "i give sql server name"
2. SQL server database name = "database name as sharepointdb"
3. selected the option "use windows authentication
4. then last option " users already have domain accounts. Do not creat
active directory accounts.
I dont see any NT AUTHORITY account in active directory to give permission
for database create or to see for its password, please let me know
Thanks & Regards
"Jasper Smith" wrote:
> It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
> error in the SQL Error log (Open SQL Enterprise Manager and connect to the
> SQL Server instance in question and navigate to Management>SQL Server Logs)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
> news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> > Here it is not asking for any user, In database connection type, i have
> > using
> > the option "user windows authentication" so i dont know which account its
> > going to use here to create the database.
> > Please help me out
> >
> > Thanks
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Error 18456
> >> Severity Level 14
> >> Message Text
> >> Login failed for user '%ls'.
> >>
> >>
> >> Make sure that the user you specified is correct and has the correct
> >> password.
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Yakoob" wrote:
> >>
> >> > I appreciate if some one please help me to solve the following problem
> >> >
> >> >
> >> > SYMPTOMS
> >> >
> >> > I am runnning the Setup program to install Microsoft Windows SharePoint
> >> > Services. After the Setup program is completed successfully, I
> >> > configure
> >> > Windows SharePoint Services settings in SharePoint Central
> >> > Administration. I
> >> > then specify configuration database settings on the Set Configuration
> >> > Database Server page of SharePoint Central Administration, and then I
> >> > click
> >> > OK. Then, I receive one of the following error messages:
> >> > "Error 18456" error message when you specify configuration database
> >> > settings
> >> > on the Set Configuration Database Server page of SharePoint Central
> >> > Administrator"
> >> >
> >> > I have gone through the article on
> >> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
> >> > out.
> >> > Please let me know if some one came across this problem & i could solve
> >> > it
> >> > with your support
> >> > Thanks in advance
> >> > Regards
>
>
Error 18456" error message when you specify configuration database
I appreciate if some one please help me to solve the following problem
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
RegardsError 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct passwor
d.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration.
I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I clic
k
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settin
gs
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out
.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regardssql
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
RegardsError 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct passwor
d.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration.
I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I clic
k
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settin
gs
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out
.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regardssql
Tuesday, March 27, 2012
Error 17883 The Scheduler 0 appears to be hung
I get this message every time i try to take a backup. Both manually and via
the Scheduler. What is the problem?
--
Best wishesSee if these help:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/810885
-oj
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>I get this message every time i try to take a backup. Both manually and via
> the Scheduler. What is the problem?
> --
> Best wishes|||Well I do not know. The funny thing is that I get the same message if I
reboot the system ansd take a manual backup. The system get stuck takes
almost all of the processor power. I have then to kill enterprise manager.
Then the process lies there with the backup and I can not kill it. It
diseappears only with reboot.The reboot at that time is also extremely
difficult you have to shut off by the power button as the whole machine is
stucked. I then see the message in the error log.
If I take the backup via the scheduler nothing happends it only adds
processes until next reboot and then I see the message.
The system ran fine for over a month and then this suddenly happened. The
machine by the way is a two processor Dell.
"oj" wrote:
> See if these help:
> http://support.microsoft.com/kb/815056
> http://support.microsoft.com/kb/810885
>
> --
> -oj
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>
>|||Backups should not spike your CPUs. My guess is that you have another
problem on this server and it's hanging SQL. You should engage MS support
and have them review 17883 minidumps. You need to be on build 818 (MS03-031
patch) or higher to generate good minidumps.
Adrian
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...[vbcol=seagreen]
> Well I do not know. The funny thing is that I get the same message if I
> reboot the system ansd take a manual backup. The system get stuck takes
> almost all of the processor power. I have then to kill enterprise manager.
> Then the process lies there with the backup and I can not kill it. It
> diseappears only with reboot.The reboot at that time is also extremely
> difficult you have to shut off by the power button as the whole machine is
> stucked. I then see the message in the error log.
> If I take the backup via the scheduler nothing happends it only adds
> processes until next reboot and then I see the message.
> The system ran fine for over a month and then this suddenly happened. The
> machine by the way is a two processor Dell.
> "oj" wrote:
>|||I have just installed 818. How do I do a minidump then?
"Adrian Zajkeskovic" wrote:
> Backups should not spike your CPUs. My guess is that you have another
> problem on this server and it's hanging SQL. You should engage MS support
> and have them review 17883 minidumps. You need to be on build 818 (MS03-03
1
> patch) or higher to generate good minidumps.
> Adrian
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...
>
>|||Backups should not cause this but could trigger behavior that you don't
expect.
Perhaps this will help.
The 17883 is a generic message (often referred to as the service engine
light) indicating that the UMS scheduling mechanism has detected a
worker that is not properly yielding to other workers within SQL Server.
The message was added in SQL 2000 SP3 but a later build (8.00.818
Security patch) is required to get extended diags. When the error is
first encountered a mini-dump is generated capturing the state of the
non-yielding thread. The mini-dump can be used by SQL support to
determine where in the code the SQL Server is non-yielding.
Since SP3 Microsoft has corrected or protected the engine in approx 25
places in the SQL Server code base that may not yield to other workers
properly, diminishing concurrency of the database engine. That is why
you find so many references to upgrade to a later QFE. I generally
recommend going to 8.00.997 to obtain the majority of these corrections
if you have encountered the 17883 on SP3 (8.00.760) where the mini dump
is not generated so the cause can not be determined.
Future versions of SQL Server are working to make these mini-dumps
Watson enabled so they can be directly submitted to the Watson site and
automated responses generated.
The problems have ranged from SQL Server bugs to getting stuck in API
calls that should return quickly but from time to time do not. For
example if we make a call to a security API and the PDC/BDC does not
return a response for 60 seconds (unusual and unexpected) the worker
ties up the specific UMS scheduler.
Do not be mislead, the worker is still an NT thread or fiber and must
honor NT scheduling. The design of SQL Server (UMS scheduling) is such
that only a single worker on a given scheduler can be scheduled by the
OS at any point in time. As each completes major phases or work
(natural yield points) the UMS scheduler coordinates the scheduling of
another worker on the same scheduler. It is rather simple, each worker
does a WaitForSingleObject with in INFINITE timeout so NT does not see
them as a viable worker to schedule. When a the active worker finishes
the unit of work it signals the next worker and waits on its event and
the cycle continues. Without going into more detail in this thread it
is a very simplistic non-preemptive system inside the SQL Server setup
to maximize resource usage and increase scalability. There is not need
for a lock waiter to do anything until the lock owner signals it to
execute so use the CPU for something more meaningful.
Bob Dorr
Microsoft SQL Server Escalation Support - Senior EE
*** Sent via Developersdex http://www.codecomments.com ***sql
the Scheduler. What is the problem?
--
Best wishesSee if these help:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/810885
-oj
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>I get this message every time i try to take a backup. Both manually and via
> the Scheduler. What is the problem?
> --
> Best wishes|||Well I do not know. The funny thing is that I get the same message if I
reboot the system ansd take a manual backup. The system get stuck takes
almost all of the processor power. I have then to kill enterprise manager.
Then the process lies there with the backup and I can not kill it. It
diseappears only with reboot.The reboot at that time is also extremely
difficult you have to shut off by the power button as the whole machine is
stucked. I then see the message in the error log.
If I take the backup via the scheduler nothing happends it only adds
processes until next reboot and then I see the message.
The system ran fine for over a month and then this suddenly happened. The
machine by the way is a two processor Dell.
"oj" wrote:
> See if these help:
> http://support.microsoft.com/kb/815056
> http://support.microsoft.com/kb/810885
>
> --
> -oj
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>
>|||Backups should not spike your CPUs. My guess is that you have another
problem on this server and it's hanging SQL. You should engage MS support
and have them review 17883 minidumps. You need to be on build 818 (MS03-031
patch) or higher to generate good minidumps.
Adrian
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...[vbcol=seagreen]
> Well I do not know. The funny thing is that I get the same message if I
> reboot the system ansd take a manual backup. The system get stuck takes
> almost all of the processor power. I have then to kill enterprise manager.
> Then the process lies there with the backup and I can not kill it. It
> diseappears only with reboot.The reboot at that time is also extremely
> difficult you have to shut off by the power button as the whole machine is
> stucked. I then see the message in the error log.
> If I take the backup via the scheduler nothing happends it only adds
> processes until next reboot and then I see the message.
> The system ran fine for over a month and then this suddenly happened. The
> machine by the way is a two processor Dell.
> "oj" wrote:
>|||I have just installed 818. How do I do a minidump then?
"Adrian Zajkeskovic" wrote:
> Backups should not spike your CPUs. My guess is that you have another
> problem on this server and it's hanging SQL. You should engage MS support
> and have them review 17883 minidumps. You need to be on build 818 (MS03-03
1
> patch) or higher to generate good minidumps.
> Adrian
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...
>
>|||Backups should not cause this but could trigger behavior that you don't
expect.
Perhaps this will help.
The 17883 is a generic message (often referred to as the service engine
light) indicating that the UMS scheduling mechanism has detected a
worker that is not properly yielding to other workers within SQL Server.
The message was added in SQL 2000 SP3 but a later build (8.00.818
Security patch) is required to get extended diags. When the error is
first encountered a mini-dump is generated capturing the state of the
non-yielding thread. The mini-dump can be used by SQL support to
determine where in the code the SQL Server is non-yielding.
Since SP3 Microsoft has corrected or protected the engine in approx 25
places in the SQL Server code base that may not yield to other workers
properly, diminishing concurrency of the database engine. That is why
you find so many references to upgrade to a later QFE. I generally
recommend going to 8.00.997 to obtain the majority of these corrections
if you have encountered the 17883 on SP3 (8.00.760) where the mini dump
is not generated so the cause can not be determined.
Future versions of SQL Server are working to make these mini-dumps
Watson enabled so they can be directly submitted to the Watson site and
automated responses generated.
The problems have ranged from SQL Server bugs to getting stuck in API
calls that should return quickly but from time to time do not. For
example if we make a call to a security API and the PDC/BDC does not
return a response for 60 seconds (unusual and unexpected) the worker
ties up the specific UMS scheduler.
Do not be mislead, the worker is still an NT thread or fiber and must
honor NT scheduling. The design of SQL Server (UMS scheduling) is such
that only a single worker on a given scheduler can be scheduled by the
OS at any point in time. As each completes major phases or work
(natural yield points) the UMS scheduler coordinates the scheduling of
another worker on the same scheduler. It is rather simple, each worker
does a WaitForSingleObject with in INFINITE timeout so NT does not see
them as a viable worker to schedule. When a the active worker finishes
the unit of work it signals the next worker and waits on its event and
the cycle continues. Without going into more detail in this thread it
is a very simplistic non-preemptive system inside the SQL Server setup
to maximize resource usage and increase scalability. There is not need
for a lock waiter to do anything until the lock owner signals it to
execute so use the CPU for something more meaningful.
Bob Dorr
Microsoft SQL Server Escalation Support - Senior EE
*** Sent via Developersdex http://www.codecomments.com ***sql
Error 17883 The Scheduler 0 appears to be hung
I get this message every time i try to take a backup. Both manually and via
the Scheduler. What is the problem?
--
Best wishesSee if these help:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/810885
-oj
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>I get this message every time i try to take a backup. Both manually and via
> the Scheduler. What is the problem?
> --
> Best wishes|||Well I do not know. The funny thing is that I get the same message if I
reboot the system ansd take a manual backup. The system get stuck takes
almost all of the processor power. I have then to kill enterprise manager.
Then the process lies there with the backup and I can not kill it. It
diseappears only with reboot.The reboot at that time is also extremely
difficult you have to shut off by the power button as the whole machine is
stucked. I then see the message in the error log.
If I take the backup via the scheduler nothing happends it only adds
processes until next reboot and then I see the message.
The system ran fine for over a month and then this suddenly happened. The
machine by the way is a two processor Dell.
"oj" wrote:
> See if these help:
> http://support.microsoft.com/kb/815056
> http://support.microsoft.com/kb/810885
>
> --
> -oj
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
> >I get this message every time i try to take a backup. Both manually and via
> > the Scheduler. What is the problem?
> > --
> > Best wishes
>
>|||Backups should not spike your CPUs. My guess is that you have another
problem on this server and it's hanging SQL. You should engage MS support
and have them review 17883 minidumps. You need to be on build 818 (MS03-031
patch) or higher to generate good minidumps.
Adrian
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...
> Well I do not know. The funny thing is that I get the same message if I
> reboot the system ansd take a manual backup. The system get stuck takes
> almost all of the processor power. I have then to kill enterprise manager.
> Then the process lies there with the backup and I can not kill it. It
> diseappears only with reboot.The reboot at that time is also extremely
> difficult you have to shut off by the power button as the whole machine is
> stucked. I then see the message in the error log.
> If I take the backup via the scheduler nothing happends it only adds
> processes until next reboot and then I see the message.
> The system ran fine for over a month and then this suddenly happened. The
> machine by the way is a two processor Dell.
> "oj" wrote:
>> See if these help:
>> http://support.microsoft.com/kb/815056
>> http://support.microsoft.com/kb/810885
>>
>> --
>> -oj
>>
>> "Mats" <Mats@.discussions.microsoft.com> wrote in message
>> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>> >I get this message every time i try to take a backup. Both manually and
>> >via
>> > the Scheduler. What is the problem?
>> > --
>> > Best wishes
>>
the Scheduler. What is the problem?
--
Best wishesSee if these help:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/810885
-oj
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>I get this message every time i try to take a backup. Both manually and via
> the Scheduler. What is the problem?
> --
> Best wishes|||Well I do not know. The funny thing is that I get the same message if I
reboot the system ansd take a manual backup. The system get stuck takes
almost all of the processor power. I have then to kill enterprise manager.
Then the process lies there with the backup and I can not kill it. It
diseappears only with reboot.The reboot at that time is also extremely
difficult you have to shut off by the power button as the whole machine is
stucked. I then see the message in the error log.
If I take the backup via the scheduler nothing happends it only adds
processes until next reboot and then I see the message.
The system ran fine for over a month and then this suddenly happened. The
machine by the way is a two processor Dell.
"oj" wrote:
> See if these help:
> http://support.microsoft.com/kb/815056
> http://support.microsoft.com/kb/810885
>
> --
> -oj
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
> >I get this message every time i try to take a backup. Both manually and via
> > the Scheduler. What is the problem?
> > --
> > Best wishes
>
>|||Backups should not spike your CPUs. My guess is that you have another
problem on this server and it's hanging SQL. You should engage MS support
and have them review 17883 minidumps. You need to be on build 818 (MS03-031
patch) or higher to generate good minidumps.
Adrian
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...
> Well I do not know. The funny thing is that I get the same message if I
> reboot the system ansd take a manual backup. The system get stuck takes
> almost all of the processor power. I have then to kill enterprise manager.
> Then the process lies there with the backup and I can not kill it. It
> diseappears only with reboot.The reboot at that time is also extremely
> difficult you have to shut off by the power button as the whole machine is
> stucked. I then see the message in the error log.
> If I take the backup via the scheduler nothing happends it only adds
> processes until next reboot and then I see the message.
> The system ran fine for over a month and then this suddenly happened. The
> machine by the way is a two processor Dell.
> "oj" wrote:
>> See if these help:
>> http://support.microsoft.com/kb/815056
>> http://support.microsoft.com/kb/810885
>>
>> --
>> -oj
>>
>> "Mats" <Mats@.discussions.microsoft.com> wrote in message
>> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>> >I get this message every time i try to take a backup. Both manually and
>> >via
>> > the Scheduler. What is the problem?
>> > --
>> > Best wishes
>>
Error 17883 The Scheduler 0 appears to be hung
I get this message every time i try to take a backup. Both manually and via
the Scheduler. What is the problem?
Best wishes
See if these help:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/810885
-oj
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>I get this message every time i try to take a backup. Both manually and via
> the Scheduler. What is the problem?
> --
> Best wishes
|||Well I do not know. The funny thing is that I get the same message if I
reboot the system ansd take a manual backup. The system get stuck takes
almost all of the processor power. I have then to kill enterprise manager.
Then the process lies there with the backup and I can not kill it. It
diseappears only with reboot.The reboot at that time is also extremely
difficult you have to shut off by the power button as the whole machine is
stucked. I then see the message in the error log.
If I take the backup via the scheduler nothing happends it only adds
processes until next reboot and then I see the message.
The system ran fine for over a month and then this suddenly happened. The
machine by the way is a two processor Dell.
"oj" wrote:
> See if these help:
> http://support.microsoft.com/kb/815056
> http://support.microsoft.com/kb/810885
>
> --
> -oj
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>
>
|||Backups should not spike your CPUs. My guess is that you have another
problem on this server and it's hanging SQL. You should engage MS support
and have them review 17883 minidumps. You need to be on build 818 (MS03-031
patch) or higher to generate good minidumps.
Adrian
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...[vbcol=seagreen]
> Well I do not know. The funny thing is that I get the same message if I
> reboot the system ansd take a manual backup. The system get stuck takes
> almost all of the processor power. I have then to kill enterprise manager.
> Then the process lies there with the backup and I can not kill it. It
> diseappears only with reboot.The reboot at that time is also extremely
> difficult you have to shut off by the power button as the whole machine is
> stucked. I then see the message in the error log.
> If I take the backup via the scheduler nothing happends it only adds
> processes until next reboot and then I see the message.
> The system ran fine for over a month and then this suddenly happened. The
> machine by the way is a two processor Dell.
> "oj" wrote:
|||I have just installed 818. How do I do a minidump then?
"Adrian Zajkeskovic" wrote:
> Backups should not spike your CPUs. My guess is that you have another
> problem on this server and it's hanging SQL. You should engage MS support
> and have them review 17883 minidumps. You need to be on build 818 (MS03-031
> patch) or higher to generate good minidumps.
> Adrian
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...
>
>
|||Backups should not cause this but could trigger behavior that you don't
expect.
Perhaps this will help.
The 17883 is a generic message (often referred to as the service engine
light) indicating that the UMS scheduling mechanism has detected a
worker that is not properly yielding to other workers within SQL Server.
The message was added in SQL 2000 SP3 but a later build (8.00.818
Security patch) is required to get extended diags. When the error is
first encountered a mini-dump is generated capturing the state of the
non-yielding thread. The mini-dump can be used by SQL support to
determine where in the code the SQL Server is non-yielding.
Since SP3 Microsoft has corrected or protected the engine in approx 25
places in the SQL Server code base that may not yield to other workers
properly, diminishing concurrency of the database engine. That is why
you find so many references to upgrade to a later QFE. I generally
recommend going to 8.00.997 to obtain the majority of these corrections
if you have encountered the 17883 on SP3 (8.00.760) where the mini dump
is not generated so the cause can not be determined.
Future versions of SQL Server are working to make these mini-dumps
Watson enabled so they can be directly submitted to the Watson site and
automated responses generated.
The problems have ranged from SQL Server bugs to getting stuck in API
calls that should return quickly but from time to time do not. For
example if we make a call to a security API and the PDC/BDC does not
return a response for 60 seconds (unusual and unexpected) the worker
ties up the specific UMS scheduler.
Do not be mislead, the worker is still an NT thread or fiber and must
honor NT scheduling. The design of SQL Server (UMS scheduling) is such
that only a single worker on a given scheduler can be scheduled by the
OS at any point in time. As each completes major phases or work
(natural yield points) the UMS scheduler coordinates the scheduling of
another worker on the same scheduler. It is rather simple, each worker
does a WaitForSingleObject with in INFINITE timeout so NT does not see
them as a viable worker to schedule. When a the active worker finishes
the unit of work it signals the next worker and waits on its event and
the cycle continues. Without going into more detail in this thread it
is a very simplistic non-preemptive system inside the SQL Server setup
to maximize resource usage and increase scalability. There is not need
for a lock waiter to do anything until the lock owner signals it to
execute so use the CPU for something more meaningful.
Bob Dorr
Microsoft SQL Server Escalation Support - Senior EE
*** Sent via Developersdex http://www.codecomments.com ***
the Scheduler. What is the problem?
Best wishes
See if these help:
http://support.microsoft.com/kb/815056
http://support.microsoft.com/kb/810885
-oj
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>I get this message every time i try to take a backup. Both manually and via
> the Scheduler. What is the problem?
> --
> Best wishes
|||Well I do not know. The funny thing is that I get the same message if I
reboot the system ansd take a manual backup. The system get stuck takes
almost all of the processor power. I have then to kill enterprise manager.
Then the process lies there with the backup and I can not kill it. It
diseappears only with reboot.The reboot at that time is also extremely
difficult you have to shut off by the power button as the whole machine is
stucked. I then see the message in the error log.
If I take the backup via the scheduler nothing happends it only adds
processes until next reboot and then I see the message.
The system ran fine for over a month and then this suddenly happened. The
machine by the way is a two processor Dell.
"oj" wrote:
> See if these help:
> http://support.microsoft.com/kb/815056
> http://support.microsoft.com/kb/810885
>
> --
> -oj
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:289BEB45-7BDF-47DD-937F-0425DB689549@.microsoft.com...
>
>
|||Backups should not spike your CPUs. My guess is that you have another
problem on this server and it's hanging SQL. You should engage MS support
and have them review 17883 minidumps. You need to be on build 818 (MS03-031
patch) or higher to generate good minidumps.
Adrian
"Mats" <Mats@.discussions.microsoft.com> wrote in message
news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...[vbcol=seagreen]
> Well I do not know. The funny thing is that I get the same message if I
> reboot the system ansd take a manual backup. The system get stuck takes
> almost all of the processor power. I have then to kill enterprise manager.
> Then the process lies there with the backup and I can not kill it. It
> diseappears only with reboot.The reboot at that time is also extremely
> difficult you have to shut off by the power button as the whole machine is
> stucked. I then see the message in the error log.
> If I take the backup via the scheduler nothing happends it only adds
> processes until next reboot and then I see the message.
> The system ran fine for over a month and then this suddenly happened. The
> machine by the way is a two processor Dell.
> "oj" wrote:
|||I have just installed 818. How do I do a minidump then?
"Adrian Zajkeskovic" wrote:
> Backups should not spike your CPUs. My guess is that you have another
> problem on this server and it's hanging SQL. You should engage MS support
> and have them review 17883 minidumps. You need to be on build 818 (MS03-031
> patch) or higher to generate good minidumps.
> Adrian
>
> "Mats" <Mats@.discussions.microsoft.com> wrote in message
> news:3EB13F27-EDF3-47E6-9CBB-94A8960CAC20@.microsoft.com...
>
>
|||Backups should not cause this but could trigger behavior that you don't
expect.
Perhaps this will help.
The 17883 is a generic message (often referred to as the service engine
light) indicating that the UMS scheduling mechanism has detected a
worker that is not properly yielding to other workers within SQL Server.
The message was added in SQL 2000 SP3 but a later build (8.00.818
Security patch) is required to get extended diags. When the error is
first encountered a mini-dump is generated capturing the state of the
non-yielding thread. The mini-dump can be used by SQL support to
determine where in the code the SQL Server is non-yielding.
Since SP3 Microsoft has corrected or protected the engine in approx 25
places in the SQL Server code base that may not yield to other workers
properly, diminishing concurrency of the database engine. That is why
you find so many references to upgrade to a later QFE. I generally
recommend going to 8.00.997 to obtain the majority of these corrections
if you have encountered the 17883 on SP3 (8.00.760) where the mini dump
is not generated so the cause can not be determined.
Future versions of SQL Server are working to make these mini-dumps
Watson enabled so they can be directly submitted to the Watson site and
automated responses generated.
The problems have ranged from SQL Server bugs to getting stuck in API
calls that should return quickly but from time to time do not. For
example if we make a call to a security API and the PDC/BDC does not
return a response for 60 seconds (unusual and unexpected) the worker
ties up the specific UMS scheduler.
Do not be mislead, the worker is still an NT thread or fiber and must
honor NT scheduling. The design of SQL Server (UMS scheduling) is such
that only a single worker on a given scheduler can be scheduled by the
OS at any point in time. As each completes major phases or work
(natural yield points) the UMS scheduler coordinates the scheduling of
another worker on the same scheduler. It is rather simple, each worker
does a WaitForSingleObject with in INFINITE timeout so NT does not see
them as a viable worker to schedule. When a the active worker finishes
the unit of work it signals the next worker and waits on its event and
the cycle continues. Without going into more detail in this thread it
is a very simplistic non-preemptive system inside the SQL Server setup
to maximize resource usage and increase scalability. There is not need
for a lock waiter to do anything until the lock owner signals it to
execute so use the CPU for something more meaningful.
Bob Dorr
Microsoft SQL Server Escalation Support - Senior EE
*** Sent via Developersdex http://www.codecomments.com ***
Monday, March 26, 2012
Error 17805
We have an application that is using our SQL Server 2000 as a repository.
Occassionaly the application displays a "Severe Error Occured" message when
trying to execute a command against the DB.
The SQL Logs show "Error 17805 - Invalid buffer received from client" has
anyone any idea what this means?
We did not write the application so we have no way of knowing what it's
trying to do other than insert data into the database.
Thanks, for any help
BrianHi,
Normally this error occurs due to Network problems and are not critical at
all.
Please look in to the below link for more details;
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> We have an application that is using our SQL Server 2000 as a repository.
> Occassionaly the application displays a "Severe Error Occured" message
when
> trying to execute a command against the DB.
> The SQL Logs show "Error 17805 - Invalid buffer received from client" has
> anyone any idea what this means?
> We did not write the application so we have no way of knowing what it's
> trying to do other than insert data into the database.
> Thanks, for any help
> Brian
>|||Hari,
Thanks for the response, unfortunately I know the network is not the
problem, and whilst this is not causing any issues on the SQL DB, it is
critical as far as the application is concerned as it doesn't work :(
I have check MS KB and I have the latest SP installed, I have an identical
setup on another box and everything is working fine.
Any other clues?
Thanks again for your input
Brian
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Normally this error occurs due to Network problems and are not critical
at
> all.
> Please look in to the below link for more details;
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> Thanks
> Hari
> MCDBA
>
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > We have an application that is using our SQL Server 2000 as a
repository.
> > Occassionaly the application displays a "Severe Error Occured" message
> when
> > trying to execute a command against the DB.
> >
> > The SQL Logs show "Error 17805 - Invalid buffer received from client"
has
> > anyone any idea what this means?
> >
> > We did not write the application so we have no way of knowing what it's
> > trying to do other than insert data into the database.
> >
> > Thanks, for any help
> >
> > Brian
> >
> >
>|||Hi,
From the same machine, Did you tried connecting to SQL server using Query
Analyzer with TCP/IP as well as Named pipes seperately ?.
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
> Hari,
> Thanks for the response, unfortunately I know the network is not the
> problem, and whilst this is not causing any issues on the SQL DB, it is
> critical as far as the application is concerned as it doesn't work :(
> I have check MS KB and I have the latest SP installed, I have an identical
> setup on another box and everything is working fine.
> Any other clues?
> Thanks again for your input
> Brian
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > Normally this error occurs due to Network problems and are not critical
> at
> > all.
> >
> > Please look in to the below link for more details;
> >
> >
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
> >
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
> >
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> > fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> > "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> > news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > > We have an application that is using our SQL Server 2000 as a
> repository.
> > > Occassionaly the application displays a "Severe Error Occured" message
> > when
> > > trying to execute a command against the DB.
> > >
> > > The SQL Logs show "Error 17805 - Invalid buffer received from client"
> has
> > > anyone any idea what this means?
> > >
> > > We did not write the application so we have no way of knowing what
it's
> > > trying to do other than insert data into the database.
> > >
> > > Thanks, for any help
> > >
> > > Brian
> > >
> > >
> >
> >
>|||I can connect to it just fine, the application that I am having trouble with
is located on a seperate server and, for the most part, has no trouble
connecting to the DB. It's just certain screens that fail with this error.
The SQL Server itself is serving many applications on our network connecting
via TCP and Named Pipes, it's just this one app that is giving us a problem.
I think it's time to get in touch with application vendor to find out what
sort of command it's trying to execute.
Thanks,
Brian
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:e2LqXLn6DHA.1752@.tk2msftngp13.phx.gbl...
> Hi,
> From the same machine, Did you tried connecting to SQL server using Query
> Analyzer with TCP/IP as well as Named pipes seperately ?.
> Thanks
> Hari
> MCDBA
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
> > Hari,
> >
> > Thanks for the response, unfortunately I know the network is not the
> > problem, and whilst this is not causing any issues on the SQL DB, it is
> > critical as far as the application is concerned as it doesn't work :(
> >
> > I have check MS KB and I have the latest SP installed, I have an
identical
> > setup on another box and everything is working fine.
> >
> > Any other clues?
> >
> > Thanks again for your input
> >
> > Brian
> >
> >
> > "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> > news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > >
> > > Normally this error occurs due to Network problems and are not
critical
> > at
> > > all.
> > >
> > > Please look in to the below link for more details;
> > >
> > >
> >
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
> > >
> >
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
> > >
> >
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> > > fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > > "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> > > news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > > > We have an application that is using our SQL Server 2000 as a
> > repository.
> > > > Occassionaly the application displays a "Severe Error Occured"
message
> > > when
> > > > trying to execute a command against the DB.
> > > >
> > > > The SQL Logs show "Error 17805 - Invalid buffer received from
client"
> > has
> > > > anyone any idea what this means?
> > > >
> > > > We did not write the application so we have no way of knowing what
> it's
> > > > trying to do other than insert data into the database.
> > > >
> > > > Thanks, for any help
> > > >
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>
Occassionaly the application displays a "Severe Error Occured" message when
trying to execute a command against the DB.
The SQL Logs show "Error 17805 - Invalid buffer received from client" has
anyone any idea what this means?
We did not write the application so we have no way of knowing what it's
trying to do other than insert data into the database.
Thanks, for any help
BrianHi,
Normally this error occurs due to Network problems and are not critical at
all.
Please look in to the below link for more details;
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> We have an application that is using our SQL Server 2000 as a repository.
> Occassionaly the application displays a "Severe Error Occured" message
when
> trying to execute a command against the DB.
> The SQL Logs show "Error 17805 - Invalid buffer received from client" has
> anyone any idea what this means?
> We did not write the application so we have no way of knowing what it's
> trying to do other than insert data into the database.
> Thanks, for any help
> Brian
>|||Hari,
Thanks for the response, unfortunately I know the network is not the
problem, and whilst this is not causing any issues on the SQL DB, it is
critical as far as the application is concerned as it doesn't work :(
I have check MS KB and I have the latest SP installed, I have an identical
setup on another box and everything is working fine.
Any other clues?
Thanks again for your input
Brian
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Normally this error occurs due to Network problems and are not critical
at
> all.
> Please look in to the below link for more details;
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> Thanks
> Hari
> MCDBA
>
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > We have an application that is using our SQL Server 2000 as a
repository.
> > Occassionaly the application displays a "Severe Error Occured" message
> when
> > trying to execute a command against the DB.
> >
> > The SQL Logs show "Error 17805 - Invalid buffer received from client"
has
> > anyone any idea what this means?
> >
> > We did not write the application so we have no way of knowing what it's
> > trying to do other than insert data into the database.
> >
> > Thanks, for any help
> >
> > Brian
> >
> >
>|||Hi,
From the same machine, Did you tried connecting to SQL server using Query
Analyzer with TCP/IP as well as Named pipes seperately ?.
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
> Hari,
> Thanks for the response, unfortunately I know the network is not the
> problem, and whilst this is not causing any issues on the SQL DB, it is
> critical as far as the application is concerned as it doesn't work :(
> I have check MS KB and I have the latest SP installed, I have an identical
> setup on another box and everything is working fine.
> Any other clues?
> Thanks again for your input
> Brian
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > Normally this error occurs due to Network problems and are not critical
> at
> > all.
> >
> > Please look in to the below link for more details;
> >
> >
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
> >
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
> >
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> > fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> > "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> > news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > > We have an application that is using our SQL Server 2000 as a
> repository.
> > > Occassionaly the application displays a "Severe Error Occured" message
> > when
> > > trying to execute a command against the DB.
> > >
> > > The SQL Logs show "Error 17805 - Invalid buffer received from client"
> has
> > > anyone any idea what this means?
> > >
> > > We did not write the application so we have no way of knowing what
it's
> > > trying to do other than insert data into the database.
> > >
> > > Thanks, for any help
> > >
> > > Brian
> > >
> > >
> >
> >
>|||I can connect to it just fine, the application that I am having trouble with
is located on a seperate server and, for the most part, has no trouble
connecting to the DB. It's just certain screens that fail with this error.
The SQL Server itself is serving many applications on our network connecting
via TCP and Named Pipes, it's just this one app that is giving us a problem.
I think it's time to get in touch with application vendor to find out what
sort of command it's trying to execute.
Thanks,
Brian
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:e2LqXLn6DHA.1752@.tk2msftngp13.phx.gbl...
> Hi,
> From the same machine, Did you tried connecting to SQL server using Query
> Analyzer with TCP/IP as well as Named pipes seperately ?.
> Thanks
> Hari
> MCDBA
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
> > Hari,
> >
> > Thanks for the response, unfortunately I know the network is not the
> > problem, and whilst this is not causing any issues on the SQL DB, it is
> > critical as far as the application is concerned as it doesn't work :(
> >
> > I have check MS KB and I have the latest SP installed, I have an
identical
> > setup on another box and everything is working fine.
> >
> > Any other clues?
> >
> > Thanks again for your input
> >
> > Brian
> >
> >
> > "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> > news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > >
> > > Normally this error occurs due to Network problems and are not
critical
> > at
> > > all.
> > >
> > > Please look in to the below link for more details;
> > >
> > >
> >
>
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=0a0801c3
> > >
> >
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
> > >
> >
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D0a0801c366
> > > fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > >
> > >
> > > "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> > > news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
> > > > We have an application that is using our SQL Server 2000 as a
> > repository.
> > > > Occassionaly the application displays a "Severe Error Occured"
message
> > > when
> > > > trying to execute a command against the DB.
> > > >
> > > > The SQL Logs show "Error 17805 - Invalid buffer received from
client"
> > has
> > > > anyone any idea what this means?
> > > >
> > > > We did not write the application so we have no way of knowing what
> it's
> > > > trying to do other than insert data into the database.
> > > >
> > > > Thanks, for any help
> > > >
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>
Error 17805
We have an application that is using our SQL Server 2000 as a repository.
Occassionaly the application displays a "Severe Error Occured" message when
trying to execute a command against the DB.
The SQL Logs show "Error 17805 - Invalid buffer received from client" has
anyone any idea what this means?
We did not write the application so we have no way of knowing what it's
trying to do other than insert data into the database.
Thanks, for any help
BrianHi,
Normally this error occurs due to Network problems and are not critical at
all.
Please look in to the below link for more details;
http://groups.google.com/groups?hl=...hreadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF-8%26selm%3D0a0801c366
fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
when
Thanks for the response, unfortunately I know the network is not the
problem, and whilst this is not causing any issues on the SQL DB, it is
critical as far as the application is concerned as it doesn't work
I have check MS KB and I have the latest SP installed, I have an identical
setup on another box and everything is working fine.
Any other clues?
Thanks again for your input
Brian
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
at
http://groups.google.com/groups?hl=...hreadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
From the same machine, Did you tried connecting to SQL server using Query
Analyzer with TCP/IP as well as Named pipes seperately ?.
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
http://groups.google.com/groups?hl=...hreadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
is located on a seperate server and, for the most part, has no trouble
connecting to the DB. It's just certain screens that fail with this error.
The SQL Server itself is serving many applications on our network connecting
via TCP and Named Pipes, it's just this one app that is giving us a problem.
I think it's time to get in touch with application vendor to find out what
sort of command it's trying to execute.
Thanks,
Brian
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:e2LqXLn6DHA.1752@.tk2msftngp13.phx.gbl...
http://groups.google.com/groups?hl=...hreadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
Occassionaly the application displays a "Severe Error Occured" message when
trying to execute a command against the DB.
The SQL Logs show "Error 17805 - Invalid buffer received from client" has
anyone any idea what this means?
We did not write the application so we have no way of knowing what it's
trying to do other than insert data into the database.
Thanks, for any help
BrianHi,
Normally this error occurs due to Network problems and are not critical at
all.
Please look in to the below link for more details;
http://groups.google.com/groups?hl=...hreadm=0a0801c3
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/groups%3Fq%3D17805%2Bin%2B
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF-8%26selm%3D0a0801c366
fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
quote:
> We have an application that is using our SQL Server 2000 as a repository.
> Occassionaly the application displays a "Severe Error Occured" message
when
quote:|||Hari,
> trying to execute a command against the DB.
> The SQL Logs show "Error 17805 - Invalid buffer received from client" has
> anyone any idea what this means?
> We did not write the application so we have no way of knowing what it's
> trying to do other than insert data into the database.
> Thanks, for any help
> Brian
>
Thanks for the response, unfortunately I know the network is not the
problem, and whilst this is not causing any issues on the SQL DB, it is
critical as far as the application is concerned as it doesn't work
I have check MS KB and I have the latest SP installed, I have an identical
setup on another box and everything is working fine.
Any other clues?
Thanks again for your input
Brian
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
quote:
> Hi,
> Normally this error occurs due to Network problems and are not critical
at
quote:
> all.
> Please look in to the below link for more details;
>
http://groups.google.com/groups?hl=...hreadm=0a0801c3
quote:
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
quote:
darkred">
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
quote:|||Hi,
ed">
> fc%2524f930e9f0%2524a401280a%2540phx.gbl%26rnum%3D6
> Thanks
> Hari
> MCDBA
>
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#cUCzil6DHA.1852@.TK2MSFTNGP10.phx.gbl...
repository.[QUOTE]
> when
has[QUOTE]
>
From the same machine, Did you tried connecting to SQL server using Query
Analyzer with TCP/IP as well as Named pipes seperately ?.
Thanks
Hari
MCDBA
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
quote:
> Hari,
> Thanks for the response, unfortunately I know the network is not the
> problem, and whilst this is not causing any issues on the SQL DB, it is
> critical as far as the application is concerned as it doesn't work
> I have check MS KB and I have the latest SP installed, I have an identical
> setup on another box and everything is working fine.
> Any other clues?
> Thanks again for your input
> Brian
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uFYF7ol6DHA.2404@.TK2MSFTNGP11.phx.gbl...
> at
>
http://groups.google.com/groups?hl=...hreadm=0a0801c3
quote:
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
quote:
darkred">
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
quote:|||I can connect to it just fine, the application that I am having trouble with
ed">
> repository.
> has
it's[QUOTE]
>
is located on a seperate server and, for the most part, has no trouble
connecting to the DB. It's just certain screens that fail with this error.
The SQL Server itself is serving many applications on our network connecting
via TCP and Named Pipes, it's just this one app that is giving us a problem.
I think it's time to get in touch with application vendor to find out what
sort of command it's trying to execute.
Thanks,
Brian
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:e2LqXLn6DHA.1752@.tk2msftngp13.phx.gbl...
quote:
> Hi,
> From the same machine, Did you tried connecting to SQL server using Query
> Analyzer with TCP/IP as well as Named pipes seperately ?.
> Thanks
> Hari
> MCDBA
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:#FFbR1l6DHA.2488@.TK2MSFTNGP09.phx.gbl...
identical[QUOTE]
critical[QUOTE]
>
http://groups.google.com/groups?hl=...hreadm=0a0801c3
quote:
>
66fc%24f930e9f0%24a401280a%40phx.gbl&rnum=6&prev=/ groups%3Fq%3D17805%2Bin%2B
quote:
darkred">
>
sql%2Bserver%26hl%3Den%26lr%3D%26ie%3DUT
F-8%26oe%3DUTF- 8%26selm%3D0a0801c366
quote:
ed">
message[QUOTE]
client"[QUOTE]
> it's
>
Thursday, March 22, 2012
Error 156 Creating View
I tried writing the following statement in a stored procedure, and I get an
Error message: "Error 156: Incorrect syntax near the keyword 'VIEW'."
CREATE VIEW VW_TotalAccepted
AS
SELECT [CustID], [ReqNo], Sum([AcceptedQty]) AS [Total]
FROM [DelDetail]
GROUP BY [DelDetail].[CustID], [DelDetail].[ReqNo]
What's wrong with the syntax? Isn't it the way to create a View?You cannot create a VIEW inside a SP
"wrytat" wrote:
> I tried writing the following statement in a stored procedure, and I get a
n
> Error message: "Error 156: Incorrect syntax near the keyword 'VIEW'."
> CREATE VIEW VW_TotalAccepted
> AS
> SELECT [CustID], [ReqNo], Sum([AcceptedQty]) AS [Total]
> FROM [DelDetail]
> GROUP BY [DelDetail].[CustID], [DelDetail].[ReqNo]
> What's wrong with the syntax? Isn't it the way to create a View?|||Then... Just ask a stupid question regarding View. If I add a new row or
change some values of some columns in a table that is included in a View
after creating the View, will the change be reflected in the View?
"Chandra" wrote:
> You cannot create a VIEW inside a SP
> "wrytat" wrote:
>|||Yes. A view doesn't store any data, it is only a "view" into the data stored
in your tables.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"wrytat" <wrytat@.discussions.microsoft.com> wrote in message
news:B14BFAD9-CF63-4645-A61C-86AA8854F4D1@.microsoft.com...
> Then... Just ask a stupid question regarding View. If I add a new row or
> change some values of some columns in a table that is included in a View
> after creating the View, will the change be reflected in the View?
> "Chandra" wrote:
>|||Yes. View doesnt store any data. Selecting rows from a view is as good as
executing the query that created it.
We go for views because, it improves the performance of a query.
thanks and regards
Chandra
"wrytat" wrote:
> Then... Just ask a stupid question regarding View. If I add a new row or
> change some values of some columns in a table that is included in a View
> after creating the View, will the change be reflected in the View?
> "Chandra" wrote:
>
Error message: "Error 156: Incorrect syntax near the keyword 'VIEW'."
CREATE VIEW VW_TotalAccepted
AS
SELECT [CustID], [ReqNo], Sum([AcceptedQty]) AS [Total]
FROM [DelDetail]
GROUP BY [DelDetail].[CustID], [DelDetail].[ReqNo]
What's wrong with the syntax? Isn't it the way to create a View?You cannot create a VIEW inside a SP
"wrytat" wrote:
> I tried writing the following statement in a stored procedure, and I get a
n
> Error message: "Error 156: Incorrect syntax near the keyword 'VIEW'."
> CREATE VIEW VW_TotalAccepted
> AS
> SELECT [CustID], [ReqNo], Sum([AcceptedQty]) AS [Total]
> FROM [DelDetail]
> GROUP BY [DelDetail].[CustID], [DelDetail].[ReqNo]
> What's wrong with the syntax? Isn't it the way to create a View?|||Then... Just ask a stupid question regarding View. If I add a new row or
change some values of some columns in a table that is included in a View
after creating the View, will the change be reflected in the View?
"Chandra" wrote:
> You cannot create a VIEW inside a SP
> "wrytat" wrote:
>|||Yes. A view doesn't store any data, it is only a "view" into the data stored
in your tables.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"wrytat" <wrytat@.discussions.microsoft.com> wrote in message
news:B14BFAD9-CF63-4645-A61C-86AA8854F4D1@.microsoft.com...
> Then... Just ask a stupid question regarding View. If I add a new row or
> change some values of some columns in a table that is included in a View
> after creating the View, will the change be reflected in the View?
> "Chandra" wrote:
>|||Yes. View doesnt store any data. Selecting rows from a view is as good as
executing the query that created it.
We go for views because, it improves the performance of a query.
thanks and regards
Chandra
"wrytat" wrote:
> Then... Just ask a stupid question regarding View. If I add a new row or
> change some values of some columns in a table that is included in a View
> after creating the View, will the change be reflected in the View?
> "Chandra" wrote:
>
Error 15401 windows NT user or group not found+sql 2000
hi all,
i'm doing replication now ...when i add a new login to sqlserver i got
the message if i click ok..."Error 15401 windows NT user or group not
found"...i don't understand......why the error happens.......any one
pls help me!!
--thank youSQL Server cannot resolve the name of the login you specified. The name may
be incorrect, or it may belong to a different domain to which your current
domain does not have access.
Thanks
Laurentiu
Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"nafi" <hnbnafisha@.gmail.com> wrote in message
news:1168574381.666181.290820@.a75g2000cwd.googlegroups.com...
> hi all,
> i'm doing replication now ...when i add a new login to sqlserver i got
> the message if i click ok..."Error 15401 windows NT user or group not
> found"...i don't understand......why the error happens.......any one
> pls help me!!
> --thank you
>|||hi Mr.Laurentiu Cristofor,
thank u very much....yeh.. correct...my computer doesn't have access
to that domain
Laurentiu Cristofor [MSFT] wrote:[vbcol=seagreen]
> SQL Server cannot resolve the name of the login you specified. The name ma
y
> be incorrect, or it may belong to a different domain to which your current
> domain does not have access.
> Thanks
> Laurentiu
> --
> Laurentiu Cristofor [MSFT]
> Software Development Engineer
> SQL Server Engine
> http://blogs.msdn.com/lcris/
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "nafi" <hnbnafisha@.gmail.com> wrote in message
> news:1168574381.666181.290820@.a75g2000cwd.googlegroups.com...
i'm doing replication now ...when i add a new login to sqlserver i got
the message if i click ok..."Error 15401 windows NT user or group not
found"...i don't understand......why the error happens.......any one
pls help me!!
--thank youSQL Server cannot resolve the name of the login you specified. The name may
be incorrect, or it may belong to a different domain to which your current
domain does not have access.
Thanks
Laurentiu
Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"nafi" <hnbnafisha@.gmail.com> wrote in message
news:1168574381.666181.290820@.a75g2000cwd.googlegroups.com...
> hi all,
> i'm doing replication now ...when i add a new login to sqlserver i got
> the message if i click ok..."Error 15401 windows NT user or group not
> found"...i don't understand......why the error happens.......any one
> pls help me!!
> --thank you
>|||hi Mr.Laurentiu Cristofor,
thank u very much....yeh.. correct...my computer doesn't have access
to that domain
Laurentiu Cristofor [MSFT] wrote:[vbcol=seagreen]
> SQL Server cannot resolve the name of the login you specified. The name ma
y
> be incorrect, or it may belong to a different domain to which your current
> domain does not have access.
> Thanks
> Laurentiu
> --
> Laurentiu Cristofor [MSFT]
> Software Development Engineer
> SQL Server Engine
> http://blogs.msdn.com/lcris/
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "nafi" <hnbnafisha@.gmail.com> wrote in message
> news:1168574381.666181.290820@.a75g2000cwd.googlegroups.com...
Error 1534
While checking the error log of a SQL 6.5 server, I found the following error
message: 1534 - Extent 28 not found in shared extent directory. The error
occurred during a DBCC check. Several more DBCC checks have been run against
the same database without giving this error. What does it mean?
The server in question is at SP 5a.
Daniel InmanHi
You have corruption in your database. You may need to restore from your last
known good backup.
SQL Server 6.5 is no longer supported by Microsoft, but PSS might be able to
help you fix the corruption. http://support.microsoft.com/gp/lifesrvr
Regards
Mike
"Daniel Inman" wrote:
> While checking the error log of a SQL 6.5 server, I found the following error
> message: 1534 - Extent 28 not found in shared extent directory. The error
> occurred during a DBCC check. Several more DBCC checks have been run against
> the same database without giving this error. What does it mean?
> The server in question is at SP 5a.
> Daniel Inman
message: 1534 - Extent 28 not found in shared extent directory. The error
occurred during a DBCC check. Several more DBCC checks have been run against
the same database without giving this error. What does it mean?
The server in question is at SP 5a.
Daniel InmanHi
You have corruption in your database. You may need to restore from your last
known good backup.
SQL Server 6.5 is no longer supported by Microsoft, but PSS might be able to
help you fix the corruption. http://support.microsoft.com/gp/lifesrvr
Regards
Mike
"Daniel Inman" wrote:
> While checking the error log of a SQL 6.5 server, I found the following error
> message: 1534 - Extent 28 not found in shared extent directory. The error
> occurred during a DBCC check. Several more DBCC checks have been run against
> the same database without giving this error. What does it mean?
> The server in question is at SP 5a.
> Daniel Inman
Error 15023: User already exists in current database
If you get this message : Error 15023: User already exists in current
database
then try following:
delete the user from database-folder--> user-tab and also delete user
for security-folder--> logins
and then create same user againYou can use sp_change_users_login to fix that. Here are some links that may
help:
http://www.databasejournal.com/feat...cle.php/2228611
Transferring Logins
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly
SQL Server MVP
"Sonal Chauhan" <sj2909@.yahoo.com> wrote in message
news:1e44a73a.0406071204.6d79cfb7@.posting.google.com...
> If you get this message : Error 15023: User already exists in current
> database
> then try following:
> delete the user from database-folder--> user-tab and also delete user
> for security-folder--> logins
> and then create same user again
database
then try following:
delete the user from database-folder--> user-tab and also delete user
for security-folder--> logins
and then create same user againYou can use sp_change_users_login to fix that. Here are some links that may
help:
http://www.databasejournal.com/feat...cle.php/2228611
Transferring Logins
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly
SQL Server MVP
"Sonal Chauhan" <sj2909@.yahoo.com> wrote in message
news:1e44a73a.0406071204.6d79cfb7@.posting.google.com...
> If you get this message : Error 15023: User already exists in current
> database
> then try following:
> delete the user from database-folder--> user-tab and also delete user
> for security-folder--> logins
> and then create same user again
Wednesday, March 21, 2012
Error 14258: ... SQL ServerAgent is starting
Whenever I attempt to edit/run/... a scheduled job, I get the error message:
"Error 14258: Cannot perform this operation while SQL ServerAgent is
starting. Try again later."
I also notice that all scheduled jobs have "Date/time not available" in
"Next Run Date".
Of course Agent is not starting now, it has already started (Alerts and
Operators can be edited without a problem). The server is SQL2000, SP4.
Check the status of the service from Administrative Tools -
is the service Running or Starting?
Alerts and operators can be edited without Agent running.
Also check your Agent.out file.
-Sue
On Thu, 16 Feb 2006 03:55:29 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
>Whenever I attempt to edit/run/... a scheduled job, I get the error message:
>"Error 14258: Cannot perform this operation while SQL ServerAgent is
>starting. Try again later."
>I also notice that all scheduled jobs have "Date/time not available" in
>"Next Run Date".
>Of course Agent is not starting now, it has already started (Alerts and
>Operators can be edited without a problem). The server is SQL2000, SP4.
|||The service IS running. I restarted it to make sure though, as I also did
with the server and the machine; nothing worked. The service is reported to
be running in both enterprise manager and windows services but no scheduled
jobs can be edited/run/...etc.
Also, when I stop the service I can edit jobs or create new ones, but there
is no way to run them.
There is no Agent.out file.
"Sue Hoegemeier" wrote:
> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||ok, I checked SQLAgent.out file. It has one entry:
"... ? [393] Waiting for SQL Server to recover databases..."
but I don't understand which databases it is recovering as there is no such
indication in SQL server logs or Current activity.
"Sue Hoegemeier" wrote:
> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||If you tried stopping and then restarting just the Agent
service and it won't start, reporting the same error then my
guess would be that you are running SQL Server in
lightweight pooling mode. Set it back to the default of
thread mode.
sp_configure 'allow updates', 1
go
reconfigure with override
go
sp_configure 'lightweight pooling', 0
go
reconfigure with override
go
-Sue
On Fri, 17 Feb 2006 00:41:28 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>ok, I checked SQLAgent.out file. It has one entry:
>"... ? [393] Waiting for SQL Server to recover databases..."
>but I don't understand which databases it is recovering as there is no such
>indication in SQL server logs or Current activity.
>
>"Sue Hoegemeier" wrote:
"Error 14258: Cannot perform this operation while SQL ServerAgent is
starting. Try again later."
I also notice that all scheduled jobs have "Date/time not available" in
"Next Run Date".
Of course Agent is not starting now, it has already started (Alerts and
Operators can be edited without a problem). The server is SQL2000, SP4.
Check the status of the service from Administrative Tools -
is the service Running or Starting?
Alerts and operators can be edited without Agent running.
Also check your Agent.out file.
-Sue
On Thu, 16 Feb 2006 03:55:29 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
>Whenever I attempt to edit/run/... a scheduled job, I get the error message:
>"Error 14258: Cannot perform this operation while SQL ServerAgent is
>starting. Try again later."
>I also notice that all scheduled jobs have "Date/time not available" in
>"Next Run Date".
>Of course Agent is not starting now, it has already started (Alerts and
>Operators can be edited without a problem). The server is SQL2000, SP4.
|||The service IS running. I restarted it to make sure though, as I also did
with the server and the machine; nothing worked. The service is reported to
be running in both enterprise manager and windows services but no scheduled
jobs can be edited/run/...etc.
Also, when I stop the service I can edit jobs or create new ones, but there
is no way to run them.
There is no Agent.out file.
"Sue Hoegemeier" wrote:
> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||ok, I checked SQLAgent.out file. It has one entry:
"... ? [393] Waiting for SQL Server to recover databases..."
but I don't understand which databases it is recovering as there is no such
indication in SQL server logs or Current activity.
"Sue Hoegemeier" wrote:
> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||If you tried stopping and then restarting just the Agent
service and it won't start, reporting the same error then my
guess would be that you are running SQL Server in
lightweight pooling mode. Set it back to the default of
thread mode.
sp_configure 'allow updates', 1
go
reconfigure with override
go
sp_configure 'lightweight pooling', 0
go
reconfigure with override
go
-Sue
On Fri, 17 Feb 2006 00:41:28 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>ok, I checked SQLAgent.out file. It has one entry:
>"... ? [393] Waiting for SQL Server to recover databases..."
>but I don't understand which databases it is recovering as there is no such
>indication in SQL server logs or Current activity.
>
>"Sue Hoegemeier" wrote:
Monday, March 19, 2012
error -132
hello
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto González" wrote:
> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>|||Getting the same thing - any ideas?
"Paul J" wrote:
[vbcol=seagreen]
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto González" wrote:
>|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a. MSDTC - Microsoft Distributed Transaction Coordinator
b. MSSEARCH - Microsoft Search
c. ReportServer - SQL Reporting Services
d. SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
[vbcol=seagreen]
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
>|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
[vbcol=seagreen]
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a. MSDTC - Microsoft Distributed Transaction Coordinator
> b. MSSEARCH - Microsoft Search
> c. ReportServer - SQL Reporting Services
> d. SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
>|||I am pretty sure this error occurs because a handle is open to a file(s) tha
t
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
[vbcol=seagreen]
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:
>
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto González" wrote:
> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>|||Getting the same thing - any ideas?
"Paul J" wrote:
[vbcol=seagreen]
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto González" wrote:
>|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a. MSDTC - Microsoft Distributed Transaction Coordinator
b. MSSEARCH - Microsoft Search
c. ReportServer - SQL Reporting Services
d. SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
[vbcol=seagreen]
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
>|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
[vbcol=seagreen]
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a. MSDTC - Microsoft Distributed Transaction Coordinator
> b. MSSEARCH - Microsoft Search
> c. ReportServer - SQL Reporting Services
> d. SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
>|||I am pretty sure this error occurs because a handle is open to a file(s) tha
t
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
[vbcol=seagreen]
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:
>
error -132
hello
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto González" wrote:
> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>|||Getting the same thing - any ideas?
"Paul J" wrote:
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto González" wrote:
> > hello
> >
> >
> > I try to install the anallysis Server but when I start the program shows
> > me the next message
> >
> > "moving data error -132"
> >
> > I've got a windows 2k server sp4 and sql server 2k
> >
> > thanks.
> >
> >
> >
> >|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a. MSDTC - Microsoft Distributed Transaction Coordinator
b. MSSEARCH - Microsoft Search
c. ReportServer - SQL Reporting Services
d. SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
> > Any workaround for this? I am getting the same error when trying to apply
> > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> >
> > "Alberto González" wrote:
> >
> > > hello
> > >
> > >
> > > I try to install the anallysis Server but when I start the program shows
> > > me the next message
> > >
> > > "moving data error -132"
> > >
> > > I've got a windows 2k server sp4 and sql server 2k
> > >
> > > thanks.
> > >
> > >
> > >
> > >|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a. MSDTC - Microsoft Distributed Transaction Coordinator
> b. MSSEARCH - Microsoft Search
> c. ReportServer - SQL Reporting Services
> d. SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
> > Getting the same thing - any ideas?
> >
> >
> > "Paul J" wrote:
> >
> > > Any workaround for this? I am getting the same error when trying to apply
> > > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> > >
> > > "Alberto González" wrote:
> > >
> > > > hello
> > > >
> > > >
> > > > I try to install the anallysis Server but when I start the program shows
> > > > me the next message
> > > >
> > > > "moving data error -132"
> > > >
> > > > I've got a windows 2k server sp4 and sql server 2k
> > > >
> > > > thanks.
> > > >
> > > >
> > > >
> > > >|||I am pretty sure this error occurs because a handle is open to a file(s) that
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:
> > The following worked for me. Make sure the following services are stopped
> > when applying SP4.
> >
> > a. MSDTC - Microsoft Distributed Transaction Coordinator
> > b. MSSEARCH - Microsoft Search
> > c. ReportServer - SQL Reporting Services
> > d. SQL Server Databases. Example, MOM or BizTalk
> >
> > I hope this helps.
> > Paul J.
> > "Todd Bell" wrote:
> >
> > > Getting the same thing - any ideas?
> > >
> > >
> > > "Paul J" wrote:
> > >
> > > > Any workaround for this? I am getting the same error when trying to apply
> > > > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> > > >
> > > > "Alberto González" wrote:
> > > >
> > > > > hello
> > > > >
> > > > >
> > > > > I try to install the anallysis Server but when I start the program shows
> > > > > me the next message
> > > > >
> > > > > "moving data error -132"
> > > > >
> > > > > I've got a windows 2k server sp4 and sql server 2k
> > > > >
> > > > > thanks.
> > > > >
> > > > >
> > > > >
> > > > >
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto González" wrote:
> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>|||Getting the same thing - any ideas?
"Paul J" wrote:
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto González" wrote:
> > hello
> >
> >
> > I try to install the anallysis Server but when I start the program shows
> > me the next message
> >
> > "moving data error -132"
> >
> > I've got a windows 2k server sp4 and sql server 2k
> >
> > thanks.
> >
> >
> >
> >|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a. MSDTC - Microsoft Distributed Transaction Coordinator
b. MSSEARCH - Microsoft Search
c. ReportServer - SQL Reporting Services
d. SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
> > Any workaround for this? I am getting the same error when trying to apply
> > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> >
> > "Alberto González" wrote:
> >
> > > hello
> > >
> > >
> > > I try to install the anallysis Server but when I start the program shows
> > > me the next message
> > >
> > > "moving data error -132"
> > >
> > > I've got a windows 2k server sp4 and sql server 2k
> > >
> > > thanks.
> > >
> > >
> > >
> > >|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a. MSDTC - Microsoft Distributed Transaction Coordinator
> b. MSSEARCH - Microsoft Search
> c. ReportServer - SQL Reporting Services
> d. SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
> > Getting the same thing - any ideas?
> >
> >
> > "Paul J" wrote:
> >
> > > Any workaround for this? I am getting the same error when trying to apply
> > > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> > >
> > > "Alberto González" wrote:
> > >
> > > > hello
> > > >
> > > >
> > > > I try to install the anallysis Server but when I start the program shows
> > > > me the next message
> > > >
> > > > "moving data error -132"
> > > >
> > > > I've got a windows 2k server sp4 and sql server 2k
> > > >
> > > > thanks.
> > > >
> > > >
> > > >
> > > >|||I am pretty sure this error occurs because a handle is open to a file(s) that
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:
> > The following worked for me. Make sure the following services are stopped
> > when applying SP4.
> >
> > a. MSDTC - Microsoft Distributed Transaction Coordinator
> > b. MSSEARCH - Microsoft Search
> > c. ReportServer - SQL Reporting Services
> > d. SQL Server Databases. Example, MOM or BizTalk
> >
> > I hope this helps.
> > Paul J.
> > "Todd Bell" wrote:
> >
> > > Getting the same thing - any ideas?
> > >
> > >
> > > "Paul J" wrote:
> > >
> > > > Any workaround for this? I am getting the same error when trying to apply
> > > > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> > > >
> > > > "Alberto González" wrote:
> > > >
> > > > > hello
> > > > >
> > > > >
> > > > > I try to install the anallysis Server but when I start the program shows
> > > > > me the next message
> > > > >
> > > > > "moving data error -132"
> > > > >
> > > > > I've got a windows 2k server sp4 and sql server 2k
> > > > >
> > > > > thanks.
> > > > >
> > > > >
> > > > >
> > > > >
error -132
hello
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.
Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto González" wrote:
> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>
|||Getting the same thing - any ideas?
"Paul J" wrote:
[vbcol=seagreen]
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto González" wrote:
|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a.MSDTC - Microsoft Distributed Transaction Coordinator
b.MSSEARCH - Microsoft Search
c.ReportServer - SQL Reporting Services
d.SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
[vbcol=seagreen]
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
[vbcol=seagreen]
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a.MSDTC - Microsoft Distributed Transaction Coordinator
> b.MSSEARCH - Microsoft Search
> c.ReportServer - SQL Reporting Services
> d.SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
|||I am pretty sure this error occurs because a handle is open to a file(s) that
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
[vbcol=seagreen]
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.
Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto González" wrote:
> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>
|||Getting the same thing - any ideas?
"Paul J" wrote:
[vbcol=seagreen]
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto González" wrote:
|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a.MSDTC - Microsoft Distributed Transaction Coordinator
b.MSSEARCH - Microsoft Search
c.ReportServer - SQL Reporting Services
d.SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
[vbcol=seagreen]
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
[vbcol=seagreen]
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a.MSDTC - Microsoft Distributed Transaction Coordinator
> b.MSSEARCH - Microsoft Search
> c.ReportServer - SQL Reporting Services
> d.SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
|||I am pretty sure this error occurs because a handle is open to a file(s) that
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
[vbcol=seagreen]
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:
ERROR 126
When I try and connect to the instance of the SQL server
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server
"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA
|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?
>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
server[vbcol=seagreen]
able
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server
"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA
|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?
>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
server[vbcol=seagreen]
able
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>
ERROR 126
When I try and connect to the instance of the SQL server
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?
>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
>> When I try and connect to the instance of the SQL
server
>> that I set up, I get a error message about not being
able
>> to load a driver (not specific) error 126 SQL server
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?
>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
>> When I try and connect to the instance of the SQL
server
>> that I set up, I get a error message about not being
able
>> to load a driver (not specific) error 126 SQL server
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>
ERROR 126
When I try and connect to the instance of the SQL server
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?
>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
server[vbcol=seagreen]
able[vbcol=seagreen]
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>
that I set up, I get a error message about not being able
to load a driver (not specific) error 126 SQL server"TBXML" <TBXML@.discussions.microsoft.com> wrote in message
news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
> When I try and connect to the instance of the SQL server
> that I set up, I get a error message about not being able
> to load a driver (not specific) error 126 SQL server
What version of SQL Server are you working with.
Are you using a Sybase driver by accident?
Rick Sawtell
MCT, MCSD, MCDBA|||It is the version of SQL that comes with SBS 2003
premium. in terms of enterprise or standard i don't know.
I will look into it.
If i am using a sybase driver how do i know?
>--Original Message--
>"TBXML" <TBXML@.discussions.microsoft.com> wrote in
message
>news:4c5f01c4c6a1$7a342ad0$a601280a@.phx.gbl...
server[vbcol=seagreen]
able[vbcol=seagreen]
>
>What version of SQL Server are you working with.
>Are you using a Sybase driver by accident?
>
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>.
>
Subscribe to:
Posts (Atom)