Help: MSCS Admin
Apr 28, 2001I am new to MS Cluster server. Could anyone tell me the correct procedure to shutdown and restart MS SQL Server 2000 in a Clustered environment? Thanks
View 1 Replies
ADVERTISEMENT
SP2 On MSCS
Jun 20, 2000Well, today's the day. I finally got approved to upgrade our 24x7 cluster to SQL Service Pack 2. I'm so looking forward to running Profiler without causing the server to failover, not to mention ArcserveIt and Spotlight an...
Anyway, Any feedback about the upgrade process is greatly appreciated. I've installed SP2 elsewhere without a hitch but I realize that I have to uncluster my production servers first and that there is no easy way back from SP2. I have full backups scheduled to run prior to the upgrade, any other ways to protect myself? Thanks in advance!!
Pete Karhatsu
SQL 7.0 On MSCS
Dec 21, 1999Have any one installed SQL Server 7.0 on MSCS in Active/Passive Mode? I need some guidance/Information relating to how to install.
Thanks in advance
Reddy
Dr Watson On Vsrvsvc.exe For MSCS
Aug 11, 2000Anyone experience Dr Watson's on MS Cluster Server? This is the second time that it's happened and I can't explian it.
The first time it happened it appeared to stop the virtual server service on my prod server, Cluster admin showed it as running.
This time it bounced the engine but nothing stopped.
Any clue is much appreciated, because I don't have one
I'm at SP5 on NT4 and SP2 on SQL 7 EE.
Pete
Failover Options- Any Besides MSCS?
Jul 16, 1999I need to know if there are any other failover options available for SQL Server/NT, beyond Microsoft Clustered Services. If there are any, which ones are advised?
Thanks,
Jon
jon_waldow@emeraldsolutions.com
Linked Servers On MSCS Fail
Dec 21, 1999Hi I am not having luck creating a linked server on SQL7 running HA on MSCS. We keep getting the "Error 6: Specified SQL server not found"
1. The Linked Server has an advanced entry in the Client Network Utility
2. Setting up the Link to a SQL 7 Server
3. Security is Mapped to a remote user which does exist on the Remote Server.
4. The two machines can ping each other.
5. On the Linking Server the linked Server can be registered as a registered server.
Any Ideas?
Can Linked Servers be set up on M$CS?
-Thanks in advance
-tom
MSCS SQL2000 Cluster 64 And 32 Bit Servers
Jul 23, 2005Is it possible to create Fail-over Cluster with 64-bit (Itanium2) and 32-bit (Intel Xeon) nodes?
View 2 Replies View RelatedPolyserve Versus MSCS (Microsoft Cluster Server)
Apr 30, 2007Hello All,
I would like to compare the MSCS with Polyserve's solution and thus wondering if anyone has an experience using both or knows -
What are the major differences between the two?
What are the limitations?
What are the advantages and disadvantages?
Which is advisable to use as a HA solution?
Any other information which may help me to make this decision would be appreciated.
Thanks in advance for your help!
~Managar
SQL Server Admin 2014 :: Does Security-admin Role Plus Deny Alter Any Login Cancel Each Other Out
Aug 27, 2015I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.
I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.
I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).
So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.
MSDTC In Active/Active MSCS Cluster
Jun 29, 2004How do I install MSDTC in an active/active MSCS cluster environment?
If I run comclust.exe, I can only activate MSDTC on one of the nodes at a time.
I need DTC on both nodes.
(Opsys is W2K with SQL 2000)
//Mange :)
Admin Access To SQL Without Server/domain Admin Access
Sep 6, 2007We are using Win2k3 R2 with SQL 2000 in a domain environment.
Is it possible to create a domain group to grant admin level and user level access to SQL2000/2005 without giving users server admin or domain admin access?
It has always been my impression that to have admin access to SQL that you had to at least had admin level access on the server.
Any clarification would be greatly appreciated.
Thanks!
Web Based Admin
Jun 25, 2006Does anyone know of a web based front end to Microsoft SQL Server 2005 Express edition? I tried using the SQL Server 2000 server web admin tool from microsoft, but it will not allow me to install it because it says it need the 1.1... framework installed. I have 1.0,1.1,and 2.0 installed, is there anyway to circumvent this? Or has anyone else figured another way to get the webadmin tool to work with 2005 express edition.
Thanks!
SQL Web Admin Tool
Mar 4, 2004Hi,
I've been having trouble getting this tool to work with my server/database. I'm using XP Pro, MSDE, .NET 1.1.4322 and IIS 5.1. IIS has been installed and tested with the help of others. .asp pages are being served locally and to another PC on the network. No obvious problem here. When I installed MSDE I used the SAPWD='strongpassword" command to create a password. I also built a new database. I had positive feedback on both of these actions.
Now to the tool - when I activate the administrator it pops with the little window saying Web Server Configuration. It lists the following options:
Desired Port:
IIS
Cassini Personal Web Server
Restore Faults
and Start and Stop buttons.
If I leave the setting on IIS and click Start it opens a webpage entitled Web Data Administrator. Moving further down I have a welcome message and then the line -
Please enter a SQL Server name:
Username: [Desktopob shadowed entry]
Password
Server (local)
Authentication Method:
Windows Intergrated
SQl Login
and then a Login button
If I select SQL Login and enter "sa" as the username and then my password leaving (local) as the server I get the following error:
Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.
I have tried all combination of \desktopsa, sa, you name it. The password I selected is correct because I made a point of writing it down so I wouldn't forget it. I have also tried all the combos using Cassini as well.
This is where I'm stuck at this point. All suggestions are appreciated.
Thanks,
Bob
Web Based Admin MS SQL
Dec 1, 2005Is there a web based admin to administer MS SQL? If there is a free one, that would be better.
View 2 Replies View RelatedRemote Admin
Nov 2, 2001Are there any tools for administering SQL2000 remotely over the TCP/IP? And if this is possible what are the main hurdles on setting it up. Emulation is an option.
View 2 Replies View RelatedCluster Admin. And SQL
May 3, 2000Anybody know if you can manage the Cluster Administrator tool from a remote workstation? I've found nothing(except PcAnywhere and the like) documented on this..
Thanks
Pete
SQL Admin Wages
May 4, 2000Hi,
I am fairly new to SQL server admin.
What sort of wages are paid for this type of work.
Is there a shortage skilled administators in this area?
Does the MSCE DBA increase your wages?
Thanks
Admin Tools
Jul 5, 2000Hi Guys
I have just been trying to install the Admin tools from the SQL 6.5 setup CD on a Win NT Workstation 4 SP6 system. Everything seems to go fine until the icons are addded into the program group, these come up as system default icons and don't link to any programs. If I go into the installed directory and execute the programs then I get the following message:
The SQLOLE OLE object could not be registered. Class not registered (80040154)
After clicking OK the program terminates. I have tried diferent install directories, even diferent partitions. I have also deleted the directory and removed the Registry entries manual - this is because it cannot be uninstalled.
Still no luck.
Any ideas?
Many thanks
Stuza
SQL 7 Admin Exam
Jan 4, 2000Does anyone know of a good book that will prepare you for this exam. I know that in some early discussions that Mike Hoetch warned against some of the new books on the market.
Thanks
Ricky Kelley
Domain Admin And Sa
Dec 13, 1999A couple of newbie questions:
1) Do Domain Admins have SA rights by default in SQL7? If so, is there a way to keep domain admins out of particular databases.
2) Is it possible to create a database or table that even SA can't get into?
Thanks
JD
SQL 7.0 Admin Tests
May 19, 1999Has anyone who has taken and passed the SQL 7.0 test for SQL Admin
have any recommendations on the best sources to help pass?
A SQL 7.0 Admin Book?
Jun 5, 1999Any recommendations on a good SQL 7.0 Systems Admin book for future DBAs? Too many books at the store, so i'm wondering how i can narrow it down. I'm looking more for the Admin side rather than developer side type book. Thanks.
View 2 Replies View RelatedDBA Admin Plan
Jan 11, 2000Hi there,
Could anyone please help me, I have been given the responsibility of planning and implementing the admnistration of 25 existing SQL Servers (6.5 and 7.0) countrywide and I am unsure as to where I should start. I am relatively new to SQL Server and if someone could just point me in the right direction or possibly recommend any good publications which I could refer to, I would be extremely grateful.
Ms Sql Admin .....exam..help
Mar 1, 2001Hi
Here is a mcdba admin question
Consider the following time line:
8:00 You accomplish the full database backup.
8:10 User1 enters the order 53 for customer 10, whose name in the database is
XXXXX (I
can't remember, but not Bill Smith)
8:12 User2 at remote server changes the name XXXXX to YYYYY
8:13 User3 changes the name YYYYY to ZZZZZ
8:14 User3 commit the transaction.
8:20 Media fails for database.
8:30 You restore the database from 8:00 backup. What is the status of the order
53 in the
database?
a) The order 53 is not in the database.
b) The order 53 is in the database and name is XXXXX.
c) The order 53 is in the database and name is YYYYY.
d) The order 53 is in the database and name is ZZZZZ.
Ans: B The name was already there.
The answer is B but I think th answer is A
becouse He or Her restroe the database from 8:00
I think the 53 order maked after 8:00 so
there is not order 53 in the backup database
How about you think and why !!!
Thanks kjs
Database Admin
Dec 30, 1999long, bad story here is the brief:
sql: 6.0 w/ fixes
platform: intel NT 4 sp3+
our "dba", i use that term loosly as the person who filled that position had little expertiese in managing sql, found a new job and has left; i worked with him on periphery matters so i'm less effective than he. unfortunatly ..."he with the most experience..." becomes "the man" so now i'm working to become a good dba and require some assistance.
we had a contractor come in and work out a method for archiving data using bcp, some batch files, and sql scripts; prior to this he assisted us in porting from one platform to another, digital alpha running NT to intel platform running NT.
in brief the procedure is as follows:
using options of EM create scripts to create all objects except indexes, again use EM to create sql scripts to create all objectes including indexes.
obtain sizing information and create a device and database, including log etc.
use the create objects script to create objects in the newly created database
use a custom script to create a batch file to bcp data from the primary database into flat files.
use a custom script/batch file to create a batch file to bcp data into the newly created database.
use the create indexes sql script to re-create indexes. we have to modify the sql create all objects including indexes script. i've worked up a batch file using for /f and if == to do this.
do some row counts and spot checks of tables stored procedures to verify conversion.
so now my questions:
using the information supplied causes problems, the tables end up being created but are owned by the wrong user. is there a way to change table, stored procedure, or object ownership? i create the database and objects as sa, then populate with bcp and re-create the indexes as the desired owner. my understanding is that sa has the special permissions needed to create objectes and the create objects script should make the appropriate users, logins, and changes to the db objects... where am i going wrong?
Admin Task
Apr 7, 2004Can anyone tell me whether there is any way to automatically genereate SQL script for all SQL jobs on a server?
I need to create the script for about 30 jobs and dont want to spend hours getting RSI clicking on each one and exporting the script if i can avoid it!!!!
TIA
Sql Admin Training
Feb 23, 2006has anyone tried the cd/learning from sql usa
http://www.sqlusa.com/order2005/.
Interested in any input
Sql Admin Via The Internet
Mar 29, 1999Hello,
I will soon be managing a sqlserver/iis4.0/nt box located remotely in another state. It has a permanen connection to the net. I have a dialup connection.
I have a remote control package, but it is slow. Is there a way to add that boxes sql server to my enterprise manager on my local nt server so that I can
adminsiter it from my machine? I am not over familair with sql server, but quickly learning!
Will I need to set up a vpn to do that?
I searched microsoft knowledge base, but could not find anything.
Thanks for your support.
Johanna
SQL 2000 Admin
Aug 29, 2001I am trying to find some resources for SQL 2000 admin. I have a book and will be taking a class, but am still looking for a forum and a bit of Technical expertise to discuss issues with.
Thanks
Dbforums Admin??!!
Jan 9, 2006Hi
Does any one know what the email contact is the dbforums admin? I can't seem to locate it, neither an online mailer?
Thanks
HELP, No Admin Panel!!!!
Mar 12, 2007Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.
I need to change the number of characters permitted in a certain field.
I have to present this tomorrow morning so any help would be greatly appreciated.
My friend flew to Italy last night and I cant contact him hence the question."
Admin Book
Mar 14, 2007What is the best book for SQL Server 2005 administration? For sql programming I assume the best book is professional sql server 2005 by Rob Viera.
I was not able to find a similar book for Administration. Any suggestions?
------------------------
I think, therefore I am - Rene Descartes
No Admin Panel
Mar 19, 2007Countydown writes "Hi my friend designed an SQL database for me on my server, I dont know how he did it but there appears to be no admin panel only an SQL agent. I have no experience with this and am sinking quickly.
I need to change the number of characters permitted in a certain field.
I have to present this tomorrow morning so any help would be greatly appreciated.
My friend flew to Italy last night and I cant contact him hence the question."