How do I know when a patch is available for SQL Server?

I installed Service Pack a3. It seems that Windows Automatic Updates is not
able to catch any patch(not sp) for SQL Server. Is there anyway that I can
make the patching automatic(at least notify me when a patch for SQL Server is
available)?
Thanks in advance!
Bo Sun
I am sure that you don't want the SP auto patched you SQL server!
Sign up with http://www.microsoft.com/security/default.mspx for email
update.
"Bo Sun" <Bo Sun@.discussions.microsoft.com> wrote in message
news:234E0FB7-91CC-4103-9BEF-6F9D067BB44E@.microsoft.com...
>I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server
> is
> available)?
> Thanks in advance!
> Bo Sun
|||> I installed Service Pack a3. It seems that Windows Automatic Updates is
not
> able to catch any patch(not sp) for SQL Server.
This is because most post-SP3a updates are hotfixes for specific
bugs/problems, not security patches (and are not relevant for all users).
You can stay pretty much on top of new hotfixes here:
http://www.aspfaq.com/2160 ...
Remember, also, that windows update is for windows, not SQL Server. I
believe they are planning similar functionality for SQL Server 2005, but
don't hold me to that.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Hi
Patching SQL Server is currently not possible with Windows Update. This may
change in the future.
Regards
Mike
"Bo Sun" wrote:

> I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server is
> available)?
> Thanks in advance!
> Bo Sun

How do I know when a patch is available for SQL Server?

I installed Service Pack a3. It seems that Windows Automatic Updates is not
able to catch any patch(not sp) for SQL Server. Is there anyway that I can
make the patching automatic(at least notify me when a patch for SQL Server is
available)?
Thanks in advance!
Bo SunI am sure that you don't want the SP auto patched you SQL server!
Sign up with http://www.microsoft.com/security/default.mspx for email
update.
"Bo Sun" <Bo Sun@.discussions.microsoft.com> wrote in message
news:234E0FB7-91CC-4103-9BEF-6F9D067BB44E@.microsoft.com...
>I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server
> is
> available)?
> Thanks in advance!
> Bo Sun|||> I installed Service Pack a3. It seems that Windows Automatic Updates is
not
> able to catch any patch(not sp) for SQL Server.
This is because most post-SP3a updates are hotfixes for specific
bugs/problems, not security patches (and are not relevant for all users).
You can stay pretty much on top of new hotfixes here:
http://www.aspfaq.com/2160 ...
Remember, also, that windows update is for windows, not SQL Server. I
believe they are planning similar functionality for SQL Server 2005, but
don't hold me to that.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Hi
Patching SQL Server is currently not possible with Windows Update. This may
change in the future.
Regards
Mike
"Bo Sun" wrote:
> I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server is
> available)?
> Thanks in advance!
> Bo Sun

How do i give SQL administrator full rights to SQL 2005 without OS rights

The DBA at our location is demanding local admin (windows) right's to the box so he can function. Right now when he logs in i have given him right's to the inetpub directory, sql directory, i have set him as a sysadmin on sql2005 and gone into the http:\\localhost\reports and set him up as a system manager and under site priveledges set him as a sys admin. When he tries to login and configure the report server he gets the following error:

Title-Reporting services configuration manager

Error-There was an error refreshing the UI. bla bla bla

A WMI error has occurred and no additional error information is availiable

Title-Reporting services configuration manager

Error-There was an error while switching panels. The most likely cause is an error retrieving WMI properties. bla bla bla

A WMI error has occurred and no additional error information is availiable

then when he's in sql server 2005 surface area configuation

Title-Surface Area Configuration

Error-Access denied (system.management)

Is there any documentation or anythign anyone can tell me that i can do to give this DBA full access to configure and admin the SQL portion of his system without giving him admin rights to the OS?

Please help!!

Thanks for any time anyone has taken to review this thread!!

There's no issue in giving him/her admin rights to the box. In most cases, he'll/she'll need it. Don't confuse local admin on the box with network admin rights.

Adamus

|||

That's the problem in my environment i cant give local admin rights to any box. This is per PCI requirements which is a credit card VISA format amongst other regulations i'm under.

Do you have any other info that can provide assistance?

|||I

The DBA at our location is demanding local admin (windows) right's to the box so he can function. Right now when he logs in i have given him right's to the inetpub directory, sql directory, i have set him as a sysadmin on sql2005 and gone into the http:\\localhost\reports and set him up as a system manager and under site priveledges set him as a sys admin. When he tries to login and configure the report server he gets the following error:

Title-Reporting services configuration manager

Error-There was an error refreshing the UI. bla bla bla

A WMI error has occurred and no additional error information is availiable

Title-Reporting services configuration manager

Error-There was an error while switching panels. The most likely cause is an error retrieving WMI properties. bla bla bla

A WMI error has occurred and no additional error information is availiable

then when he's in sql server 2005 surface area configuation

Title-Surface Area Configuration

Error-Access denied (system.management)

Is there any documentation or anythign anyone can tell me that i can do to give this DBA full access to configure and admin the SQL portion of his system without giving him admin rights to the OS?

|||Moving to the SQL Server Security Forum.|||

