Display date: enterprise

显示标签为“enterprise”的博文。显示所有博文

2012年3月20日星期二

Discrepancy in whether SP2 is installed

I couldn't remember which computers I had already installed sp2 on so checked but one computer (running Windows Server 2003 and SQL 2005 Enterprise Edition) seems to have a discrepancy. SELECT @.@.VERSION returns (Build 3790: Service Pack 1) but the status bar shows "9.0 SP2". Thanks for any insight into this.

-Dave

Can you post the entire string for the @.@.version call? This output includes the OS service pack as well as the SQL Service pack, so my guess is that the SP1 refers to your OS SP.

Thanks,
Sam Lester (MSFT)

|||

Here it is:

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

Mar 23 2007 16:28:52

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

(1 row(s) affected)

Thanks,

-Dave

|||

Yes, the first line in the @.@.VERSION call shows that you have SP2 installed.

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)

This line shows your SQL version (3054). SP2 is build number 3042, which means you've applied SP2 and a patch on top of that (cumulative patch 3054).

The OS edition is stated in the last line:

Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

I believe that means you are running Windows 2003 SP1.

Thanks,
Sam

2012年3月8日星期四

Disaster Recovery

I am planing to implement a disaster recovery site for my enterprise system
consisting of database servers( sql server 2000) , web servers(IIS) and
application servers, all on microsoft platforms.
in case of any disaster it should failover to the other server in other site.
what about using third party solution like Neverfail or Xosoft ,Vertas
solution for achieving this.
which you recommend ?
Pls SHARE your opinion.
Note:cost is not a constarint.Take a look at
http://www.sql-server-performance.com/sql_server_log_shipping.asp
"bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>I am planing to implement a disaster recovery site for my enterprise system
> consisting of database servers( sql server 2000) , web servers(IIS) and
> application servers, all on microsoft platforms.
> in case of any disaster it should failover to the other server in other
> site.
> what about using third party solution like Neverfail or Xosoft ,Vertas
> solution for achieving this.
> which you recommend ?
> Pls SHARE your opinion.
> Note:cost is not a constarint.
>|||Hi uri,
I am already having cluster,log sipping, replication configured for database
but what i am looking for is a automatic failover to different site without
any data loss.
"Uri Dimant" wrote:
> Take a look at
> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>
>
>
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
> >I am planing to implement a disaster recovery site for my enterprise system
> > consisting of database servers( sql server 2000) , web servers(IIS) and
> > application servers, all on microsoft platforms.
> > in case of any disaster it should failover to the other server in other
> > site.
> > what about using third party solution like Neverfail or Xosoft ,Vertas
> > solution for achieving this.
> >
> > which you recommend ?
> >
> > Pls SHARE your opinion.
> >
> > Note:cost is not a constarint.
> >
>
>|||If your requirements are automatic failover without data loss then ...
I understand that only Failover Clustering and Database Mirroring provide
automatic failover with no data loss. But failover clustering has only one
copy of the database. So, for your requirements that leaves database
mirroring as your only choice.
But here I am talking only about SQL Server technologies. I do not know
about choices from other vendors.
Benjamin Nevarez, MCDBA, OCP
"bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
> Hi uri,
> I am already having cluster,log sipping, replication configured for
> database
> but what i am looking for is a automatic failover to different site
> without
> any data loss.
> "Uri Dimant" wrote:
>> Take a look at
>> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>>
>>
>>
>> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
>> in
>> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>> >I am planing to implement a disaster recovery site for my enterprise
>> >system
>> > consisting of database servers( sql server 2000) , web servers(IIS) and
>> > application servers, all on microsoft platforms.
>> > in case of any disaster it should failover to the other server in other
>> > site.
>> > what about using third party solution like Neverfail or Xosoft ,Vertas
>> > solution for achieving this.
>> >
>> > which you recommend ?
>> >
>> > Pls SHARE your opinion.
>> >
>> > Note:cost is not a constarint.
>> >
>>|||Ben
Database Mirroring will be available for production only in the first half
2006.
"Ben Nevarez" <bnevarez@.sjm.com> wrote in message
news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
> If your requirements are automatic failover without data loss then ...
> I understand that only Failover Clustering and Database Mirroring provide
> automatic failover with no data loss. But failover clustering has only one
> copy of the database. So, for your requirements that leaves database
> mirroring as your only choice.
> But here I am talking only about SQL Server technologies. I do not know
> about choices from other vendors.
> Benjamin Nevarez, MCDBA, OCP
>
>
> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
>> Hi uri,
>> I am already having cluster,log sipping, replication configured for
>> database
>> but what i am looking for is a automatic failover to different site
>> without
>> any data loss.
>> "Uri Dimant" wrote:
>> Take a look at
>> http://www.sql-server-performance.com/sql_server_log_shipping.asp
>>
>>
>>
>> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
>> in
>> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
>> >I am planing to implement a disaster recovery site for my enterprise
>> >system
>> > consisting of database servers( sql server 2000) , web servers(IIS)
>> > and
>> > application servers, all on microsoft platforms.
>> > in case of any disaster it should failover to the other server in
>> > other
>> > site.
>> > what about using third party solution like Neverfail or Xosoft ,Vertas
>> > solution for achieving this.
>> >
>> > which you recommend ?
>> >
>> > Pls SHARE your opinion.
>> >
>> > Note:cost is not a constarint.
>> >
>>
>|||I know. But it is December already, so right now it is a good time to test
the technology.
In addition, the original request mentions a SQL Server 2000 instalation.
So, in order to get benefit of database mirroring an upgrade is required,
isn't?
Ben Nevarez, MCDBA, OCP
Database Administrator
"Uri Dimant" wrote:
> Ben
> Database Mirroring will be available for production only in the first half
> 2006.
>
> "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
> >
> > If your requirements are automatic failover without data loss then ...
> >
> > I understand that only Failover Clustering and Database Mirroring provide
> > automatic failover with no data loss. But failover clustering has only one
> > copy of the database. So, for your requirements that leaves database
> > mirroring as your only choice.
> >
> > But here I am talking only about SQL Server technologies. I do not know
> > about choices from other vendors.
> >
> > Benjamin Nevarez, MCDBA, OCP
> >
> >
> >
> >
> > "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> > message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
> >> Hi uri,
> >> I am already having cluster,log sipping, replication configured for
> >> database
> >> but what i am looking for is a automatic failover to different site
> >> without
> >> any data loss.
> >>
> >> "Uri Dimant" wrote:
> >>
> >> Take a look at
> >> http://www.sql-server-performance.com/sql_server_log_shipping.asp
> >>
> >>
> >>
> >>
> >>
> >>
> >> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
> >> in
> >> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
> >> >I am planing to implement a disaster recovery site for my enterprise
> >> >system
> >> > consisting of database servers( sql server 2000) , web servers(IIS)
> >> > and
> >> > application servers, all on microsoft platforms.
> >> > in case of any disaster it should failover to the other server in
> >> > other
> >> > site.
> >> > what about using third party solution like Neverfail or Xosoft ,Vertas
> >> > solution for achieving this.
> >> >
> >> > which you recommend ?
> >> >
> >> > Pls SHARE your opinion.
> >> >
> >> > Note:cost is not a constarint.
> >> >
> >>
> >>
> >>
> >
> >
>
>|||Hi Guys,
any body used third party tools like veritas,nevefail or xosoft to achieve
this.
"Ben Nevarez" wrote:
> I know. But it is December already, so right now it is a good time to test
> the technology.
> In addition, the original request mentions a SQL Server 2000 instalation.
> So, in order to get benefit of database mirroring an upgrade is required,
> isn't?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Uri Dimant" wrote:
> > Ben
> > Database Mirroring will be available for production only in the first half
> > 2006.
> >
> >
> >
> > "Ben Nevarez" <bnevarez@.sjm.com> wrote in message
> > news:%23Hg7NpX%23FHA.500@.TK2MSFTNGP15.phx.gbl...
> > >
> > > If your requirements are automatic failover without data loss then ...
> > >
> > > I understand that only Failover Clustering and Database Mirroring provide
> > > automatic failover with no data loss. But failover clustering has only one
> > > copy of the database. So, for your requirements that leaves database
> > > mirroring as your only choice.
> > >
> > > But here I am talking only about SQL Server technologies. I do not know
> > > about choices from other vendors.
> > >
> > > Benjamin Nevarez, MCDBA, OCP
> > >
> > >
> > >
> > >
> > > "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote in
> > > message news:DB2A7267-4DC7-4827-B2E7-E2C00A81852B@.microsoft.com...
> > >> Hi uri,
> > >> I am already having cluster,log sipping, replication configured for
> > >> database
> > >> but what i am looking for is a automatic failover to different site
> > >> without
> > >> any data loss.
> > >>
> > >> "Uri Dimant" wrote:
> > >>
> > >> Take a look at
> > >> http://www.sql-server-performance.com/sql_server_log_shipping.asp
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> "bijupg@.hotmail.com" <bijupghotmailcom@.discussions.microsoft.com> wrote
> > >> in
> > >> message news:385E5814-498C-429B-8A2D-3145EC2CFAFA@.microsoft.com...
> > >> >I am planing to implement a disaster recovery site for my enterprise
> > >> >system
> > >> > consisting of database servers( sql server 2000) , web servers(IIS)
> > >> > and
> > >> > application servers, all on microsoft platforms.
> > >> > in case of any disaster it should failover to the other server in
> > >> > other
> > >> > site.
> > >> > what about using third party solution like Neverfail or Xosoft ,Vertas
> > >> > solution for achieving this.
> > >> >
> > >> > which you recommend ?
> > >> >
> > >> > Pls SHARE your opinion.
> > >> >
> > >> > Note:cost is not a constarint.
> > >> >
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >

