……Marco Valli's Blog……

Internet, Tecnologia e SharePoint!!!

Connettersi e Gestire il database di Sharepoint installato sul Windows Internal Database


Ancora un’altro sito utile.. gestendo un’installazione di Sharepoint può servire accedere alla console di SQL Server per gestire il database installato però su SQL Express… visto che non è tutto così immediato, ecco il metodo funzionante per collegarsi e gestire il nostro amato DB…

Problem
Microsoft products such as Windows Server Update Services (WSUS) 3.0 and Windows Sharepoint Services (WSS) 3.0 ship with SQL Server 2005 Embedded Edition. Now called the Windows Internal Database, more and more system administrators charged with managing WSUS and WSS are faced with the challenge of managing these databases. Since most of these system administrators are not full-pledged DBAs, how do they manage the Windows Internal Database?

Solution
The Windows Internal Database is an embedded data service that can only be used by a handful of Windows Services. It is designed in such a way that you are not allowed to connect to and use this particular database service for non-Microsoft products. By default, installing either WSUS 3.0 or WSS 3.0 will create the databases on the C:\ partition and will cause administration issues such as insufficient disk space. It is quite confusing to manage this SQL Server instance as it does not appear as a SQL Server service nor are there management tools included with the products. The easiest way is to use SQL Server Management Studio Express. You can install a copy of SQL Server Management Studio Express on the server running your WSUS 3.0 or WSS 3.0. You then register this instance using Named Pipes as this is the only configuration for connectivity. Use this server name when you register this instance

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Once you’ve managed to register this instance in SQL Server Management Studio Express, you can now administer the WSUS 3.0 and WSS 3.0 databases like shrinking the database files or moving them to a different disk partition dedicated for them to avoid insufficient disk space issues.

If you prefer to use scripts to manage these databases, you can download and install the SQL Server 2005 Command Line Query Utility – sqlcmd . This tool will be installed, by default, on this directory

C:\Program Files\Microsoft SQL Server\90\Tools\binn

To connect to the database instance, you need to run the sqlcmd.exe utility, passing the instance name and your credentials

sqlcmd -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query –E

You can then run your administrative T-SQL scripts once connected to this database instance.

Considerations

While these are possible reasons to administer the Windows Internal Database, it is not recommended to do anything beyond performing backups, moving or shrinking the database files. Modifying database schema or database properties would break supportability of these products. Plus, any changes made to these databases can be overwritten by the products’ service packs or cumulative updates.

Next Steps

  • Install SQL Server Management Studio Express on your WSUS 3.0 and WSS 3.0 servers
  • Take control of your WSUS 3.0 and WSS 3.0 databases

QUI trovate il post originale…

Enjoy!! 🙂

Annunci

2 risposte a “Connettersi e Gestire il database di Sharepoint installato sul Windows Internal Database

  1. Green Coffee Extract 3 luglio 2013 alle 03:58

    I do not even know how I ended up here, but I thought this post was great.
    I don’t know who you are but definitely you’re going to
    a famous blogger if you aren’t already 😉 Cheers!

  2. Herpes Solution 9 agosto 2013 alle 05:16

    I am actually happy to glance at this weblog posts
    which includes plenty of helpful data, thanks for providing such
    statistics.

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...

%d blogger hanno fatto clic su Mi Piace per questo: