Idera SQL Server Tools

Jan 11, 2008

Opinions on Idera??

A rep from Idera came to pitch Idera SQL Server tools.
My boss is mostly interested in SOX compliance auditing for
relatively few servers.

We have some interest in performance monitoring.

I am mostly interested in a centralized configuration database
to manage 50 or so instances of SQL Server, both SQL 2000 and 2005.

Have you tried Idera?
Like?
Like something else better?

View 1 Replies


ADVERTISEMENT

Idera SQLsafe Freeware

Aug 7, 2007

Anyone using the freeware version of Idera SQLsafe?
I would ike to know pros and cons for moving this product to production systems.

We are running very low on disk space and have no funds to get more space at this time.

View 8 Replies View Related

SQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012

Mar 25, 2014

Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.

View 6 Replies View Related

Design Tools / Sql Server Mgt Tools Cause Login Fail

Sep 20, 2007

Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
 sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
 

View 2 Replies View Related

Server Tools Or Client Tools?

Jun 16, 2008

Dear All,
how can we know that wether we had server tools or client tools on my machine?

Arnav
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

SQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists

Oct 20, 2014

The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.

Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Exit code (Decimal):           -2068052700
  Exit facility code:            1212
  Exit error code:               1316
 
[code]...

View 10 Replies View Related

Backup Strategy - SQL2005 Tools Versus 3rd Party Tools

Jun 1, 2007

I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?

View 3 Replies View Related

SQL Tools :: Tools To Determine Version From BAK File

Apr 24, 2014

Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.

Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?

Where would I find the version "bytes" in a BAK file?

View 4 Replies View Related

Tools Tools Tools For Performance ???

May 16, 2002

Know any good performance monitoring and analysis tools for SQL server.

View 1 Replies View Related

Tools For SQL Server

Dec 14, 2005

I'm a newbie in working with SQL Server. Can anybody prompt me some good tools for SQL Server administration and other useful tools for Microsoft SQL Server???

View 5 Replies View Related

SQL Server Compact Edition Server Tools Setup Error On Vista

Oct 21, 2007

SQL Server 2005 SP2 Replication


I am having problems installing the SQL Server Compact Server Tools on my
Vista laptop to allow me to connect my Mobile Device running SQL Server
Compact directly to my SQL Server 2005 database through IIS.


I have done this successfully with an XP machine so I'm not sure if it is
Vista problem or not.


I have installed SQL Server 2005 SP2. When I try to install the replication
server tools (Sqlce30setupen.msi), in "System Configuration Check" window I get a failure on "SQL Server requirement" that says: "You must first install the Replication Components for SQL Server 2000 SP 3a
or higher or the SQL Server 2005 Replication Components" and the client components are full instaled in my computer.



I need help for detect and correct the problem.


Sincereously,
Alonso Junior

View 4 Replies View Related

Using SQL Server Management Studio Tools To Manage Dbs On SQL Server Express Edition

Apr 25, 2008

Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted.

I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition.

Thank you in advance for your help.

View 7 Replies View Related

Which SQL Server 2005 Compact Edition Server Tools Installation Package Do I Use?

May 26, 2007

Hi,



I am using SQL Express 2005 server and sql compact edition for my PDA. For synchronization, which SQL Server 2005 Compact Edition Server Tools installation package do I use?



Is it Sqlce30setupen.msi or sql2kensp4.msi or sql2kensp3a.msi? I know for sql server 2005 its Sqlce30setupen.msi. Is it the same for the SQL Express 2005?



Thanks

View 4 Replies View Related

SQL Server 2005 Client Tools Not Shown Up In Start Menu On Windows 2003 Server

Jul 18, 2007

Hello,



I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.



I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.



The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).



One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.



I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?



Thanks

View 11 Replies View Related

MSDE && SQL Server 2005 Mobile Server Tools Problem

Jan 24, 2006

After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.

"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"

Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??

View 7 Replies View Related

Server Monitoring Tools

Jun 14, 2000

I want to know if there are any tools that will allow
a DBA to monitor changes that occur on SQL databases
(deletion, addittion or modifications) on any objects,
and Sql security.