Disappering sp??

Does anyone know why a sp would disappear after loging out & in of the Enterprise Manager in SQL Server 2000? When I execute the sp from the Query Analizer it seems to loop but it is still there after I cancel it. If I run just the code in the Query Anaylizer, it runs fine. Due that it involves tables in 2 sql servers, to create the sp I run :

SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_DEFAULTS ON
set XACT_ABORT on
GO
Create procedure xyz as ...

The error reported in the log is :
Error: 15457, Severity: 0, State: 1

It's weird how after I close EM and go back again, the sp is not in the sp list anymore.

Any ideas? PLS HELP!The SPs displayed in EM are cached. If the SP is dropped or created e.g. from a script then the current state will not be displayed in EM. If you refresh the list by right clicking on Stored Procedures then you will get the correct state at that moment - this has the same effect as logging out and logging in.
If an SP is dropped or changes ID the EM will give an error if you try to display it.

Try select name from sysobjects where xtype = 'P' to get the list.

2012年3月7日星期三

Disappearing Linked Server Stored Procedures

When I create a stored procedure like the one below and save it,
everything seems fine. But when I close Enterprise Manager and
re-open it, the stored procedure is gone.

Any ideas?

SET ANSI_DEFAULTS ON
GO
CREATE PROCEDURE [dbo].[sp_Test] AS
SELECT * FROM OPENQUERY(LINKEDSERVER, 'SELECT V.VENDOR_ID,
V.VENDOR_NAME FROM VENDOR V')
GO

Ted"Ted Calhoon" <tedcalhoon@.hotmail.com> wrote in message
news:fc57c4d8.0312121455.1e0677d8@.posting.google.c om...
> When I create a stored procedure like the one below and save it,
> everything seems fine. But when I close Enterprise Manager and
> re-open it, the stored procedure is gone.
> Any ideas?
>
> SET ANSI_DEFAULTS ON
> GO
> CREATE PROCEDURE [dbo].[sp_Test] AS
> SELECT * FROM OPENQUERY(LINKEDSERVER, 'SELECT V.VENDOR_ID,
> V.VENDOR_NAME FROM VENDOR V')
> GO
>
> Ted

If you put only the CREATE PROCEDURE statement into the create procedure
dialogue, it will work:

CREATE PROCEDURE [dbo].[sp_Test] AS
SELECT * FROM OPENQUERY(LINKEDSERVER, 'SELECT V.VENDOR_ID,
V.VENDOR_NAME FROM VENDOR V')

Presumably, this is a 'feature' in EM, which seems to have a number of
quirks. If you need full control over the CREATE PROC statement, you should
execute it in Query Analyzer instead, which is probably a better practice in
general.

Also, don't use sp_ as a procedure name prefix, that's reserved for system
stored procedures.

Simon|||Thanks, Simon. I will take your advice and:

1. Use Query Analyzer to create stored procedures
2. Avoid using sp_ when naming my stored procedures

Ted

Disappearing databases - HELP!

Running SQL Server 2000 - patched up to date, behind firewall, on Win2003
Server, using MacAfee VirusScan Enterprise
Over the lunchtime, we seem to have lost several databases from a couple of
server groups on our server!
It appears no-one was working on the server at the time.
Does anyone know if there is a virus/worm which is capable of this?
Any ideas gratefully received ;-)
TIA
SteveCyberDwarf wrote:
> Running SQL Server 2000 - patched up to date, behind firewall, on Win2003
> Server, using MacAfee VirusScan Enterprise
> Over the lunchtime, we seem to have lost several databases from a couple of
> server groups on our server!
> It appears no-one was working on the server at the time.
> Does anyone know if there is a virus/worm which is capable of this?
> Any ideas gratefully received ;-)
> TIA
> Steve
>
Do you have Internet sites talking to these databases, and are those
sites properly protected from SQL injection attacks? Have you checked
the SQL logs to see if there are clues there? The Windows event logs?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy
Thx for your rapid reply.
No, there are no connections to this server from the Net.
Am in the process of checking the logs
Regards
Steve|||SQL Server log shows no unusual activity at all!!
Doh!|||On Wed, 9 Aug 2006 16:14:37 +0100, "CyberDwarf"
<steve.ingle@.lineone.net> wrote:
in <eWTymY8uGHA.4756@.TK2MSFTNGP02.phx.gbl>
>Running SQL Server 2000 - patched up to date, behind firewall, on Win2003
>Server, using MacAfee VirusScan Enterprise
>Over the lunchtime, we seem to have lost several databases from a couple of
>server groups on our server!
>It appears no-one was working on the server at the time.
>Does anyone know if there is a virus/worm which is capable of this?
>Any ideas gratefully received ;-)
>TIA
>Steve
>
I've seen System Restore wipe out databases.
Stefan Berglund|||Cyber
As you're desribing the issue, it looks like (very sad to say) that
someone who has/have permissions just droped the databases. I have
experience at our shop unfortunatly.
"CyberDwarf" <steve.ingle@.lineone.net> wrote in message
news:eWTymY8uGHA.4756@.TK2MSFTNGP02.phx.gbl...
> Running SQL Server 2000 - patched up to date, behind firewall, on Win2003
> Server, using MacAfee VirusScan Enterprise
> Over the lunchtime, we seem to have lost several databases from a couple
> of server groups on our server!
> It appears no-one was working on the server at the time.
> Does anyone know if there is a virus/worm which is capable of this?
> Any ideas gratefully received ;-)
> TIA
> Steve
>

