Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 confused on sql installs

Author  Topic 

gow75
Starting Member

2 Posts

Posted - 2010-05-05 : 12:12:47
I am really confused on all the different sql installs, what i mean is you have server, the sql agent sql express. what i understand is that sql server runs on a server the agent installs on a desktop like xp to access the DB on the server and the management studio accesses the db as admin tool from a administrators pc. correct me if i am wrong. i need some overview of all the different install components of sql.

RobertKaucher
Posting Yak Master

169 Posts

Posted - 2010-05-05 : 16:03:26
No, you've got the SQL Server Agent confused with the concept of a client. The SQL Server Agent is a Windows service, which is installed with SQL Server, no matter where you install it. I have SQL Server Developer edition on my laptop. If I set jobs to perform backups or some other task, these jobs are managed and run by the SQL Server Agent. http://msdn.microsoft.com/en-us/library/ms189237.aspx

Management Studio can be installed anywhere. And it is one way, probably the most common, that you might manage SQL Server. You may want to look at the SQL Server Wiki page. http://en.wikipedia.org/wiki/Microsoft_SQL_Server But the best description I have ever read of the architecture of SQL Server was in the book SQL Server 2008 Internals.

===
http://www.ElementalSQL.com/
Go to Top of Page

gow75
Starting Member

2 Posts

Posted - 2010-05-05 : 16:14:33
ok thanks for the tidbit, what is sql server express? also when you say that sql uses the agent for a service does that mean exactly, does it not access the server well than what is the server for, is that only for ODBC connections.
Go to Top of Page

RobertKaucher
Posting Yak Master

169 Posts

Posted - 2010-05-06 : 08:41:18
The wikipedia article should have information on the editions of SQL Server. You can find more information here: http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

A service is any program that runs in the background on a server or other computer and provides some sort of "service." If you install a web server, for example, the web server program will sit in the background and wait until there is a connection on TCP port 80. When it knows some one is trying to connect on that port it will serve the web page requested.

If I have configured a back up on my SQL Server, the SQL Server Agent service waits until the time I have set and then issues the required backup commands. And it would interact with the SQL Server service to accomplish this. Here are some other links you should read:
http://en.wikipedia.org/wiki/Client%E2%80%93server_model
http://en.wikipedia.org/wiki/Windows_service
http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

This PDF has some architectural information:
http://media.wiley.com/product_data/excerpt/40/04702570/0470257040.pdf

But from the sounds of things you really need to read an introductory book. What sort of IT related experience do you have so I can point you in the right direction?

===
http://www.ElementalSQL.com/
Go to Top of Page
   

- Advertisement -