Permissions problems in SQL Server Reporting Services

If you are having permissions problems in SQL Server Reporting Services, even though your account a member of the Administrators group, try to add it to the users group (users or domain users). After trying dozens of tips, redo multiple configurations, I created another administrative account and this worked without a problem of permission. The difference between this second account and the first was his participation of the user group. Ai was only doing the obvious and include the account that didn't work in the group. Worked without problems. Except that the permissions were based on lower profile, what are the permissions of a user policy. The second administrative account, created for the test, everything was released. All the other tips I used can be found on the Internet.

Problema de permissão no Reporting Services

Se você está tendo problemas de permissões no SQL Server Reporting Services, mesmo sendo sua conta uma integrante do grupo de administradores, experimente adicioná-la ao grupo de usuários (users ou domain users). Depois de tentar dezenas de dicas, refazer várias configurações, criei outra conta administrativa e esta funcionou sem o problema da permissão. A diferença entre esta segunda conta e a primeira era sua participação do grupo de usuários. Ai foi só fazer o óbvio e incluir a conta que não funcionava no grupo. Funcionou sem problemas. Exceto pelo fato de que as permissões foram baseadas no menor perfil, que são as permissões de um usuário comum. Já a segunda conta administrativa, criada para o teste, tudo ficou liberado. Todas as outras dicas que usei podem ser encontradas na Internet.

NoSQL para Oracle e SQL Server

Gostaria de saber se há algum material sobre a adoção de tecnologias de gerenciamento e acesso a dados não estruturados, baseadas em NOSQL, para os bancos mais tradicionais, como Oracle e SQLServer. Tenho visto vários bancos para o NoSQL, mas sabemos que a realidade corporativa é bem diferente do desejo acadêmico e tecnológico. Migrar é caro e nem sempre é possível. E todos sabemos que o banco relacional ainda será a solução ideal para a parte transacional das empresas, nos obrigando assim a construir soluções híbridas de gerenciamento de dados, onde o relacional e o não estruturado terão que conviver, e mais que isto, terão que se integrar para se retroalimentarem. Será uma simbiose, como em muitas outras tecnologias. Estou envolvido em alguns projetos de desenvolvimento e não está sobrando tempo para estas pesquisas. Se alguém souber de alguma notícia dos grandes players, favor informar, ou colaborar, como dizemos corporativamente.

SQL Server express não tem Agent

É isto mesmo, nem a versão mais atual do SQL Server Express (atualmente 2008 R2) traz o serviço SQL Server Agent "habilitável". Ele é instalado, mas não é possível inicializá-lo, apesar de tudo parecer que vai funcionar. E não adianta instalar as features. O serviço não indica diretamente o erro, que na verdade é "by design", e por isto não considerado um erro, literalmente. Mas você só descobre depois que já está pronto para usar o serviço, não é mesmo?

No listener, but with underline

I started a whole new installation of Oracle 11g from scratch in my windowsxp mode virtual machine with a hostname "winxp_vm1". Everything was going right until a moment when, almost 100% finished, a screen (not the blue of death) saying the Enterprise Manager could not be configured successfully (just) because the host name was composed by a underline character ("_"). I´ve got really, much really, surprised and yet disapointed with oracle installation. But the life goes on and I still need the Oracle running, OK?

But what to do now?


Just finish the installer;


Rename the hostname, I mean, remove the underline from the name;


Edit the tnsnames.ora and fix the hostname, now without the underline;


Edit the listener.ora and fix it the same way you did it before with tnsnames.ora;


Just restart the machine or the listener (lsnrctl start).

It was a piece of cake this time, but you can have differente situtations, so, dont give up. The Internet is an exceptional friend... Good bye.

Powered by Zoundry Raven

Technorati : hostname, listener, oracle, underline, windowsxp

Del.icio.us : hostname, listener, oracle, underline, windowsxp

Zooomr : hostname, listener, oracle, underline, windowsxp

Flickr : hostname, listener, oracle, underline, windowsxp

Save passwords security flaw in TOAD

I am a TOAD 9 user. A friend of mine said me using password saving in TOAD was not secure. Since then I've tried to find a solution to that, unsuccessfuly. The problem is: every password saved in your login session will be available for every login session at the same station. Any user who wants to use your passwords only have to log in into your station and acess the TOAD. Any connection can be made just selecting the schema and pressing Connect. If you have already saved a password before for the selected schema, voilá, the intruder is in.
I beg for your help to avoid this unwished behavior of TOAD. Let me know the workaround (or the final solution) ASAP you discover it. Best regards.

Installing Oracle 10g on Windows 7

When installing the Oracle 10g on Windows 7 I found some problems. So, after fixing them, I decided to share with you my experience.

First, Oracle asks for a network adapter with IP set (but can also use DHCP), so, I decided to install the ms loopback adapter on my notebook (dell inspiron 1525):

I. Install the ms loopback adapter

If your "Add Device" feature is presenting problem, I mean freezing (like mine was), use the Hardware Wizard, from the command prompt:

1. Click the Start menu.
2. Search for “cmd".
3. Right-click on “cmd” and select “Run as Administrator”
4. Enter “hdwwiz।exe”
5. In the "Welcome to the Add Hardware Wizard", click Next.
6. Select "Install the hardware that I manually select from a list (Advanced)" and click Next.
7. Scroll down and select "Network adapters" and click Next.
8. Select under Manufacturer "Microsoft" and then under Network Adapter "Microsoft Loopback Adapter" and click Next.

(Thanks to gdavi on http://social.technet.microsoft.com/Forums/en-US/w7itpronetworking/thread/259c7ef2-3770-4212-8fca-c58936979851).

After passing the network test, the OUI refuse to install on Windows 7. Let´s go on...

II. Run the setup using old version of Windows (fake? no, simulation).
If OUI (Oracle Universal Installer), i.e. setup.exe, detects the version and refuse to install on windows 7, run the setup.exe using the feature for downgrade your version detected by OUI:
1. Start > Control Panel > Programs > Use an older program with this version of Windows;
2. Next. Wait for detection of issues...
3. If Oracle is not in the list (I bet it wont be...), choose "Not Listed". Next.
4. Browse to the folder where the Oracle setup.exe is located, click Open, and then... Next, of course.
5. Select the issue "The program worked in eralier versions of Windows but won´t install or run now". Next.
6 . Select your wished version. I used Vista. Next.
7 . A message will appear and then, after the next Next button, the program will start up the setup.exe.

In my case, no one problem was found after this configuration.

If some of the try abort when installing, I advice you to delete the remainig folder from previous (aborted) installation, avoiding unused folders after sucessfull installation. By default, my installer is creating c:\oracle\product\10.2.0\db_1 folder, but this is changeable in the first screen of OUI.

Hope to help. Good bye.