In SQL Server 2005 to administer all aspects of SQL is there any way a non local administrator can do this? We are trying to remove the DBAs from being local administrators over the SQL server machines in SQL 2005, we were able to do this in SQL 2000 but SQL 2005 is not working correctly.
We want to make the DBAs a member of local power users and assign the specific rights for it. Can this be done, if so how? is there a document I can reference somewhere.
Hello,
I do have the following question:
SQLServer 2000 Push Replication
What SPs are responsible if clicking right on the Repl. Topic and clicking "start syncronization"?
Reason: I will give Administrators (no dbo) the possibility to start the sync again if failed (e.g too many timeouts) over a Frontend.
Thanks in advance
Peter
I am new to the internet field. Can anybody help me in administering the SQL database on the site. Are there any tools so that I can administer the database on the site straight from my PC??? If there, please tell the URLs so that I can refer them. And please tell me other issues which are involved in administering the database on site.
How can I maintain a parellel SQL server database on my PC?? How can I take backup from my site to the SQL database which is placed in my PC?? I want to keep backup of my database in my PC.
Please help me in these issues.
Venkat Reddy
gv.reddy@usa.net
Hi
I have heard a lot of people saying that they administe the SQL Server remotely , I mean sitting in one city , they work on the SQL Server in another city.
How is this actually achieved . Is it that the SQL Box is given a real Ip & then they connect it though the internet, but then this would not be safe , as the SQL box would be on the real Ip.
Could some one please let me knw the ways (solutions) to access & adminster a SQL Server remotely. (Not on ones LAN ) ...
Thanks & Regards
Kid
Hello,
I have been working as a SQL Server 2000/2005 db administrator (small-medium dbs), in the near future I am going to work as a DBA for large DB on SQL Server 2005 (200 - 300 GB and over) but I have not experences.
Do you have any suggestions, Recommendations or useful docs, books or web links and everything else to suggest me on how to administer large databases.
Thank a lot
Node 1 -IP Address 10.xx.xxx.11
Node 2 -IP Address 10.xx.xxx.12
while create cluster wizard in access Point for administering the cluster which IP address need to type Address filed? Does it Node1 IP to be type?
1. I have type Node 1 -IP Address 10.xx.xxx.11 in that filed but I Received error as below
You do not have permissions to create a computer object in the Active Directory
2. What type of permission is required that particular domain id which was logged both the nodes?