Multiserver Administration
Oct 29, 2005I want to set up Multiserver Administration.
The problem I encounter is a firewall between the master server and some
target servers.
What ports need to be set open to make this possible ?
ADVERTISEMENT
MSX Multiserver Administration
Feb 18, 2002I have configured a master server to do multiserver administration and configured my production server as a client. My problem is that when I try to create a multi system maintenance plan it says that I get a security error and it won't create the plan. I have local admin rights to both systems. Do I need domain admin rights?
View 2 Replies View RelatedMultiserver Administration In SQL Server 2005 Standard Edition
Feb 26, 2008
I am running SQL Server 2005 Standard Edition with SP2 on Windows XP professional. When I check the microsoft documentation, it says that it is not possible to setup multiserver administration in standard edition. Have anyone tried this in Standard edition.
Rajakanna
Question On Multiserver Environment In SQL Server 2005
Aug 23, 2007I am creating a backup strategy for our non-production SQL Server 2005 data. We wish to utiliza the Master/Target Server scenario avaible in SQL Server 2005 with events directed to the Master Server. The question I have is what is the symptoms from the Target Servers if the Master Server fails and is unavailable for whatever reason there might be? I can change the event notification back to local server, but what other impact is there and are there any recommendations as to handle a Master Server outage so Maintenance plans can continue to execute as scheduled on Target Servers.
Thank you!
SQLMag InstantDoc 95385 MultiServer Issue
Jun 11, 2007I downloaded this document from the SQLMag website. It is to create a configuration database and seems like a good template. After beginning to set this up, I debugged it. Currently everything runs fine until the package hits load server info. When it tries to load the servers, it turns red. Also, I can't make any changes to the MultiServer Connection Manager because I always get the error "the connection string is not valid." As far as I can tell, this should never be valid when it comes to dynamic connections. Thus, I am perplexed. I really need to get this running, and I think I have narrowed down the error. From what I can tell, MultiServer is a dynamic list of all of the servers on the network. If anybody else has encountered this perticular error, please reply.
-Kyle
Administration
Nov 7, 2007Hi,
I am looking for TSQL book for Administration
Could anybody help ASAP.
Frozen
DBA Administration Db
Mar 13, 2007HI, I would like to set up a dba admin database on each of the instances that I have. Is there any recommended standard format for this database?
Thanks
Can You Do SQL Server Administration From An ASP.NET App?
Jun 11, 2007Is it possible to write an ASP.NET app that can do certain SQL Server 2000 administration tasks, specifically add sql server users, and change sql server user passwords? Would it just be a matter of running the appropriate system stored procedures (sp_password, etc.), or does .NET provide any hooks into SQL Server for something like this? Thanks!
View 5 Replies View RelatedMSSQL Administration
Feb 17, 2008The job failed. The Job was invoked by User SERVER110Administrator. The last step to run was step 1 (Subplan_1).
anyone know what this error means?
Database Administration
Oct 5, 2001To All SQL Guru's
I have this simple problem. How can I make SQL Enterprise Manager list only one database that is accessible by client who registered the SQL Server on his / her Enterprise Manager. The user has been granted access to only one database. But every time I register the server in the client's SQL Server Enterpise Manager it lists all database and user database with it.
I just want it to show only one or two or as how many database that login has granted access to and eliminate the database from the SQL Server Enterprise Manager's database list.
Please Help
Thanks
Remote Administration
Apr 13, 2000Hi!
I need to connect to a database located in another city and administer it from my place.Can any one suggest the basic hardware and sql server(std/enterprice edition?).Shall it be on NT work station or server?Any limitations in administering this way due to some reason we can't move it entirely here.Please advice.
Thanks.
Remote Administration
Nov 28, 2000Hi all,
We are about to have 'colocated servers' for our web pages, mail and on line catalogues. The NT administrator is going to use 'pcAnywhere' to administer the servers. I prefer to register the SQL server in Enterprise Manager,using the IP address.
Are there any known advantages between pcAnywhere against using enterprise manager, particularly any security issues?
Many thanks in advance
Keith
Administration Of SQL 7 Over The Internet
Jan 21, 2000Hi
Could someone help me out with administration of SQL Server over the internet.
What do I need to change on my SQL Server and what will I need to configure on my clients using SQL analyzer connecting over the internet
Vijay
SQL 2000 Administration
Oct 11, 2006Can anyone help me how to monitor the growth of transaction log of our SQL Server?... How will I maintain it?..
View 4 Replies View RelatedUser Administration ...
Mar 15, 2007Hi pals,
I want to create a user in sql server 2000 and i need to give only
INSERT,UPDATE,DELETE,SELECT,CREATE VIEW,CREATE PROCEDURE,ALTER PROCEDURE,DEBUG PROCEDURE,EXECUTE PROCEDURE permissions. i dont want give Administrative priviliges. He should not be able to alter table structures/drop tables.
In SQL server 2005 ihave the concept of DDL triggers so that i can track and restrict whatever suspcious activities (dropping columns,changing datatypes) being done by the database users.
But in SQl Server 2000, what i can do i want restrict the users. to
I need this.can any one me help me out.
Regards,
franky
SSAS05 Cube Administration?
Jul 25, 2006Hi all!
We would like to create an Intranet based cube administration tool.
Power users should be able to process cubes and dimensions. This works
and all the cubes, dimensions and even databases from the SSAS can be
displayed in the web! ASP.NET@C# combined with
Microsoft.AnalysisServices offer a lot of very good possibilities!
But we still have a problem:
How ist it possible to show some kind of progress bar (maybe in a self refreshing iframe or a new window??)??
When a cube/dimension is processed the user does not get ANY feedback
(of course the webserver waits to finish the process() method.
I tried to start a different thread an this even works!
I want to show our powerusers at least some kind of progress (%, events, what ever).
can someone help?? we are totally lost with that topic!
I already had a look at the example from:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=75148&SiteID=1
But it did not lead me to a propper solution :)
TIA and regards
JohnnyR
SQL Server Administration And Config
Mar 2, 2004I'm new in the DBA position recently aquired, and I'm having a few issues with MSSQL configuration and administration.
1. I have created a two maintenance plans, one for system databases and another one for user databases, this plans include things such as, Integrity Checks, Optimizations and DB Backups, however the Integrity Checks fail with the error that the DB's must be in single user mode, how can I go about to make this and what are the implications of doing so?
2. There's been a few reports of MSSQL server compromises through UDP port 1433, so I closed it at firewall level, only TCP 1433 is going through, do I really need UDP 1433?
Thank you very much.
SQL Database Administration Tool
Jun 26, 2005Hi...
Does anybody know of an open source script I can download that will enable me to manage an SQL database? I basically need to access and modify the database from any machine that may not have SQL Enterprise Manager Installed. I was thinking of writing my own script to do this but I assumed that there is probably already one out there.
User Administration Tools
Nov 6, 2001Does anyone have a user administration tool that they like? It seems that there are two common operations that have to be performed:
1. Create a new login for a user, and grant all of the database access rights and role memberships already assigned to another user. In other words, "Make User B just like User A." This same operation has to be performed for multiple servers.
2. Copy a login to a different server. This is usually done to add someone to a test environment. The database names and role names are the same, but the server is different.
In our environment, adding a new employee involves going to three different servers, finding a "model" login, and adding the database access rights for three or four databases, with three or four role memberships in each database. Some databases have thirty or more roles defined, so it's easy to miss a checkmark when scrolling through a list of that size.
I have tinkered with some scripts to do this, but they usually fail because things like sp_addrolemember only work in the current database. I am about to start writing something in VB to do this, but I don't want to reinvent the wheel if someone has already done something similar.
SQL7 & SQL2000 Administration
Dec 1, 2000Is it possible to administer both SQL7 & SQL2000 databases from the same console ?? It's fine administering SQL 6.5 & SQL7, as 6.5 had no MMC, but it seems that SQL7 & SQL2000 have the same MMC.
Thanks,
Jazz.
SQL Server 7 Remote Administration II
Oct 30, 1999Sorry for starting a new thread on this subject but my situation is a bit different.
I want to connect to a remote SQL-server in a DIFFERENT domain, using Enterprise Manager. Whatever I try, I allways get an "SQLserver not found"-error.
The ASP's on the server that make use of the SQL server are functioning without any problems, so I guess the SQL-server itself is OK.
I tried:
servername = URL remote server
setting up a linked server
setting up a remote server
I'm a webdesigner and a newbe to SQLserver7. Please keep in mind I could be overseeing something that very obvious for you.
So what could be the problem. Any tips? Thanks!
Remote Administration Of SQL Server 7.0
Jan 26, 2000Is there a way to remotely control SQL server 7.0 from NT workstation
and win98?
Thanks
williams
Web Administration Of SQL Server 2000
Jul 11, 2001Hi
i Would like to know is there any tool which would allows me to manage database over the web i.e from a brower
if any tool is there can any one let me know from where i can get it
thanks
Prasad
System Management Administration
Oct 19, 2006what is the best firewall protection for network computer?
View 1 Replies View RelatedSQL Server Administration Jobs
Mar 27, 2007(Post removed)
View 3 Replies View RelatedDatabase Administration Survey
Jul 23, 2005Hi,We are a systems research group at the Computer Science departmentatRutgers University, and are conducting a survey to understand detailsabout network, systems and database administration. We hope that thisinformation would help us recreate a realistic environment to helpresearch in 'systems management'.We request network, systems, and database administrators to take thissurvey. As an incentive, all surveys completed in their entirety willbeentered into a drawing of a number of $50 gift certificates (fromAmazon.com).We hope you have a few minutes to take the survey which is located at:http://vivo.cs.rutgers.edu/administration_survey.htmlResearch in our group:The goal of our research is to improve the overall availability andmaintainability of services. Since administrators form an integral partof these services, a key aspect of this work is to build environmentsand tools that ease the task of service administration. In particular,environments which would help administrators know how their actionsmight impact the real service (before performing them for real), webelieve would be useful in preventing inadvertent actions. This surveytries to understand the existing environments, what administrators docurrently to test the 'validity' of their actions, and the difficultiesthey face in doing so. The two specific systems we are looking at arenetworks and databases, as we believe these are important components ofmany services.If you have any questions regarding this survey or our work, feel freeto email us:Fabio Oliveira (fabiool at cs || rutgers || edu), orKiran Nagaraja (knagaraj at cs || rutgers || edu)Thanks for your time,Fabio OliveiraPhD student, Vivo Research Group (http://vivo.cs.rutgers.edu)Rutgers University
View 4 Replies View RelatedSQL Server Administration Tools
Jul 20, 2005I'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 RelatedAdministration Of Reporting Services
Jul 18, 2007Books online talk about a report manager page to monitor and administrator running job, subscriptions etc...
But I use Reporting Servcies in sharepoint administration mode? Where do I go to see something similiar?
Thanks
Sql Server Database Administration Web Application
Sep 10, 2006Hi All, I will shortly (hopefully) begin devleoping an ASP.Net web application to let users manage a remote sql server 2005 database (kind of like the php myAdmin tool for MySQL databases). Were not talking a server managament tool for DBAs, more an end user tool for managing personal databases (it seems that web hosting companies provide tools for MySQL, but if you use SQL Server, you're stuck unless you have management tools on your PC - and what about mac users?).Given that premise, what features should i attempt to include? Creating and modifying tables structures and data is an obvious inclusion, but what else? I also haven't yet decided whether to go about this using scripts or using SMO. I've read that SMO is backwards compatible across versions of SQL Server...how true is this? are there issues or is it seamless? Please post any comments or thoughts you have, and thanks for taking the time.
View 4 Replies View RelatedError Using Web Site Administration Tool
Mar 7, 2007I am getting the following error using the Web Site Administration
Tool. I have created the database I want to use. Please
help.Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to
create and configure the database, and then return to this tool to set
the provider.
The utility either is not working or I do not know how to use it.
I have SQL 2005 Express and SQL 2000. SQL 2000 is working
properly, not sure about SQL 2005. I have been told to use SQL
2000 because that is what our server is using. I am developing on
my server and when application works will port to our server.
Dee
Provider In Web Site Administration Tool
Jul 17, 2007Hello,I'm trying to create new users and roles using the Web Site Administration Tool, tab Provider, but I get the following error message: Could not establish a connection to the database.If you have not yet created the SQL Server database, exit the Web SiteAdministration tool, use the aspnet_regsql command-line utility to create andconfigure the database, and then return to this tool to set the provider.Then I ran aspnet_regsql utility using default values in every screen, but I got the following error message: Setup failed.Exception:Unable to connect to SQL Server database.----------------------------------------Details of failure----------------------------------------System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ...How can I solve this? Thanks
View 5 Replies View RelatedASP .NET Web Site Administration Tool Problem
Sep 13, 2007Hi,I have a problem when I use ASP .NET Web Application Administration tool. When I click the Security tab, I receive following message"There is a problem with your selected data store. This can be caused by an
invalid server name or credentials, or by insufficient permission. It can also
be caused by the role manager feature not being enabled. Click the button below
to be redirected to a page where you can choose a new data store. The following message may
help in diagnosing the problem: Unable to connect to SQL Server database."In the same page, there is a button to go to Provider section. I clicked it, and I went to the Provider page. There, there were two links, which were: "Select a single
provider for all site management data" and "Select a different provider for each feature
(advanced)". I clicked the earlier, and I was redirected to a page to select provider. There, there was a link, I clicked it and I receive following message:"
Provider
Management
Could
not establish a connection to the database. If you have not yet created the
SQL Server database, exit the Web Site Administration tool, use the
aspnet_regsql command-line utility to create and configure the database, and
then return to this tool to set the provider. "After reading this message, I opened Command Prompt and went to C:WINDOWSMicrosoft.NETFrameworkv2.0.50727. There, I ran the aspnet_regsql command, and then ASP .NET SQL Server Setup Wizard was displayed. In the first page of this wizard I chose "Configure SQL Server for application services" and then I clicked "Next" button. In the second page I left all fields as they were and then I clicke"Next". In the third page I only clicked "Next" and then some process ran. Finally, in the last page I received following message:"Setup failed.Exception:Unable to connect to SQL Server database.----------------------------------------Details of failure----------------------------------------System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) --- End of inner exception stack trace --- at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) at System.Web.Management.SqlServices.Install(String database, SqlFeatures features, String connectionString) at System.Web.Management.ConfirmPanel.Execute()"What should I do? I tried to use this administration tool on computer in my house and everything was just fine. Why do I have this problem in my office?
Free Administration Tool For SQL SERVER 6.5
Mar 30, 2004Hello,
I need an Administration tool for SQL SERVER 6.5 compatible with WINDOWS 2000.
When I try to search one with GOOGLE, I find none ...
If anyone can provide me with any solution, he (or she) will make me the most happy of the DBAs today ...
Thanks in advance
Al'