disappearing "database maintenance plan"

When I try to view the properties of a database
maintenance plan in Enterprise Manager, it flashes on the
screen and disappears. I have tried it on the local
machine as well as other machines with Enterprise
Manager. Other server registrations work just fine. I
can build database maintenance plans without any trouble
but can't go back to edit them.
Thanks for the help.Hi Robert,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From the information you provided, in one of your computer, in the
enterprise manager, when you right-click one maintenance plan and want to
see the properties of it, it is flashed and disappear so you cannot view
it, right?
You could look at the following articles for reference,
Unable to View the Properties for a Database Maintenance Plan
http://support.microsoft.com/?id=323607
Hope this helps. If you still have questions, please feel free to post
message here and I am ready to help.
Thanks
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Robert,
Have you seen the article in my last reply? Do you still have any question
about it? I am glad to help for any more questions.
Looking forward to hearing from you.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

disappearing "database maintenance plan"

2012年2月25日星期六

Disabling Product Feedback on en masse deployment?

Hello.

After installing SQL 2005 Enterprise (MSDN-version), I was greeted with Product Feedback pop-ups on opening SSMS.

I'm all about product feedback (hence why I'm here), but before I deploy a final/non-MSDN version to lots of users, I was wondering
- if this also occurs with the non-MSDN version?
- if there is a way to pre-disable the feedback options?

