Hello. I'm 15 years old only, but really interested in math and I'm curious what do You do in work (excepting having fun and chillin' ;))? I know a bit about MySQL and I'm now trying to write some simple queries in SQL Server Management Studio Express (I'm using MS SQL Server 2005), but I'm sure in Your work You use other programs? What should I look for and start with? I know this topic sucks and many/most of You use stuff that is worth xxxxxxx USD on specialized computers/servers but I had to ask, because I was trying soo hard with programming, and then I've found database management, and I'm excited, because it's very interesting. I have no idea why, but it's not even boring to me (yet), and maybe I will work in this business in future (I really, really hope that).
When I setup my listener: ListenerA...Do I need to use the instance name in it?
ListenerAInstance01 or ListenerAInstance02 depending on which SQLNode is the "active" availability group?
Am I better off to use the same instance name for both nodes, since my goal is to have all databases on both instances in the same availability group and sync'd? When SQLNode1 migrates over to SQLNode2 I will need to update the instance name in my connection string on the listener from ListenerAInstance01 to Instance02? When I connect with SSMS do I just use: ListenerAInstance01 (or 02)?
I 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.
We 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.
Does 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!
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.
I 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
Are 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.
Anybody 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..
Hi, 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
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.
Does 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.
Any 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.
Hi 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.
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
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?
Can 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!!!!
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
I 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.
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."
Countydown 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."
I have a SQL 2005 server and I am trying to run the SQL Agent service under a minimal permission account. Currently the service will run fine and perform all functions if it's account is a member of the administrators group on the local machine. As soon as I remove it from the local administrators group it fails to start and the only message recorded in the log for the agent is: [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) [098] SQLServerAgent terminated (normally)
And given the service works fine as an administrator I doubt there is anything wrong with the eventlog service. I have also checked and the eventlog service is indeed running, recording, and operating properly. I am at a loss as to what to do next, i've followed the directions available on MSDN for doing this but it still doesn't work.
I went to services in sql server 2000 and stoped that and i right clicked my mssql server and clicked on logon button and enter the username and password.So knw i want to access my database through that admin name and password .How to do that.
I need a report from reporting services that includes which reports(name of report not id) are run by who and when(with the ability to plug in the start and end date). The 2 database names are RSExecutionLog and ReportServer. I had a look at the admin type reports that come with the package but neither are appropriate.
Does anyone now the minimum permissions to debug SQLCLR. I have a friend trying to develop as a non-admin and he finds that it doesn't work even if he launches Visual Studio to run as an admin account.
Is it possible? Are there certain rights required?
I have one other question. How do you define roles? What role(s) are required to fully administer SQL Server? What role(s) are required to fully administer a single database in SQL Server?
