No items under SQL server group

Hi,
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterprise
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
Bing
Hi
"bing" wrote:

> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged in
> using my domain account which is member of an admin group. But in Enterprise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and had
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
John

No items under SQL server group

Hi,
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterpris
e
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
BingHi
"bing" wrote:

> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged
in
> using my domain account which is member of an admin group. But in Enterpr
ise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and h
ad
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
John

No items under SQL server group

Hi,
We're running SQL server 2000 standard edition on Windows 2003. I logged in
using my domain account which is member of an admin group. But in Enterprise
Manger, under SQL Server Group, I got 'no items'. How come? I used to be
able to use another domain account in the same admin group to log on and had
no problem. What did I miss?
Thanks in advance for any help.
BingHi
"bing" wrote:
> Hi,
> We're running SQL server 2000 standard edition on Windows 2003. I logged in
> using my domain account which is member of an admin group. But in Enterprise
> Manger, under SQL Server Group, I got 'no items'. How come? I used to be
> able to use another domain account in the same admin group to log on and had
> no problem. What did I miss?
> Thanks in advance for any help.
> Bing
When you run SQL Server Enterprise Manager for the first time, it should
automatically registers all instances of a local SQL Server, but any
instances that are added afterwards will be not be automatically registered.
You must be on the server where the instance is installed for this to occur.
If you have removed the registration you will need to manually add it again.
Also check that the registry has not been changed/corrupted.
Johnsql

No indication of the SQL Server edition in the About window

I installed the SQL Server 2005 standard edition after uninstalling the Express edition.

When i look in the 'About' screen in the 'SQL Server Managment studio', i don't see indication that the SQL Server 2005 i currently work with is the Standard Edition. There are only categories and their numbers of versions.

How do i know that the Edition i work on ,now , is the Standard edition ?

Open up Management Studio and run "select @.@.version". This will tell you your SQL and OS details, including edition.

Thanks,
Sam Lester (MSFT)

|||Thanks , works like a charm.

No buffers

Occasionally on my SQL 2K SP3 Standard servers. The servers lock up with
the error.

LazyWriter: warning, no free buffers found.

After that I have to restart the SQLServer service to get things up and
running. How can I prevent this from happening?

Thanks,
RayHi

Without knowing the configuration values it is hard to say exactly what is
happening. a likely cause may be lack of memory and it may also mention this
in your SQL Server log.

You may want to search for the error message on Google. There are lots of
posts about pinning tables in 6.5 so your version number is also important
information.

John

"Ray" <someone@.nowhere.com> wrote in message
news:vT3Ad.4051$Y8.1567@.newssvr17.news.prodigy.com ...
> Occasionally on my SQL 2K SP3 Standard servers. The servers lock up with
> the error.
> LazyWriter: warning, no free buffers found.
> After that I have to restart the SQLServer service to get things up and
> running. How can I prevent this from happening?
> Thanks,
> Ray

No ability to create maintanance plan in sql server 2005

