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.

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.

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.

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

error- shared memory sql server doesnt........

Hi evryone

I have installed SQL server as local system account and mixmode authorization.

After installing when i try to connect to database using sa account.

it gives error like Microsoft ODBC sql server driver - shared memory- sql server doesnt exist or access denied.

I unistalled sql server and again i installed. but same error facing.

Please reply.

Regards,

What name did you give the SQL Server when you installed it, which SQL Server was it?

If this is SQL Express then the connection string you need ot use is .\sqlexpress