ok i think i figured out the surface area config issue, theres a link that states : Add new administrator in which i did and i can access all pages now, but it wont obviously let a non admin restart services, since there's a handful of services i think i'll just have/set the services under the SQL admins credentials, unless someone knows of a better way, in which i can allow the sql admin to restart services?

On the other issue i still cant access the reporting service configuration page, still recieving a WMI error?//

Please anyone HELP!!

|||

These sources should help you understand and configure the appropriate account/security for your DBA.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557

|||

Ok i was looking over the attached documents. It pretty much looks from what you've given me, if i setup the services on the local machine to run under the SQL DBA's credentials that i wont need to do anything further, this will in turn give the SQL DBA access without any errors?

Personally i dont think the service items are the issues but if you're positive this will do what i dneed to do i'll try it. Please reconfirm my understanding of the situation before i attempt to run changes please.

Again thanks for your assistance.

How do I get a user's domain?

I need to provide a UI to get the information to add a windows login to a SqlServer database. The CREATE LOGIN Sql statment requires the user name as "DomainName\UserName". I can get a list of users in XML using the following code:

public static XmlDocument GetAllADDomainUsers(string DomainPath)
{
string domain;
XmlDocument doc = new XmlDocument();
doc.LoadXml("<users/>");
XmlElement elem;

DirectoryEntry searchRoot;

ArrayList allUsers = new ArrayList();

if (DomainPath.Length == 0)
{
DirectoryEntry entryRoot = new DirectoryEntry("LDAP://RootDSE");
domain = entryRoot.Properties["defaultNamingContext"][0].ToString();
}
else
domain = DomainPath;

searchRoot = new DirectoryEntry("LDAP://" + domain);

DirectorySearcher search = new DirectorySearcher(searchRoot);
search.Filter = "(&(objectClass=user)(objectCategory=person))";
search.PropertiesToLoad.Add("samaccountname");
search.PropertiesToLoad.Add("distinguishedname");
search.Sort.PropertyName = "samaccountname";
search.Sort.Direction = SortDirection.Ascending;

SearchResult result;
SearchResultCollection resultCol = search.FindAll();
if (resultCol != null)
{
for(int counter=0; counter < resultCol.Count; counter++)
{
result = resultCol[counter];
if (result.Properties.Contains("samaccountname"))
{
elem = doc.CreateElement("user");
doc.DocumentElement.AppendChild(elem);
elem.SetAttribute("name", (String)result.Properties["samaccountname"][0]);
elem.SetAttribute("distinguishedName", (String)result.Properties["distinguishedname"][0]);
}
}
}
return doc;
}

This works for listing the names but how do I get the NetBIOS domain name for a selected user as required by SqlServer? I have tried using TranslateName from secur32.dll. That works on some machines but for some reason on other machines, it returns a blank. Is there another way?

Thanks for your help,
Rob

Is this the right one you are looking for? Try System.Environment.UserDomainName .|||

System.Environment.UserDomainName gets the domain of the current user. However, I need to be able to get the domain of a user that could come from any of multiple domains instead of the current user and I also need to support version 1.1 of .Net Framwork which makes it more difficult...unless I'm missing something.

Any ideas?

Thanks,
Rob

How do i discover SQL server is running ...

Hello ,
I'm trying to create an application, which would say if sql server is
running on a machine.
Hope i can get this from windows registry. Is there any other way do
achieve this programatically through windows SDK , or checking the
services programatically ?
If i need to check the registry what are the fields that i should look
at ?
thanks in advance,
VeluChecking the registry would only tell you that SQL Server has been
installed -it wouldn't tell you IF it is running, or incompletely removed,
etc.
Asking SQL directly would require that you knew the SQL Server
name -normally the same as the host, but not necessarily.
Checking the services for 'Started' (or not) could work.
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
<thirumalaivelu@.gmail.com> wrote in message
news:1152253106.670394.42180@.k73g2000cwa.googlegroups.com...
> Hello ,
> I'm trying to create an application, which would say if sql server is
> running on a machine.
> Hope i can get this from windows registry. Is there any other way do
> achieve this programatically through windows SDK , or checking the
> services programatically ?
> If i need to check the registry what are the fields that i should look
> at ?
> thanks in advance,
> Velu
>|||Arnie,
So what is the best way to do it ?
thanks,
Velu|||Velu,
Not sure if this is what you are after, but you could just create a very
quick .NET application that trys to open a connection to an IP (or hostname)
address on the usual SQL Server port, and display a message box if it did, o
r
didn't connect?
Is all you are after, is, a way to find out if a server is running on a
system or not?
Jamie.
"thirumalaivelu@.gmail.com" wrote:

> Arnie,
> So what is the best way to do it ?
> thanks,
> Velu
>|||Jamie,
thanks a lot this is wat i wanted ...
velu

How do i disable Windows Authentication mode to log into the DB?

How do i disable Windows Authentication mode and just have SQL Server Authentication mode?

is it even possible?

Yes possible. Right click on the Server -> Properties -> Security.|||

theres only two choices:

Windows Authentication mode OR BOTH Windows and SQL Authentication.

I just want SQL Authentication.

|||You cannot disable windows authentication entirely. Also, enabling windows authentication does not mean every windows user can login. The windows login should be added to the logins module to access the db.