Hello,
i try to create a new maintenance plan in the sql management studio.
i tried it with windows xp (x86, german), 2003 enterprise / standard (both
x64 and english), sql server developer x86/x64 (english and german),
enterprise x64 (english).
to create it i use the wizard, every time and constellation ends with the
same error:
steps:
1) select windows authentication (same with sa in sql authentication)
2) check database integrity (or any other job)
3) select database master (or any other)
4) not scheduled (no other effect if scheduled)
5) no reporting (no other effect if reported)
6) Finish
Error:
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Error)
Messages
* Create maintenance plan failed.
--
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
- Adding tasks to the maintenance plan (Stopped)
- Adding scheduling options (Stopped)
- Adding reporting options (Stopped)
- Saving maintenance plan "MaintenancePlan" (Stopped)
Has anyone any idea about thies?I'm not sure but perhaps you get this error if you didn't install Integration Services...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> Hello,
> i try to create a new maintenance plan in the sql management studio.
> i tried it with windows xp (x86, german), 2003 enterprise / standard (both
> x64 and english), sql server developer x86/x64 (english and german),
> enterprise x64 (english).
> to create it i use the wizard, every time and constellation ends with the
> same error:
> steps:
> 1) select windows authentication (same with sa in sql authentication)
> 2) check database integrity (or any other job)
> 3) select database master (or any other)
> 4) not scheduled (no other effect if scheduled)
> 5) no reporting (no other effect if reported)
> 6) Finish
> Error:
> Maintenance Plan Wizard Progress
> - Creating maintenance plan "MaintenancePlan" (Error)
> Messages
> * Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> - Adding tasks to the maintenance plan (Stopped)
> - Adding scheduling options (Stopped)
> - Adding reporting options (Stopped)
> - Saving maintenance plan "MaintenancePlan" (Stopped)
> Has anyone any idea about thies?
>|||thank you, this seems to be the solution!
"Tibor Karaszi" schrieb:
> I'm not sure but perhaps you get this error if you didn't install Integration Services...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
> news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> > Hello,
> >
> > i try to create a new maintenance plan in the sql management studio.
> > i tried it with windows xp (x86, german), 2003 enterprise / standard (both
> > x64 and english), sql server developer x86/x64 (english and german),
> > enterprise x64 (english).
> > to create it i use the wizard, every time and constellation ends with the
> > same error:
> >
> > steps:
> > 1) select windows authentication (same with sa in sql authentication)
> > 2) check database integrity (or any other job)
> > 3) select database master (or any other)
> > 4) not scheduled (no other effect if scheduled)
> > 5) no reporting (no other effect if reported)
> > 6) Finish
> >
> > Error:
> > Maintenance Plan Wizard Progress
> > - Creating maintenance plan "MaintenancePlan" (Error)
> > Messages
> > * Create maintenance plan failed.
> > --
> > ADDITIONAL INFORMATION:
> > Create failed for JobStep 'Subplan'.
> > (Microsoft.SqlServer.MaintenancePlanTasks)
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
> > --
> > An exception occurred while executing a Transact-SQL statement or batch.
> > (Microsoft.SqlServer.ConnectionInfo)
> > --
> > The specified '@.subsystem' is invalid (valid values are returned by
> > sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
> > - Adding tasks to the maintenance plan (Stopped)
> > - Adding scheduling options (Stopped)
> > - Adding reporting options (Stopped)
> > - Saving maintenance plan "MaintenancePlan" (Stopped)
> >
> > Has anyone any idea about thies?
> >
>
>sql

No ability to create maintanance plan in sql server 2005

Hello,
i try to create a new maintenance plan in the sql management studio.
i tried it with Windows XP (x86, german), 2003 enterprise / standard (both
x64 and english), sql server developer x86/x64 (english and german),
enterprise x64 (english).
to create it i use the wizard, every time and constellation ends with the
same error:
steps:
1) select windows authentication (same with sa in sql authentication)
2) check database integrity (or any other job)
3) select database master (or any other)
4) not scheduled (no other effect if scheduled)
5) no reporting (no other effect if reported)
6) Finish
Error:
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Error)
Messages
* Create maintenance plan failed.
--
ADDITIONAL INFORMATION:
Create failed for JobStep 'Subplan'.
(Microsoft.SqlServer.MaintenancePlanTasks)
For help, click:
http://go.microsoft.com/fwlink?Prod...ep&LinkId=20476
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
--
The specified '@.subsystem' is invalid (valid values are returned by
sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
For help, click:
http://go.microsoft.com/fwlink?Prod...34&LinkId=20476
- Adding tasks to the maintenance plan (Stopped)
- Adding scheduling options (Stopped)
- Adding reporting options (Stopped)
- Saving maintenance plan "MaintenancePlan" (Stopped)
Has anyone any idea about thies?I'm not sure but perhaps you get this error if you didn't install Integratio
n Services...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> Hello,
> i try to create a new maintenance plan in the sql management studio.
> i tried it with Windows XP (x86, german), 2003 enterprise / standard (both
> x64 and english), sql server developer x86/x64 (english and german),
> enterprise x64 (english).
> to create it i use the wizard, every time and constellation ends with the
> same error:
> steps:
> 1) select windows authentication (same with sa in sql authentication)
> 2) check database integrity (or any other job)
> 3) select database master (or any other)
> 4) not scheduled (no other effect if scheduled)
> 5) no reporting (no other effect if reported)
> 6) Finish
> Error:
> Maintenance Plan Wizard Progress
> - Creating maintenance plan "MaintenancePlan" (Error)
> Messages
> * Create maintenance plan failed.
> --
> ADDITIONAL INFORMATION:
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...ep&LinkId=20476
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> The specified '@.subsystem' is invalid (valid values are returned by
> sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...34&LinkId=20476
> - Adding tasks to the maintenance plan (Stopped)
> - Adding scheduling options (Stopped)
> - Adding reporting options (Stopped)
> - Saving maintenance plan "MaintenancePlan" (Stopped)
> Has anyone any idea about thies?
>|||thank you, this seems to be the solution!
"Tibor Karaszi" schrieb:

> I'm not sure but perhaps you get this error if you didn't install Integrat
ion Services...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
> news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
>
>

newbie: setting up SQL MAIL

My system:
I have installed Sql Server 2000 on my server (MS windows server 2003
enterprise edtion)
In addition Exchange Server 2003 standard edition is installed on this
server.
Every users on my network, have an e-mail account in exchange
On the clients, every user have Outlook Express with a MAPI profile.
My problem is that when I in SqlServer properties specifies SQL Mail profile
and
push the Test-button I get this error message:
"Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
And if I just push the Ok-button in the dialoge specifying SQL Mail profile.
I get this message:
"The MAPI profile was not found on the server, Are you this is what you
want?" (yes/no-button)
The profile name i specified is used in Outllook express to send email using
MAPI...
so why do I get this error..'?. (remember I'm a newbie)
Eh, I know that running Exchange and SqlServer on the same server is not a
good thing,
slow performance..etc... I´d setup this system in the porpose of learning
about
sqlserver&exchange&win2k3server...
JeffI was sure that a MAPI-compliant client, such as Outlook, had to be
installed *on* the SQL Server machine, and that it had to use an account
that SQL Server was privy to...
I think there's a way to make it work with Outlook Express, but I'm not sure
it's supported.
Maybe some helpful links here (including the possibility of using SMTP
instead of Exchange/MAPI/SQL Mail)?
http://www.aspfaq.com/2403
"Jeff" <it_consultant1@.hotmail.com> wrote in message
news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> My system:
> I have installed Sql Server 2000 on my server (MS windows server 2003
> enterprise edtion)
> In addition Exchange Server 2003 standard edition is installed on this
> server.
> Every users on my network, have an e-mail account in exchange
> On the clients, every user have Outlook Express with a MAPI profile.
> My problem is that when I in SqlServer properties specifies SQL Mail
profile
> and
> push the Test-button I get this error message:
> "Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
> And if I just push the Ok-button in the dialoge specifying SQL Mail
profile.
> I get this message:
> "The MAPI profile was not found on the server, Are you this is what you
> want?" (yes/no-button)
> The profile name i specified is used in Outllook express to send email
using
> MAPI...
> so why do I get this error..'?. (remember I'm a newbie)
> Eh, I know that running Exchange and SqlServer on the same server is not a
> good thing,
> slow performance..etc... I´d setup this system in the porpose of learning
> about
> sqlserver&exchange&win2k3server...
> Jeff
>
>|||If you continue to have problems try smtp mail. It's much simpler and more
reliable than mapi.
http://sqldev.net/xp/xpsmtp.htm
Paul
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23XB1%23pyeDHA.1748@.TK2MSFTNGP10.phx.gbl...
> I was sure that a MAPI-compliant client, such as Outlook, had to be
> installed *on* the SQL Server machine, and that it had to use an account
> that SQL Server was privy to...
> I think there's a way to make it work with Outlook Express, but I'm not
sure
> it's supported.
> Maybe some helpful links here (including the possibility of using SMTP
> instead of Exchange/MAPI/SQL Mail)?
> http://www.aspfaq.com/2403
>
>
> "Jeff" <it_consultant1@.hotmail.com> wrote in message
> news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> > My system:
> > I have installed Sql Server 2000 on my server (MS windows server 2003
> > enterprise edtion)
> > In addition Exchange Server 2003 standard edition is installed on this
> > server.
> >
> > Every users on my network, have an e-mail account in exchange
> >
> > On the clients, every user have Outlook Express with a MAPI profile.
> >
> > My problem is that when I in SqlServer properties specifies SQL Mail
> profile
> > and
> > push the Test-button I get this error message:
> > "Error 18025: xp_test_mapi_profile : failed with mail error
0x80040111".
> >
> > And if I just push the Ok-button in the dialoge specifying SQL Mail
> profile.
> > I get this message:
> > "The MAPI profile was not found on the server, Are you this is what you
> > want?" (yes/no-button)
> >
> > The profile name i specified is used in Outllook express to send email
> using
> > MAPI...
> >
> > so why do I get this error..'?. (remember I'm a newbie)
> >
> > Eh, I know that running Exchange and SqlServer on the same server is not
a
> > good thing,
> > slow performance..etc... I´d setup this system in the porpose of
learning
> > about
> > sqlserver&exchange&win2k3server...
> >
> > Jeff
> >
> >
> >
>