I have looked at Profiler in SQL and it is very limited
and plus it is huge memory hog and causes degradation on
your servers.

View 2 Replies View Related

MS SQL Server Monitoring Tools

Feb 19, 2004

We've got about fifty MSSQL Servers (7.0 and 2000) in our shop.
Can anybody recommend a good tool to monitor all kind of activities and conditions on those servers?

View 1 Replies View Related

SQL Server Tools Information

May 29, 2005

Hi to all Friends,
Now a days i have a query regarding SQL Server deployment.Is it possible that on our client side we not install enterprise manager due to some managerial problems.Because we are feeling that using enterprise manager our database design is not save and somebody can copy it.Please help me on this issue.
Thanks

View 4 Replies View Related

What Tools Should Developers Use For SQL Server?

Jun 13, 2007

This may be an intuitively obvious question, and if so, I apologize.

Speaking in terms of best practices here, what is the preferred method for allowing developers to work with databases in SQL Server? If they use Management Studio, then they have access to tools for perhaps messing with other databases, etc. that they should not (assuming it is not correctly secured). Likewise with Enterprise Manager. I can see where they would use Query Analyzer, but these two are now combined in Management Studio.

I'm just inquiring into how other DBA's do this. I realize there are DBA's that are developers and vice-versa, but what if there is a clear line of distinction and you want to keep the tools used in these roles separate?

Thanks in advance.

Kevin

View 3 Replies View Related

SQL Server 2000/05 Tools??

Mar 18, 2008

I am looking for best blogs/articles on Debugging, performance for SQL server 2000/2005.

Please provide me links

View 1 Replies View Related

SQL Server Client Tools

Jan 28, 2006

HiHow network administartor can find , who has AQL server client tools onhis system?Thanks

View 2 Replies View Related

Preferred SQL Tools For Sql*server?

Jul 20, 2005

Hi All,I am new this week to sql*server / query analyzer, coming from yearsof an oracle / TOAD background. Does anyone have any tools theyprefer for writing and executing sql code other than query analyzer?Thanks!Mike

View 1 Replies View Related

SQL Server Administration Tools

Jul 20, 2005

I'm searching for some alternate administration tool (permisions, rights,etc.) on sql server, something not so complicated as default. Does anyonehave some info about that? ThanksPete

View 1 Replies View Related

SQL Tools :: How To Connect To AD From Server

Jul 28, 2015

I need to connect to Active Directory in a stored procedure to try to verify if a user exists. code snippet to do the same? 

View 5 Replies View Related

SQL Server CE Tools Problem

Feb 20, 2007

Hi

I had VS 2005 Pro and SQL Server Dev. Ed. 2005 installed. These were patched to SQL Server 2005 SP1 and then VS2005 SP1. Yesterday I installed SQL 2005 SP2.

Today I successfully installed the main bits from http://www.microsoft.com/sql/editions/compact/downloads.mspx but the VS tools will not install. It's telling me that the upgrade cannot continue. I think that VS2005 SP1 may already include the SQL CE tools - is this correct? I do not see any mention of this when I go Server Explorer->Connect to a database

-Brian

View 7 Replies View Related

You Must Use SQL Server 2005 Management Tools To Connect To This Server

Feb 2, 2007

Hello,
After installing SQL Server 2005, I get a message stating "You must use SQL Server 2005 management tools to connect to this server", while trying to connect to my localhost using SQL Server 2000 Enterprise Manager.
Regards,
junior

View 4 Replies View Related

Sql Server 2000 Client Tools W/ Sql Server 7 Backend

Jun 22, 2000

Hi,
A quick Q for all the Sql Server 2000 beta testers out there. Does anyone know of any problems associated with using SS2000 Enterprise Manager with a SS7 backend running SP2? In particular, I'm keen to try out the Tsql debugger features, if they'll work with SS7.

Many thanks in advance,
Jon Reade,
Sql Server 7 DBA
NEC Technologies (UK) Ltd
Telford, Shropshire.

View 1 Replies View Related

SQL Server 2005 Mobile Edition Using Server Tools

Jan 20, 2007