I assume you're referring to the Watson and SQM messages, which I think is the final screen of the Setup process. This is present in all versions of the product.

One way to disable the pop-up is to do a command line install, specifying an appropriate value for Errorreporting and SQMReporting. Read through template.ini in the Dev folder of the CD/DVD for specifics.

|||

Ok, will research.

Once SSMS is installed, and opened for the first time, two pop-ups appear...

Microsoft SQL Server Customer Feedback Options
O Yes, I am will to participate anonymously...
O No, I don't wish to participate

and

Customer Experience Improvement Program (appears with Visual Studio icon)
O Yes, I am will to participate anonymously...
O No, I would not like to participate

I am also able to regenerate the Feedback pop-ups when I open SSMS using "Run As" and supplying another user's credentials.

|||

I think this is different. Your suggestion may map to the setup-step that says the following:

Error and Usage Report Settings

[] Automatically send Error Reports for SQL Server 2005 to Microsoft or your corporate error reporting server.... (Watson setting?)

[] Automatically send Feature Usage data for SQL Server 2005 to Microsoft.... (SQM setting?)

[Help] [< Back] [Next >] [Cancel]
__

The feedback balloons/pop-ups appear after setup.

|||Ah, you're right. I don't know how to deal with the pop-up you're referring to. I'll ask a couple people but don't know if I'll get an answer...|||

