This is a multi-part message in MIME format.
--=_NextPart_000_006C_01C54B87.15611800
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All
Has any one ever seen this error?
Error : The type initializer for = "Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an = exception.
I have deployed reports numerous times and never seen it.
Thanks,
Jessica
--=_NextPart_000_006C_01C54B87.15611800
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi All
Has any one ever seen this = error?
Error : The type initializer for "Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an = exception.
I have deployed reports numerous times = and never seen it.
Thanks,
Jessica
--=_NextPart_000_006C_01C54B87.15611800--A few people have reported this error before, but we never identified the
cause. Did anything on your machine change recently? What version of
Reporting Services are you using?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jessica C" <jesscobbe@.hotmail.com> wrote in message
news:u%23BoLH8SFHA.1152@.tk2msftngp13.phx.gbl...
Hi All
Has any one ever seen this error?
Error : The type initializer for
"Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an
exception.
I have deployed reports numerous times and never seen it.
Thanks,
Jessicasql
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Error when starting SQLSERVER AGENT
Hello!, I have the following error message when I want to start the
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
Message posted via http://www.droptable.com
The MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
Message posted via http://www.droptable.com
The MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.
Error when starting SQLSERVER AGENT
Hello!, I have the following error message when I want to start the
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
--
Message posted via http://www.sqlmonster.comThe MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
--
Message posted via http://www.sqlmonster.comThe MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.
Error when starting SQLSERVER AGENT
Hello!, I have the following error message when I want to start the
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
Message posted via http://www.droptable.comThe MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.sql
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
Message posted via http://www.droptable.comThe MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.sql
Error when setting MSDTC to autostart
Hi!
I'm getting an error message when I try to set autostart MSDTC in Enterprise manager. This problem just suddenly appered.
Error message:
Error 22002: RegCreateKeyEx() returned error5, 'Access is denied'
I hope somebody can tell me what this is :)Ensure the account used to start SQL Server services and MSDTC have necessary privileges to access the registry key and server.
Also, if you're using the DOMAIN account that you are trying to run the SQL services under must also have privlages to that machine. You must add that account to the local machine, such as the admin group.
If possible to restart the services and BTW what is the level of SQL service pack?sql
I'm getting an error message when I try to set autostart MSDTC in Enterprise manager. This problem just suddenly appered.
Error message:
Error 22002: RegCreateKeyEx() returned error5, 'Access is denied'
I hope somebody can tell me what this is :)Ensure the account used to start SQL Server services and MSDTC have necessary privileges to access the registry key and server.
Also, if you're using the DOMAIN account that you are trying to run the SQL services under must also have privlages to that machine. You must add that account to the local machine, such as the admin group.
If possible to restart the services and BTW what is the level of SQL service pack?sql
Error when sending report to PDF
"A drawing error occurred". I receive this message when I export to pdf
from RS2005. Note that I only have this issue on my reports that have a .jpg
in them. "Thats an image"....... Any ideas...............We had the same issue, but it was resolved with sp1 for RS 2005.
"gdjoshua" <gdjoshua@.discussions.microsoft.com> wrote in message
news:049DE821-F331-4422-A0C4-3D7F99BE443A@.microsoft.com...
> "A drawing error occurred". I receive this message when I export to pdf
> from RS2005. Note that I only have this issue on my reports that have a
> .jpg
> in them. "Thats an image"....... Any ideas...............
from RS2005. Note that I only have this issue on my reports that have a .jpg
in them. "Thats an image"....... Any ideas...............We had the same issue, but it was resolved with sp1 for RS 2005.
"gdjoshua" <gdjoshua@.discussions.microsoft.com> wrote in message
news:049DE821-F331-4422-A0C4-3D7F99BE443A@.microsoft.com...
> "A drawing error occurred". I receive this message when I export to pdf
> from RS2005. Note that I only have this issue on my reports that have a
> .jpg
> in them. "Thats an image"....... Any ideas...............
Error when running SQL Job
I get an Event ID: 40961 when running a job in SQL the error message is as follows;
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
The job is run on another server and is trying to hit the server listed above.
There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?e...aS rv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
The job is run on another server and is trying to hit the server listed above.
There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?e...aS rv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.
Error when running SQL Job
I get an Event ID: 40961 when running a job in SQL the error message is as f
ollows;
The Security System could not establish a secured connection with the server
MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availab
le.
The job is run on another server and is trying to hit the server listed abov
e.There are a few related knowledge base articles and several
reasons for the error listed at this site:
1" target="_blank">http://www.eventid.net/display.asp?...phase=
1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I get an Event ID: 40961 when running a job in SQL the error message is as
follows;
>The Security System could not establish a secured connection with the serve
r MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availa
ble.
>The job is run on another server and is trying to hit the server listed above.[/vbc
ol]sql
ollows;
The Security System could not establish a secured connection with the server
MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availab
le.
The job is run on another server and is trying to hit the server listed abov
e.There are a few related knowledge base articles and several
reasons for the error listed at this site:
1" target="_blank">http://www.eventid.net/display.asp?...phase=
1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I get an Event ID: 40961 when running a job in SQL the error message is as
follows;
>The Security System could not establish a secured connection with the serve
r MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was availa
ble.
>The job is run on another server and is trying to hit the server listed above.[/vbc
ol]sql
Error when running SQL Job
I get an Event ID: 40961 when running a job in SQL the error message is as follows
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available
The job is run on another server and is trying to hit the server listed above.There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?eventid=40961&eventno=1398&source=LsaSrv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.
The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available
The job is run on another server and is trying to hit the server listed above.There are a few related knowledge base articles and several
reasons for the error listed at this site:
http://www.eventid.net/display.asp?eventid=40961&eventno=1398&source=LsaSrv&phase=1
-Sue
On Tue, 18 May 2004 04:46:04 -0700, "JZanone"
<anonymous@.discussions.microsoft.com> wrote:
>I get an Event ID: 40961 when running a job in SQL the error message is as follows;
>The Security System could not establish a secured connection with the server MSSQLSvc/PTISERV.Pinnacle.PTI:1433. No authentication protocol was available.
>The job is run on another server and is trying to hit the server listed above.
Monday, March 26, 2012
Error when running Profiler
I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q
Error when running Profiler
I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
Q
Hi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
Q
Hi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q
Error when running Profiler
I install SQL Server 2005 Dev to my computer, when I try to run the Profiler
,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profil
er,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK t
o
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Qsql
,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profil
er,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK t
o
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Qsql
Error When Opening SSMS Express
Hi, everyone.
I'm getting the following error when opening SQL Server Management Studio Express (long error message -- sorry).
************** Exception Text **************
System.IO.IOException: Cannot create a stable subkey under a volatile parent key.
at Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str)
at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey, RegistryKeyPermissionCheck permissionCheck, RegistrySecurity registrySecurity)
at Microsoft.Win32.RegistryKey.CreateSubKey(String subkey)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.CreateKeyValueIfNotExist(String regPath, String keyName)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RegisteredServersUtils.RegisterLocalInstancesIfFirstTimeUser()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I'm running on a clean install of Windows XP SP2, using SQL Server Express 2005 SP1, and Visual Studio 2005 Standard. I can click Continue and everything seems to work ok. However the same error message pops up intermittently when I'm working. I have tried the usual uninstall SSMSE and reinstall. I get the same results. I didn't have this error when using SSMSE CTP.
Any help would be appreciated. Thanks.
Flynn
Oddly enough, when I opened SSMSE this morning, it ran the initial setup and now everything works fine. I can only think it's because I logged off and back on after installing instead of performing a complete reboot cycle.
Anyway, I'm not getting any errors now when opening the program, or when working in it.
Flynn
sqlError When Open Analysis Services From Management Studio
Dear All,
When I want to open Analysis
Services from Management Studio, an
error message appear:
Exception of type
'System.OutOfMemoryException' was thrown.
(Microsoft.SqlServer.SmoEnum)
Can anybody tell me what happen and how to solve that ?Thanks in advance.
What version of Analysis Services you are running?
Try installing SP1. If that wouldnt help, try installing CTP of SP2.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks for your reply. I have installed SP1 + Hotfix so the version of SSAS is 2153. Is it recommended to installed SP2 on Production server yet ? Thanks.|||
I wouldnt recommend installing CTP of SP2 without trying it first on the production machine.
But the problem looks like to be related to the SQL Management studio. Try installing CTP of SP2 on a client machine and then connecting to the server. See if the same error is happening.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
FYI, I have 4 machine in my environment, one server (A) and the other three is client (B,C,D). I installed SP1 + hotfix on machine A, B, and C. I installed CTP of SP2 on D. A cannot open Analysis Services from management studio on its local, but can open Analysis Services on B and C. B and C can open Analysis Services on their local but cannot open the Analysis Services on A. D can open Analysis Services on its local and other machines (A, B, C). Is there any other solution besides installing CTP of SP2 on client ? Thanks.|||
In SP2 SQL Management studio is more efficient in opening big databases. Looks like that is the way to go.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Dear Edward,
Thanks for your information. Then I guess I have to wait for the release of SP2 to installed it on Production Server.
Friday, March 23, 2012
Error when limiting memory usage with OSQL.EXE
When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
Reply in group, but if emailing add another
zero, and remove the last word.
I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
Reply in group, but if emailing add another
zero, and remove the last word.
I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.
Error when limiting memory usage with OSQL.EXE
When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
Reply in group, but if emailing add another
zero, and remove the last word.
I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
Reply in group, but if emailing add another
zero, and remove the last word.
I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>
|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.
Error when limiting memory usage with OSQL.EXE
When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
Reply in group, but if emailing add another
zero, and remove the last word.I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
--
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/.../1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Your advanced options are already set to 1 (enabled).
Now run the second set and you should be fine.
I don't see an error. I would also recommend using 100 instead of 70.
Claus
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
Reply in group, but if emailing add another
zero, and remove the last word.I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
--
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/.../1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Your advanced options are already set to 1 (enabled).
Now run the second set and you should be fine.
I don't see an error. I would also recommend using 100 instead of 70.
Claus
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.
Error when limiting memory usage with OSQL.EXE
When trying to limit the memory usage of the SQL components of Small
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
--
Reply in group, but if emailing add another
zero, and remove the last word.I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
--
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Your advanced options are already set to 1 (enabled).
Now run the second set and you should be fine.
I don't see an error. I would also recommend using 100 instead of 70.
--
Claus
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
>> Configuration option 'show advanced options' changed from 1 to 1.
>> Run the RECONFIGURE statement to install.
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.sql
Business Server, I get an error message I don't know what to do with.
I searched for an osql internal command reference, but all the references I
found are about specific problems.
Here is my input and the result:
osql -E -S sbs01\sbsmonitoring
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
I intended to follow that with the following commands, but didn't get that
far:
sp_configure 'max server memory', 70
reconfigure with override
go
--
Reply in group, but if emailing add another
zero, and remove the last word.I think you need to remove the first go or just run
> sp_configure 'max server memory', 70
> reconfigure with override
--
Jason Massie
www: http://statisticsio.com
rss: http://statisticsio.com/Home/tabid/36/rssid/1/Default.aspx
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Your advanced options are already set to 1 (enabled).
Now run the second set and you should be fine.
I don't see an error. I would also recommend using 100 instead of 70.
--
Claus
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||Hi Tom
What error message are you getting?
(If you're referring to this:
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
please note that is not an error. It is the normal response to any
sp_configure command to set a value. SQL Server doesn't check to see if the
next statement is the RECONFIGURE before generating this message.)
If that was the response, you were ready to go on, but it's probably a good
thing you didn't. Setting memory to only 70MB is not a good idea. Although
technically SQL Server might be able to run with this little, you probably
won't be able to get any work done at all.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Tom Del Rosso" <td_01@.att.net.invalid> wrote in message
news:eqyFxBhLIHA.3832@.TK2MSFTNGP04.phx.gbl...
> When trying to limit the memory usage of the SQL components of Small
> Business Server, I get an error message I don't know what to do with.
> I searched for an osql internal command reference, but all the references
> I
> found are about specific problems.
>
> Here is my input and the result:
> osql -E -S sbs01\sbsmonitoring
> 1> sp_configure 'show advanced options',1
> 2> reconfigure with override
> 3> go
> Configuration option 'show advanced options' changed from 1 to 1. Run the
> RECONFIGURE statement to install.
>
> I intended to follow that with the following commands, but didn't get that
> far:
> sp_configure 'max server memory', 70
> reconfigure with override
> go
>
> --
> Reply in group, but if emailing add another
> zero, and remove the last word.
>|||"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uS6ahRhLIHA.2024@.TK2MSFTNGP05.phx.gbl
> Hi Tom
> What error message are you getting?
> (If you're referring to this:
>> Configuration option 'show advanced options' changed from 1 to 1.
>> Run the RECONFIGURE statement to install.
> please note that is not an error. It is the normal response to any
> sp_configure command to set a value. SQL Server doesn't check to see
> if the next statement is the RECONFIGURE before generating this
> message.)
> If that was the response, you were ready to go on, but it's probably
> a good thing you didn't. Setting memory to only 70MB is not a good
> idea. Although technically SQL Server might be able to run with this
> little, you probably won't be able to get any work done at all.
Thanks all.
I should have mentioned that what I expected was "DBCC execution completed"
on the line following go. I thought that, without it, the command must have
failed.
I will use 100MB as Claus suggested. 70MB has worked with other SBS's and I
know I'm not the only SBS admin who has used that value, but I'll do as you
say.
Reply in group, but if emailing add another
zero, and remove the last word.sql
Error when installing Reporting Services in Virtual PC 2004
When I tried installing Reporting Services in Windows Server 2003 under
Virtual PC 2004 it displays a message "Error!". I have already installed
VS.NET 2003 and SQL Server 2000 with SP3. Please help.Hi Randy:
I've installed RS on a couple VPCs, so I don't think it would be a
general problem with VPC. I'm wondering what the problem could be. Do
you have 2003 configured as an application server (IIS, ASP.NET
enabled) before the install?
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Wed, 3 Nov 2004 19:23:02 -0800, "Randy Gadingan" <Randy
Gadingan@.discussions.microsoft.com> wrote:
>When I tried installing Reporting Services in Windows Server 2003 under
>Virtual PC 2004 it displays a message "Error!". I have already installed
>VS.NET 2003 and SQL Server 2000 with SP3. Please help.|||Hi Scott:
I have configured Windows Server 2003 as an application server before
installing VS NET 2003 and SQL Reporting Services.
"Scott Allen" wrote:
> Hi Randy:
> I've installed RS on a couple VPCs, so I don't think it would be a
> general problem with VPC. I'm wondering what the problem could be. Do
> you have 2003 configured as an application server (IIS, ASP.NET
> enabled) before the install?
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Wed, 3 Nov 2004 19:23:02 -0800, "Randy Gadingan" <Randy
> Gadingan@.discussions.microsoft.com> wrote:
> >When I tried installing Reporting Services in Windows Server 2003 under
> >Virtual PC 2004 it displays a message "Error!". I have already installed
> >VS.NET 2003 and SQL Server 2000 with SP3. Please help.
>
Virtual PC 2004 it displays a message "Error!". I have already installed
VS.NET 2003 and SQL Server 2000 with SP3. Please help.Hi Randy:
I've installed RS on a couple VPCs, so I don't think it would be a
general problem with VPC. I'm wondering what the problem could be. Do
you have 2003 configured as an application server (IIS, ASP.NET
enabled) before the install?
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Wed, 3 Nov 2004 19:23:02 -0800, "Randy Gadingan" <Randy
Gadingan@.discussions.microsoft.com> wrote:
>When I tried installing Reporting Services in Windows Server 2003 under
>Virtual PC 2004 it displays a message "Error!". I have already installed
>VS.NET 2003 and SQL Server 2000 with SP3. Please help.|||Hi Scott:
I have configured Windows Server 2003 as an application server before
installing VS NET 2003 and SQL Reporting Services.
"Scott Allen" wrote:
> Hi Randy:
> I've installed RS on a couple VPCs, so I don't think it would be a
> general problem with VPC. I'm wondering what the problem could be. Do
> you have 2003 configured as an application server (IIS, ASP.NET
> enabled) before the install?
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Wed, 3 Nov 2004 19:23:02 -0800, "Randy Gadingan" <Randy
> Gadingan@.discussions.microsoft.com> wrote:
> >When I tried installing Reporting Services in Windows Server 2003 under
> >Virtual PC 2004 it displays a message "Error!". I have already installed
> >VS.NET 2003 and SQL Server 2000 with SP3. Please help.
>
error when importing text file - saving in notepad first works
I'm trying to import a tab separated text file into sql server 2005 using the import guide. But when running the job I get the error message
Error 0xc02020c5: Data Flow Task: Data conversion failed while converting column "Column 19" (67) to column "Column 19" (404). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)
The column 19 which reported a problem contains this information:
?searchroot=/_gen_/txt/&template=std.htm&use=prospect&intref=1_26067
However what is mysterious is that if I open the file in notepad or Excel and resave it again the job runs perfectly. This is not a way we could make it work later on since it's an automatic job that will run each night on a new text file.
The text file is sent from Norway to Sweden - and I use ANSI latin 1 when importing.
The column has datatype DT_STR with a width of 500.
I use Locale Swedish and when I save in Notepad it is saved in ANSI,
I use Windows XP Swedish version.
Try DT_WSTR instead as its unicode.There could be a control character in that field that gets thrown away when you save in Notepad.|||
Had the same error importing a text file. Error was resolved by changing the dataype as you advised. Thanks!
Subscribe to:
Posts (Atom)