| Author |
Message |
Eddie McGlone
Guest
|
 Posted:
Fri Nov 11, 2005 9:50 am Post subject:
SQL Server problems - server does not exist or acess denied |
|
|
Hi all.
We have recently completed a swing migration from SBS2000 to SBS 2003
Premium and we are now trying to tie up some loose ends.
We are having the well documented trouble with SQL server hogging memory. It
is the instance for firewall monitoring which is the problem and it is using
1.6Gb or our 4Gb ram. This increases until the firewall service and RRas are
shut down leaving us with no mobile/remote access and difficulties logging
on even to the local network.
We tried to follow the instructions to constrict the memory useage of SQL
but it won't respond to the commands, showing S"erver does not exist or
acces denied" messages. The same happens when we try to register the SQL
instance with SQL Enterprise manager.
Any suggestions as to how to proceed?
Many thanks in advance
Ed |
|
| Back to top |
|
 |
David Copeland [MSFT]
Guest
|
| Posted:
Fri Nov 11, 2005 1:50 pm Post subject:
Re: SQL Server problems - server does not exist or acess den |
|
|
Eddie,
If the service shows as running then you might check in \program
files\microsoft sql server\mssql$msfw\log directory at the errorlog. Do you
see any errors there? What does it show it listening on?
Can you connect to the sbsmonitoring instance using osql -E -S
%computername%\sbsmonitoring
BTW, you actually don't have to change the %computername% to your server
name, it's actually an environment variable that should get translated
automatically. To check to see if it is, you can type the command "set"
(without the quotes) at a command prompt and you should see something like:
....
COMPUTERNAME=SERVER1
....
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n90l3sueu5jaa@corp.supernews.com...
| Quote: | Thanks for your quick response, David.
When I enter the first line "osql -E -S %computername%\msfw" obviously
substituting the actual server name, it comes back with this response;
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
There are three SQL services running - MSFW, SBSMONITORING and SHAREPOINT.
I notice that the MSSQLServerADHelper service is not started. (Marked as
manual) Could this be anything to do with it?
I'm afraid I'm not very clued up on SQL server. :(
What should my next step be?
Thanks
Ed
"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:O2RbeAr5FHA.2956@TK2MSFTNGP12.phx.gbl...
Eddie,
Try connecting to the instance using the following from a command prompt
on the server
osql -E -S %computername%\msfw
You should be able to copy/paste the above as is.
You should then be at a 1> prompt to then start entering in your sql
commands.
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
1> sp_configure 'max server memory',NNNN
2> reconfigure with override
3> go
1> exit
where NNNN is the amount of ram to set it to.
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n8q4gegrru27d@corp.supernews.com...
Hi all.
We have recently completed a swing migration from SBS2000 to SBS 2003
Premium and we are now trying to tie up some loose ends.
We are having the well documented trouble with SQL server hogging
memory. It is the instance for firewall monitoring which is the problem
and it is using 1.6Gb or our 4Gb ram. This increases until the firewall
service and RRas are shut down leaving us with no mobile/remote access
and difficulties logging on even to the local network.
We tried to follow the instructions to constrict the memory useage of
SQL but it won't respond to the commands, showing S"erver does not exist
or acces denied" messages. The same happens when we try to register the
SQL instance with SQL Enterprise manager.
Any suggestions as to how to proceed?
Many thanks in advance
Ed
|
|
|
| Back to top |
|
|
Eddie McGlone
Guest
|
| Posted:
Fri Nov 11, 2005 1:50 pm Post subject:
Re: SQL Server problems - server does not exist or acess den |
|
|
"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:OWQwQ4r5FHA.3312@TK2MSFTNGP15.phx.gbl...
| Quote: | Eddie,
BTW, you actually don't have to change the %computername% to your server
name, it's actually an environment variable that should get translated
automatically.
------------------------------ |
Sometimes I can be most excruciatingly, embarrassingly and publicly dense!!
I was *leaving in* the percentage marks!!
All done now, many thanks.
I have set it for 100Mb. Are there any recommendations for throttling the
SBSMONITORING and SHAREPOINT instances that you know of? They are currently
sitting at 140 and 200Mb.
And I take it that the fact that the enterprise manager seems to be unable
to register any of these instances doesn't mean much?
Once again, Ta.
Ed |
|
| Back to top |
|
|
Eddie McGlone
Guest
|
| Posted:
Fri Nov 11, 2005 1:50 pm Post subject:
Re: SQL Server problems - server does not exist or acess den |
|
|
Thanks for your quick response, David.
When I enter the first line "osql -E -S %computername%\msfw" obviously
substituting the actual server name, it comes back with this response;
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
There are three SQL services running - MSFW, SBSMONITORING and SHAREPOINT. I
notice that the MSSQLServerADHelper service is not started. (Marked as
manual) Could this be anything to do with it?
I'm afraid I'm not very clued up on SQL server. :(
What should my next step be?
Thanks
Ed
"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:O2RbeAr5FHA.2956@TK2MSFTNGP12.phx.gbl...
| Quote: | Eddie,
Try connecting to the instance using the following from a command prompt
on the server
osql -E -S %computername%\msfw
You should be able to copy/paste the above as is.
You should then be at a 1> prompt to then start entering in your sql
commands.
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
1> sp_configure 'max server memory',NNNN
2> reconfigure with override
3> go
1> exit
where NNNN is the amount of ram to set it to.
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n8q4gegrru27d@corp.supernews.com...
Hi all.
We have recently completed a swing migration from SBS2000 to SBS 2003
Premium and we are now trying to tie up some loose ends.
We are having the well documented trouble with SQL server hogging memory.
It is the instance for firewall monitoring which is the problem and it is
using 1.6Gb or our 4Gb ram. This increases until the firewall service and
RRas are shut down leaving us with no mobile/remote access and
difficulties logging on even to the local network.
We tried to follow the instructions to constrict the memory useage of SQL
but it won't respond to the commands, showing S"erver does not exist or
acces denied" messages. The same happens when we try to register the SQL
instance with SQL Enterprise manager.
Any suggestions as to how to proceed?
Many thanks in advance
Ed
|
|
|
| Back to top |
|
|
David Copeland [MSFT]
Guest
|
| Posted:
Fri Nov 11, 2005 1:50 pm Post subject:
Re: SQL Server problems - server does not exist or acess den |
|
|
Eddie,
Try connecting to the instance using the following from a command prompt on
the server
osql -E -S %computername%\msfw
You should be able to copy/paste the above as is.
You should then be at a 1> prompt to then start entering in your sql
commands.
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
1> sp_configure 'max server memory',NNNN
2> reconfigure with override
3> go
1> exit
where NNNN is the amount of ram to set it to.
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n8q4gegrru27d@corp.supernews.com...
| Quote: | Hi all.
We have recently completed a swing migration from SBS2000 to SBS 2003
Premium and we are now trying to tie up some loose ends.
We are having the well documented trouble with SQL server hogging memory.
It is the instance for firewall monitoring which is the problem and it is
using 1.6Gb or our 4Gb ram. This increases until the firewall service and
RRas are shut down leaving us with no mobile/remote access and
difficulties logging on even to the local network.
We tried to follow the instructions to constrict the memory useage of SQL
but it won't respond to the commands, showing S"erver does not exist or
acces denied" messages. The same happens when we try to register the SQL
instance with SQL Enterprise manager.
Any suggestions as to how to proceed?
Many thanks in advance
Ed
|
|
|
| Back to top |
|
|
David Copeland [MSFT]
Guest
|
| Posted:
Fri Nov 11, 2005 1:50 pm Post subject:
Re: SQL Server problems - server does not exist or acess den |
|
|
Also, do any events show up in the event log (application or system) when
you attempt to connect to the MSFW instance?
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n90l3sueu5jaa@corp.supernews.com...
| Quote: | Thanks for your quick response, David.
When I enter the first line "osql -E -S %computername%\msfw" obviously
substituting the actual server name, it comes back with this response;
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
There are three SQL services running - MSFW, SBSMONITORING and SHAREPOINT.
I notice that the MSSQLServerADHelper service is not started. (Marked as
manual) Could this be anything to do with it?
I'm afraid I'm not very clued up on SQL server. :(
What should my next step be?
Thanks
Ed
"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:O2RbeAr5FHA.2956@TK2MSFTNGP12.phx.gbl...
Eddie,
Try connecting to the instance using the following from a command prompt
on the server
osql -E -S %computername%\msfw
You should be able to copy/paste the above as is.
You should then be at a 1> prompt to then start entering in your sql
commands.
1> sp_configure 'show advanced options',1
2> reconfigure with override
3> go
1> sp_configure 'max server memory',NNNN
2> reconfigure with override
3> go
1> exit
where NNNN is the amount of ram to set it to.
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n8q4gegrru27d@corp.supernews.com...
Hi all.
We have recently completed a swing migration from SBS2000 to SBS 2003
Premium and we are now trying to tie up some loose ends.
We are having the well documented trouble with SQL server hogging
memory. It is the instance for firewall monitoring which is the problem
and it is using 1.6Gb or our 4Gb ram. This increases until the firewall
service and RRas are shut down leaving us with no mobile/remote access
and difficulties logging on even to the local network.
We tried to follow the instructions to constrict the memory useage of
SQL but it won't respond to the commands, showing S"erver does not exist
or acces denied" messages. The same happens when we try to register the
SQL instance with SQL Enterprise manager.
Any suggestions as to how to proceed?
Many thanks in advance
Ed
|
|
|
| Back to top |
|
|
David Copeland [MSFT]
Guest
|
| Posted:
Fri Nov 11, 2005 5:50 pm Post subject:
Re: SQL Server problems - server does not exist or acess den |
|
|
Ed,
Glad to hear it work for you.. as far as the %computername% goes, you
should be leaving the % signs.. For example at a command prompt if you were
to type
echo %computername%
It should return the name of your machine. The syntax does seem a bit odd
with the % signs, but it should be able to translate the environment
variables that way..
As far as the numbers for the SBSMonitoring, SharePoint instance goes, I
don't really have any set numbers for those since they will depend on your
usages/environment.
For the registration in SQL Enterprise Manager you should be able to
register the SBSMonitoring instance and the SharePoint instance (if it's
been upgraded to full SQL). Be sure you are trying to register them using
yourservername\sbsmonitoring or yourservername\sharepoint as the instance
name.
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n97iqngibrpc8@corp.supernews.com...
| Quote: | "David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:OWQwQ4r5FHA.3312@TK2MSFTNGP15.phx.gbl...
Eddie,
BTW, you actually don't have to change the %computername% to your server
name, it's actually an environment variable that should get translated
automatically.
------------------------------
Sometimes I can be most excruciatingly, embarrassingly and publicly
dense!! I was *leaving in* the percentage marks!!
All done now, many thanks.
I have set it for 100Mb. Are there any recommendations for throttling the
SBSMONITORING and SHAREPOINT instances that you know of? They are
currently sitting at 140 and 200Mb.
And I take it that the fact that the enterprise manager seems to be unable
to register any of these instances doesn't mean much?
Once again, Ta.
Ed
|
|
|
| Back to top |
|
|
Eddie McGlone
Guest
|
| Posted:
Fri Nov 11, 2005 5:50 pm Post subject:
Re: SQL Server problems - server does not exist or acess den |
|
|
Yep, but I was using %myservername% !! ie. telling it the name but as if
it was an environment variable. Doh!
Registration has now worked also.
thanks for all your help.
Cheers
Ed
-------------------------------
"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:uBOCmps5FHA.1140@tk2msftngp13.phx.gbl...
| Quote: | Ed,
Glad to hear it work for you.. as far as the %computername% goes, you
should be leaving the % signs.. For example at a command prompt if you
were to type
echo %computername%
It should return the name of your machine. The syntax does seem a bit odd
with the % signs, but it should be able to translate the environment
variables that way..
As far as the numbers for the SBSMonitoring, SharePoint instance goes, I
don't really have any set numbers for those since they will depend on your
usages/environment.
For the registration in SQL Enterprise Manager you should be able to
register the SBSMonitoring instance and the SharePoint instance (if it's
been upgraded to full SQL). Be sure you are trying to register them using
yourservername\sbsmonitoring or yourservername\sharepoint as the instance
name.
--
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Eddie McGlone" <ed.mcglone@strathclydehomes.com> wrote in message
news:11n97iqngibrpc8@corp.supernews.com...
"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:OWQwQ4r5FHA.3312@TK2MSFTNGP15.phx.gbl...
Eddie,
BTW, you actually don't have to change the %computername% to your server
name, it's actually an environment variable that should get translated
automatically.
------------------------------
Sometimes I can be most excruciatingly, embarrassingly and publicly
dense!! I was *leaving in* the percentage marks!!
All done now, many thanks.
I have set it for 100Mb. Are there any recommendations for throttling the
SBSMONITORING and SHAREPOINT instances that you know of? They are
currently sitting at 140 and 200Mb.
And I take it that the fact that the enterprise manager seems to be
unable to register any of these instances doesn't mean much?
Once again, Ta.
Ed
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in