Thanks for any info if possible. I've built the following Registry adjustment, but has been unsuccessful. (SSMS seems to regenerate values on first-time use?)

Windows Registry Editor Version 5.00

[HKEY_USERS\.DEFAULT\Software\Microsoft\Microsoft SQL Server]
[HKEY_USERS\.DEFAULT\Software\Microsoft\Microsoft SQL Server\90]
"CustomerFeedback"=dword:00000000
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server]
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90]
"CustomerFeedback"=dword:00000000
[HKEY_USERS\S-1-5-18\Software\Microsoft\Microsoft SQL Server]
[HKEY_USERS\S-1-5-18\Software\Microsoft\Microsoft SQL Server\90]
"CustomerFeedback"=dword:00000000
[HKEY_USERS\.DEFAULT\Software\Microsoft\VSCommon]
[HKEY_USERS\.DEFAULT\Software\Microsoft\VSCommon\8.0]
[HKEY_USERS\.DEFAULT\Software\Microsoft\VSCommon\8.0\SQM]
@.="0"
[HKEY_CURRENT_USER\Software\Microsoft\VSCommon]
[HKEY_CURRENT_USER\Software\Microsoft\VSCommon\8.0]
[HKEY_CURRENT_USER\Software\Microsoft\VSCommon\8.0\SQM]
@.="0"
[HKEY_USERS\S-1-5-18\Software\Microsoft\VSCommon]
[HKEY_USERS\S-1-5-18\Software\Microsoft\VSCommon\8.0]
[HKEY_USERS\S-1-5-18\Software\Microsoft\VSCommon\8.0\SQM]
@.="0"

