Programming Babe In A System Administrator's Woods!
Nov 11, 1999
I posted this topic and got not response, but I'm pretty desperate so I'll try one more time.
I'm a programmer at a small company but for the past year I've also been relagated to SysAdmin (fun, fun, fun). We less than 25 users (usually no more than 10-15 at one time). We run NT server on a P133, 64MB RAM, 3.5MB & 2.5MB SCUSI hard drives. We run SQL Server on dual P133's, 98MB RAM, 4MB & 2MB SCUSI hard drives. Our systems are pretty junky, they were bought at Microcenter a couple of years ago and some other machines we had bought about the same time have begun dying left and right. Our Server is very slow and we're afraid it's going to poop out on us soon.
I've been put in charge of taking care of this. "Get us a new server, and don't spend too much money." Being a programmer, not and administrator, I have a few questions:
1. Can I buy 1 good server to replace these two? That would mean running our NT File Server and our SQL Server (on NT of course) on the same box. Is that bad or can I do that? The only thing the NT Server is used for is file sharing (mostly images). No applications, no exchange (although maybe in the future), no internet. 2. If yes, should I go with a really fast desktop with a few ATA/66 drives, a smoking chip, tons of memory. Or, should I get a true server with SCUSI drives, ECC memory, RAID capable and all that. Essentially is it better to get a smoking desktop or a lower end/entry level server?
3. I don't quite understand RAID, do I need it? If so, what is it? We need to backup or data somehow.
4. Anything else you think I'll need? Or, could some list some minimum specs?
5. How much should this cost me?
Our main concern is the SQL Server running fast enough. We have a custom Accounting/Order/Inventory system (Access97-front/SQL-Back end ). The database is about 200MB and growing and the largest table has about 100,000 records and we anticipate about 20,000 records a year in that table. We also store tons of images (art company) on our file server and we would like to link our SQL inventory records to those image files.
I'm really kind of in over my head with the administration but the pressure is on. They want me to do this instead of outsourcing and they want to keep in the <=$3500 range (Server & Backup System). Any help or advice of any kind would be greatly appreciated.
Thanks.
View 1 Replies
ADVERTISEMENT
Aug 16, 2006
Hi all
I deleted the sa account
how do I add it with all the correct permissions (plus include it in all the tables )
TIA
Guy
View 1 Replies
View Related
Jan 25, 2007
In SQL 2000, how do I grant system administrator privilege to "sa" or a Windows User?
View 3 Replies
View Related
Feb 13, 2007
Hello all,
does someone know where to find information regarding what is accesible to a BUILTINAdministrator which is not accesible to a System Administrator?
Somewhere I have read that a System Administrator can not see the "All users' folders (i.e. the collection of "My folder"s for all users of the Report Server) but I have also experienced a behaviour which has surprised me: as a System Administrator with all permissions I cann't even see folders that a BUILTINAdministrator can.
Does it mean that a System Administrator can not really manage all the resources of a Report Server?
Any ideas will be welcomed. Many thanks.
View 1 Replies
View Related
Jan 30, 2007
Hi guys,
I am new to this forum and new to SQL.
I have a stored procedure which sets the value of a variable (@owner_logon_name, type sysname) to sa. It then calls sp_add_job in the msdb database, which in turn calls numerous other stored procedures. The ASP page I post down to the server is coming back with an internal server error and the log file shows the following message:
"Only a system administrator can reassign ownership of a job."
Even though the login name was set to sa, it seems to be using another role.
The code I have in my sp is:
exec @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID output ,
@job_name = @JobName,
@owner_login_name = sa,
@description etc, etc
Can anyone think why it would do this? An explanation of how sp_add_job works would also be much apprciated.
View 1 Replies
View Related
Nov 16, 2007
We recently downloaded and installed SQL Express as it was a required program for our new database management software. When trying to install my database management software I was asked to Login to the SQL server. I entered the SQLEXPRESS server, however, I do not have the SA password. When SQL Express installed it did not ask for a password only for a user name and company. I am running Windows Small Business Server with the Administrator and no password. We did not assign a password to the Administrator account yet.
I have tried to leave the password blank using the login SA and I get error message 28000 Login failed for user. The user is not associated with a trusted SQL Server Connection.
Is there a default password for SA? Or in the alternative, how do I create a user or associate an exising Windows user with a trusted SQL server connection?
View 3 Replies
View Related
Jun 3, 2015
I am using windows 8 and I have only one user in laptop. While installing SQL 2014, I am getting an error (Missing System Administrator). Under SQL Server Agent and SQL Server Database I have select the system user and gave the password but still I am getting the error.
View 8 Replies
View Related
Aug 7, 2015
I have inherited a sql server and no one knows the SA password. I cannot login with windows authentication even if the account is administrator of the machine.
View 4 Replies
View Related
Jul 20, 2004
Hi,
Can any of you tell me how to create a login in SQL Server 6.5 with System Administrator privileges, like we can do with SQL 7 or SQL 2000 ? I don't want to use the sa login.
Thanks
View 1 Replies
View Related
Dec 26, 2007
I represent a software development house and we have developed a client server system based on SQL Server. Most of our customers have already purchased Enterprise License of SQL Server, therefore they own the SA Login and Password. We are bound to attach our Database with their Server on their machine.
My question is how can we stop a System Administrator of SQL Server to view our Database Structure, Queries, Data installed on their SQL Server on their machine.
Our database structure is a trade secret and we cant reveal the structure to the client.
please answer this question by email to me at farhandotcom@gmail.com
Thanks & Regards
Farhan
View 1 Replies
View Related
Jul 16, 2002
We are trying to set up SQLAgent Proxy account. If the SQLServer service id is a domain admin, do we still have to add it to the local administrators group?
Jeff
View 1 Replies
View Related
Nov 22, 2005
Please help! I am new in SQL Server 2000 Administration. My manager had ask me to manage a SQL Server, but Windows Adminstrator refuse to give me Local Admin rights. I only have sa account to login to databases. I don't know any excuses or reasons to give to Windows Adminstrator so that he can give me the local admin rights. If any one have this answer, please help. Thank you.
-JC
View 4 Replies
View Related
Aug 21, 2006
I have created a windows library control that accesses a local sql database
I tried the following strings for connecting
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"
I am not running the webpage in a virtual directory but in
C:Inetpubwwwrootusercontrol
and I have a simple index.html that tries to read from an sql db but throws
the error
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
etc etc
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Trusted
I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security
I think that a windows form connecting to a sql database running in a webpage should be simple
to configure what am I missing?
View 28 Replies
View Related
Mar 29, 2005
What I want to do is remove part of a result from a query. I am selecting the srvname from sysservers as follows.
SELECT srvname from sysservers
Where srvid ='0'
When the name is returned some times it might be like servernameinstance. What I need to do is cut off the and everything after that so that my result is just servername. I am then using this result in a cursor to go after server shares. The length of the servername varies. Any suggestions.
View 1 Replies
View Related
Mar 3, 2004
Hello:
I'm scheduling DTS packages to run as a job but when I do that, the job siply does not works, someone tolds me that it's a problem with the SQL and Windows NT authentication and security and he gaves me this URL http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074.
but it not so clear to me, i'm working with SQL Server 200 and Windows Server 2000.
What can I do?
View 5 Replies
View Related
Apr 2, 2008
I dont know how to write a SQL Programming code from the table to the table (As the photo)
Would it be possable to help me?
Thanks so much!
View 10 Replies
View Related
Aug 17, 2007
Hi,
Currently I am using the BCP functionality to import/export tables between different SQL Server 2005 databases. The process is working ok, but it creates alot of manual work, when 70 or more tables need to be transferred, every week. I am new to RMO development and am interested if the following may be possible.
- I would like to build an interface in VB.net allowing users to select a source database, and select the tables that need to be transferred from the Source DB, to the Destination DB.
-Put in place RMO funtionality to replicate the source database tables into flat files.
-Within the Vb.net app transfer the created flat files into the destination database.
I would greatly appreciate any advice on this, or if there may be a better approach at replacing the BCP functionality.
Thanks,
View 4 Replies
View Related
Jul 24, 2007
Hi,
Need help from experts on web service (ReportingService class).
I am trying to change a datasourcereference of a report from one location to another location. I am kind of stuck at this point where i am able to get the location but only dataSource.Item, dataSource.Name are not enough items for me to solve this problem.
any possible help or any threads already answered these type, greatly appreciated.
thanks
kodru.
View 1 Replies
View Related
May 6, 2007
Hi!I want some tutorials on how to actually program database applications. Everything seems so bound with the data controls provided by Visual Studio and coming from PHP I don't like to not have full control over my applications. So where can I learn about creating my own database applications without using repeater, gridview or formview?Thank you in advance!
View 1 Replies
View Related
Mar 30, 2004
I need to create a database with one table and its column names.
I got this script from the query analyzer templates as a database basic template:
IF EXISTS (SELECT *
FROM master..sysdatabases
WHERE name = N'<database_name, sysname, test_db>')
DROP DATABASE <database_name, sysname, test_db>
GO
CREATE DATABASE <database_name, sysname, test_db>
GO
I am not sure what it all means, what I need to do it name the database a certain name each time. and then create one table with 6 column names.
can someone give me guidance please...
View 7 Replies
View Related
Aug 3, 2000
I have a table containing almost 700000 records. The table contains the following fields:
table_id, member#, car_eff_dt, car_term_dt, mbr_occur.
A member can occur more than one time and his effective date/termination date are sorted sequentially.
An example would look like this:
table_id member# car_eff_dt car_term_dt mbr_occur
1 12345678901 01/01/1995 12/31/1995 null
2 12345678901 01/01/1996 12/31/1996 null
3 12345678901 01/01/1997 12/31/1997 null
4 10987654321 07/15/1998 02/16/1999 null
5 10987654321 04/01/2000 12/31/9999 null
Using Transact-SQL, is it possible to generate a unique number for each occurance of a particular member#?
table_id member# car_eff_dt car_term_dt mbr_occur
1 12345678901 01/01/1995 12/31/1995 1
2 12345678901 01/01/1996 12/31/1996 2
3 12345678901 01/01/1997 12/31/1997 3
4 10987654321 07/15/1998 02/16/1999 1
5 10987654321 04/01/2000 12/31/9999 2
Currently, I am running the code in an Access/VBA module through an ODBC connection, but I would like to be able to run all my code directly on the server.
Thanks in advance for any help you might be able to provide.
View 1 Replies
View Related
Dec 16, 1999
Just curious,
What do all of you use to create and edit stored procedures? I am looking for a better way to code than to use the default window supplied with Enterprise Manager.
Do most of you use the Query Analyzer? Are there third party products you like using better?
Thanks for the info..
Eugene
View 2 Replies
View Related
Dec 9, 2004
I am looking into a production geared software called MassGroup. (www.massgroup.com) It says that its FactoryServer builds are on a standardized SQL framework and web architecture for data collection, work order requests, reporting and asset management. My questions are:
1. Is SQL its own programming language? If not what is it?
Answer: After going thru several pages and reading the fine print I discovered they use VB, ASP, COM technology, and Crystal Reports.
2. How powerful do you think this would be at gathering data and does it have the capability of creating a number sequence automatically? (example: 0001; 0002; 0003...)
Any help would be appreciated.
Thank you in advance!!!!!
View 1 Replies
View Related
Nov 22, 2004
hi to all,
What is the best language or compiler used in web database programming. Any have an idea pls help me.
Thankss.
View 2 Replies
View Related
Mar 3, 2008
I have just started in Sql 6 months ago. I was an IT major in graduate school and am now in my late 30's (career change). It took me 4 years to finally get what I thought was my dream job. Well, I was promised training which I have yet to receive and bascially went from doing basic queries that I did in class in college to doing advance Sql - stored procs, etc. I completely hate it. I do not know if it is from the lack of training or if it just not for me. I am completely bored out of mind. I am also tired of struggling everyday to complete assignments. The first 2 assignments I received were way out of my league. I was told this by a project mgr who did a similiar assignment and they have years of sql experience and it took her 3 months with assistance to complete it. I have been with the company for almost 6 years. I am not sure if I should just complete my current assignments and ask if they can reassign me to a different IT department, look for a new job or just continue to struggle and pull my hair out. Please give me some feedback as to how you would handle this situation.
View 8 Replies
View Related
Mar 25, 2008
Guys ..Im a very very confused Jr DBA/Dev here !
I need to know what exactly other languages [C#/VB.net/ADO/XML/ASP.net..etc] that I should learn in order for me to be able to excel in SQL Development.
I started getting my hands dirty with some SSIS / SSRS & SSAS, but inorder for me to handle situations such as [Find if file exist in ftp before loading, Checking a certain row of a data file before processing/ Zipping and Unzipping data files and etc...] What should I need to know well in order for me to add more value to my skills?
I would like to learn 1 language and master it pretty well.What are your suggestions?
And what is this CLR that is being talked about ?Does it use other language besides SQL?
Do guide this lost JR .......
View 10 Replies
View Related
Dec 25, 2005
Are there any good resources (books, websites, etc) for programming SQLServer using Visual C++? I am currently using C# but I really want to learnhow to do it using C++, but it appears to be much more difficult using C++.Thanks
View 2 Replies
View Related
May 15, 2007
i need to access an .sdf database using microsfot visual forpro
what drivers/connection strings do i need?
View 1 Replies
View Related
Apr 21, 2006
I currently have a table with the fields:
- StudentID as an Identity and is the Primary Key field (PK)
- FName as varchar(15)
- LName as varchar(20)
When I use a combo box, I place the information in it as follows:
- LName, FName/StudentID Ex: Rogers, James/4
In order to find our the student I want, I parse the above field for the StudentID.
Question:
How can I display the student's name only and still get to their StudentID?
Would I have to use an array holding/pointing to the StudentID? Or What?
Thanks In Advance.
View 3 Replies
View Related
Jun 6, 2007
Hi all,
I know how to basically change SSIS variables from within a C#. NET winform application. But can anyone point me on how to change the contents of a connection manager SSIS connection from withing C#.net please. That is..how do i parameterize a connection manager connection to basically accept the connection information from within the winform app.
Thanks
View 9 Replies
View Related
Nov 15, 2006
Hey, i have an installer that places ms sql express onto a machine. thats is fine. i want to create a post setup application that runs after ms sql server is installed. what for example i want to do is be able to create a user and have the DB allow remote connections. i can provide instructions for a 'peon' to make the required post setup changes but i want to see if i can cover that with an application. thanks
Charles Rezsonya
View 10 Replies
View Related
Dec 5, 2006
Hi..
I am working on sql server integration services..New to this topic...I want to transfer data from flat file to sql database by doing it programatically.Creating source,destination and transform adapters
my basic question is should the source,transform and destination adapter be bulid for each file i am trying to transfer.
What is the advantage of this doing it this way.
Would anyone let me know about this..
Thanks
View 1 Replies
View Related
Jun 21, 2007
Not sure if this is right place to ask this. I have a table where I want a single field to show up in separate columns. (wow its hard to describe what I want. Here is an example
Store_Group_Product_Tbl
store, group id, product
Let's say we have these records:
Store 1 - group 1 - hats
Store 1 - group 1 - clothes
Store 1 - group 1 - shoes
Store 1 - group 2 - drink
Store 1 - group 2 - food
I want my select statement to return:
Store 1 - group 1 - hats - clothes - shoes
Store 1 - group 2 - drink - food - NULL
(and in this case I will be selecting on where store = a selected store)
Is there a way to join it back to itself to get the data I want? Or will I have to select everything into an array and then manipulate that array to get everything columned up correctly?
View 4 Replies
View Related