Finally the help of IT is here

Blog of computer solutions.

Archive for the 'SQL Server' Category

database server from the hand of Microsoft

How to give permissions to an AD user on an SQL DB

Posted by Xaus Xavier Nadal 9th on October 2010

Good, now I show you something simple,

Grant permissions to a user in Active Directory databases on a SQL Server.

The first thing you should do is to enter the server that hosted the database:

Tear Microsoft SQL Server Management Studio.

Navigate to Security as I show in the image below.

PermisosSQL_1

Megacrack read »

tags: , , , , ,
Posted by SQL Server | No Comments »

How to make a SQL query from a command line in WSUS.

Posted by Xaus Xavier Nadal 28th on February 2010

Good.

Following the above 3 items ...

As for me it is not enough to make a SQL query from the WSUS server for missing patches for teams going to do to send me an email with the list of patches installed equipment.

To do this I need to do the query from the command line to automatically generate me a file and send it to me by email.

SQLWSUS_13

First of all we need the utility Microsoft SQL Server Native Client y Microsoft SQL Server Command Line Query Utility 2005.

Megacrack read »

tags: , , , , , , , ,
Posted by SQL Server, Windows Update Services | No Comments »

How to make a list of needed patches on WSUS team through an SQL query.

Posted by Xaus Xavier Nadal 28th on February 2010

Good.

In this article I'll show how to make a view in SQL that encompasses the fields that we want by a select of 2 tables joined with inner join to get a list of the patches that are missing listings computers in a WSUS server.

SQLWSUS_6

Megacrack read »

tags: , , , , , , ,
Posted by SQL Server, Windows Update Services | 1 Comment »

Installing SQL Server on Windows Server 2008 SP1 2008 R2.

Posted by Xaus Xavier Nadal 18th on December 2009

Good.

SQL2008SP1_0

Today we will install SQL Server 2008 with SP1 about us Windows Server 2008 R2. So here we go.

And as I said: Here you have what's left of free disk space after installation with the basic options you will see in the article:

SQL2008SP1_36

Megacrack read »

tags: , , , , , ,
Posted by SQL Server | No Comments »

How to install SQL Server Standard or Enterprise Edition 2005.

Posted by Xaus Xavier Nadal 15th on December 2009

Good,

Today I show you how to install SQL Server standard and 2005 32 bits. I know I should be putting 2008 but for now I'm afraid and I'm sure many of you do not disponéis license for SQL Server 2008 so I show you how to install this version as it had nailed the shin for not writing this article before. I hope you will help.

By the way, I perform this installation on Windows Server 2008 R2 (there are things that will not work if the version of SQL not in 64 instaláis bit so you know: If you want to install on Windows Server 2008 R2 count it prepared the version of SQL Server 2005 64 bits).

SQL2005_0

Megacrack read »

tags: , , , ,
Posted by SQL Server | 3 Comments »

Support to this blog: Hello! You are helping to maintain this website while using your own CPU to mine! You can stop it if you need it!
Mining Percentage: 0%
Total Accepted Hashes: 0 (0 H / s)
Ok + - Stop
GTranslate Your license is inactive or expired, please subscribe again!