I also take your response as verifying this behavior is the same on the final, non-MSDN release?

|||

Rather than speculate further, I'm just moving this thread to the Tools forum, where Management Studio experts can help you out.

Paul

Disabling NetBIOS from private/heartbeat NICs after SQL Server installation

In document "Installation order for SQL Server 2000 Enterprise Edition
on Microsoft Cluster Server"
(http://support.microsoft.com/kb/q243218/), as one of the
pre-installation checklist tasks it states "You have disabled NetBIOS
for all private network cards before you start the SQL Server Setup
program."
Here is the thing, our NT Admin. configured the cluster service and
installed SQL Server with the NetBIOS enabled. We know we can change
this setting after the fact but we don't know if there are any
repercussions to doing this? Does anybody have any insight into making
this post-facto installation change?
It shouldn't hurt anything on the heartbeat cable.
dw
Hope it helps
dw
_______________________________
Don Wilwol
donwilwol(DELETE)@.yahoo.com
http://spaces.msn.com/members/wilwol/
"Sean" <spowell71@.hotmail.com> wrote in message
news:1125431374.514801.234000@.g44g2000cwa.googlegr oups.com...
> In document "Installation order for SQL Server 2000 Enterprise Edition
> on Microsoft Cluster Server"
> (http://support.microsoft.com/kb/q243218/), as one of the
> pre-installation checklist tasks it states "You have disabled NetBIOS
> for all private network cards before you start the SQL Server Setup
> program."
> Here is the thing, our NT Admin. configured the cluster service and
> installed SQL Server with the NetBIOS enabled. We know we can change
> this setting after the fact but we don't know if there are any
> repercussions to doing this? Does anybody have any insight into making
> this post-facto installation change?
>
|||For the Private, this is a best practice, it won't hurt a thing!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"Sean" <spowell71@.hotmail.com> wrote in message
news:1125431374.514801.234000@.g44g2000cwa.googlegr oups.com...
> In document "Installation order for SQL Server 2000 Enterprise Edition
> on Microsoft Cluster Server"
> (http://support.microsoft.com/kb/q243218/), as one of the
> pre-installation checklist tasks it states "You have disabled NetBIOS
> for all private network cards before you start the SQL Server Setup
> program."
> Here is the thing, our NT Admin. configured the cluster service and
> installed SQL Server with the NetBIOS enabled. We know we can change
> this setting after the fact but we don't know if there are any
> repercussions to doing this? Does anybody have any insight into making
> this post-facto installation change?
>
|||Thanks, it worked out great for us. There is a big stability difference
NetBIOS disabled.

2012年2月19日星期日

Disable the use of Enterprise Manager

I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application' if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application'
Yes.
> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>

Disable the use of Enterprise Manager

I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application? if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application?
Yes.

> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>
|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>

2012年2月17日星期五

Disable MSX Functionality

Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegroups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 712 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk|||Nice one, thanks!
Dave

Disable MSX Functionality

How do you stop an MSX server being an MSX server?
In other words, how do I get Enterprise Manager back to the state where
under SQL Server Agent\Jobs I don't get sub-folders of Local and
Remote, and I'm not allowed to target jobs at other servers?
Thanks.
DaveHi,
just force defection of all your target Servers. When the last target
server
is defected then your MSX functionality should stop automatically.
Regards :)
Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegroups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
---
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at fÃ¥ 712 spam-mails.
Betalende brugere fÃ¥r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk|||Nice one, thanks!
Dave

Disable MSX Functionality

Bobby Henningsen
"Dave" <david.randall@.tradeweb.com> wrote in message
news:1132328870.648249.134860@.g49g2000cwa.googlegr oups.com...
> How do you stop an MSX server being an MSX server?
> In other words, how do I get Enterprise Manager back to the state where
> under SQL Server Agent\Jobs I don't get sub-folders of Local and
> Remote, and I'm not allowed to target jobs at other servers?
> Thanks.
> Dave
>
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f? 712 spam-mails.
Betalende brugere f?r ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dk
|||Nice one, thanks!
Dave

2012年2月14日星期二

Disable EM ?

Is is possible to disable Enterprise Manager and still
retain query analyzer functionality?
If yes then how?
else
Thanks
TVO
"TVO" <anonymous@.discussions.microsoft.com> wrote in message
news:002801c46dc0$53377bb0$a301280a@.phx.gbl...
> Is is possible to disable Enterprise Manager and still
> retain query analyzer functionality?
You can use security to effectively prevent a user from mis-using Enterprise
Manager.

> If yes then how?
The most secure solution would only allow read or execute permissions on
designated views, or stored procedures.
Steve
|||I have permissions applied through AD Groups and SELECT
only rights are applied. However the locking semantics
of EM are different than that of QA. I want to disable
their ablilty to launch or use EM and yet still allow
them to query via written code using QA. Any ideas?
Thanks

>--Original Message--
>"TVO" <anonymous@.discussions.microsoft.com> wrote in
message
>news:002801c46dc0$53377bb0$a301280a@.phx.gbl...
>You can use security to effectively prevent a user from
mis-using Enterprise
>Manager.
>
>The most secure solution would only allow read or
execute permissions on
>designated views, or stored procedures.
>Steve
>
>.
>
|||Change the security settings for ...\Microsoft SQL Server\80\Tools\BinnSQL
Server Enterprise Manager.MSC
or delete it.
"TVO" <anonymous@.discussions.microsoft.com> wrote in message
news:00a001c46dc8$654f2930$a301280a@.phx.gbl...[vbcol=seagreen]
> I have permissions applied through AD Groups and SELECT
> only rights are applied. However the locking semantics
> of EM are different than that of QA. I want to disable
> their ablilty to launch or use EM and yet still allow
> them to query via written code using QA. Any ideas?
> Thanks
>
> message
> mis-using Enterprise
> execute permissions on
|||Of course that would not help if the user(s) have installed the SQL Server
tools on their devices. Security is the best way to go here, unless you want
to write a stored procedure that monitors sysprocesses, and terminate any
connection (via EM) that is not appropriate. Seems like a lot of work to
me...
Steve
"news.microsoft.com" <deo.is@.unknown.com> wrote in message
news:%230mn1NebEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Change the security settings for ...\Microsoft SQL Server\80\Tools\BinnSQL
> Server Enterprise Manager.MSC
> or delete it.
> "TVO" <anonymous@.discussions.microsoft.com> wrote in message
> news:00a001c46dc8$654f2930$a301280a@.phx.gbl...
>

订阅：博文 (Atom)

2012年3月20日星期二

Discrepancy in whether SP2 is installed

2012年3月8日星期四

Disaster Recovery

Disaster Recovery

Disaster Recovery

Disappering sp??

2012年3月7日星期三

Disappearing Linked Server Stored Procedures

Disappearing databases - HELP!

disappearing "database maintenance plan"

disappearing "database maintenance plan"

2012年2月25日星期六

Disabling Product Feedback on en masse deployment?

Disabling NetBIOS from private/heartbeat NICs after SQL Server installation

2012年2月19日星期日

Disable the use of Enterprise Manager

Disable the use of Enterprise Manager

2012年2月17日星期五

Disable MSX Functionality

Disable MSX Functionality

Disable MSX Functionality

2012年2月14日星期二

Disable EM ?

Display date

Blog Archive

About Me