I have installed SQL Server 2005 Mobile edition and also the server tools.

I configured a website to sync with my mobile application. When I go t check the SQL server Mobile agent with this url:

http://localhost/MobileTest/sqlcesa30.dll i get a http 500 internal error

I am using remote desktop to access the machine, when I am directly on the machine there is no error I get the correct message in the browser

"SQL Server Mobile Server Agent 3.0"

Is access to the web site via remote desktop a problem?

jawahar

View 1 Replies View Related

SQL Server Mobile Server Tools On Mutiple Servers ?

Nov 6, 2007

Hello,

I want to load-balance my PDAs accessing my database to make a merge replication.
As I have one server with the SQL Server Mobile Server Tools installed, can I configure some of these PDAs to use another server with SQL Server Mobile Server Tools to point on the same Database server?
Is it going to work or will it generate problems?

Thanks for your help,

Ben.

View 4 Replies View Related

SQL Server 8 And SQL Server 2005 Management Tools In Consistencies

Mar 5, 2007

I have been investigating this issue and here is what I have found, when using SQL Server 8 Query Analyzer the results show that for example xp_regread has Execute permissions granted to €˜public€™ role. When checking the Same using the SQL Server 2005 Management Studio the results show that there are no Execute permissions granted to €˜Public€™ Role.



So the following Query doesn't return any results on Management Studio SQL Server 2005:

SELECT sysusers.name
, Status =
CASE protecttype

WHEN 204 THEN 'GRANT_W_GRANT'

WHEN 205 THEN 'GRANT'

WHEN 206 THEN 'REVOKE'

ELSE 'Unknown'

END

, Permission =

CASE action

WHEN 193 THEN 'SELECT'

WHEN 195 THEN 'INSERT'

WHEN 196 THEN 'DELETE'

WHEN 197 THEN 'UPDATE'

WHEN 26 THEN 'REFERENCE'

WHEN 224 THEN 'EXECUTE'

ELSE 'Unknown'

END

, sysobjects.name

FROM sysprotects, sysobjects, sysusers

WHERE sysobjects.id = sysprotects.id

AND sysprotects.action IN (193, 195, 196, 197, 224, 26)

AND sysprotects.uid = sysusers.uid

AND sysusers.name = 'public'

AND (sysobjects.name like '%xp_%' OR sysobjects.name like '%sp_OA%')



Where as running the Same Query in SQL Server 8.0 Query Analyzer will return results, saying there are a few extended procs available to Public for Execute.

Do you know whats going on here?

Thanks!

View 4 Replies View Related

[SQL-DMO]You Must Use SQL Server 2005 Management Tools To Connect To This Server

May 1, 2008

We have just moved from 2000 to 2005 and ever time I try to open store procedure or function I was getting this error message...
[Microsoft][ODBC SQL Server Drive] To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)
So I installed "Microsoft SQL Server 2005 Backward Compatibility Components" from "Feature Pack for Microsoft SQL Server 2005 - April 2006" on the client machine and this resolved the issue. Specifically i installed the "SQL Distributed Management Objects (SQL-DMO) feature .....,
how I am getting following error message


[SQL-DMO]You must use SQL Server 2005 management tools to connect to this server


How can I disabled all other features.

Thanks,

View 3 Replies View Related

How 2 Install Client Tools For SQl Server

May 31, 2004

In Server Explorer of VS .NET 2003, I tried to generate SQL script of the dbo.Portal (ibs)
but got
"To use this feature, you must install the client tols for SQL Server"

When I searched for Help, I've got
"1.Insert the MS SQL Server 2000 compact disc in your CD-ROM drive"

I installed and use MSDE and cannot recall the use of any CD for installation.

1)
Does it mean that I cannot install client tools from MSDE installation?

If not...

2)
I have installation of MS SQL Server200 Enterprise that cannot be installed on Windows Xp Professional that I use. Can I still install "client tools" from Enterprise Ed. for MSDE

View 2 Replies View Related

SQL Server Express Management Tools

Nov 24, 2004

Can anyone tell me where to download the management tools for SQL Server 2005 Express?

Thank you,

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved