-
Notes on DNN (DotNetNuke) Roles and Permissions
1. From Admin menu, the right-most menu item before the search box, pick “Security Roles”; 2. You will see all the roles here. Click the pencil icon next to each role to edit it; 3. To create a new role, click on Security Roles downward triangle icon, which is next to the lock icon, and…
-
No edit in DOS on Windows 64-bit
I’ve been working with 64-bit SQL Server 2005 laterly. I just finished setting up a 2-node SQL Server 2005 cluster with SP1 on AMD 64-bit processors with Windows 2003 R2. 64-bit is really sweet. Anyway, I guess the venerable DOS editor named edit is not ported to 64-bit machines. I figured this out when testing…
-
Old computers at Dallas Children’s Museum
We went to Plano, Texas, a suburb of Dallas, for my son’s spring break. My brother’s family just moved there recently. With everybody being new to the area, I didn’t know which place to visit for some fun. Naturally, I started looking for Children’s museums. Some web search revealed there is a place called Dallas…
-
Fixing remote connection problem for Microsoft SQL Server 2005
Today I played with a server setup a few months ago but has since been neglected. It has Microsoft SQL Server 2005 Standard Edition on it. I got the following error when trying to connect to it using sqlcmd integrated authentication from my workstation: C:\>sqlcmd -S MyServer HResult 0x35, Level 16, State 1 Named Pipes…
-
Setting sqlcmd environment variables
In this post, I talked about how you can set your default editor for sqlcmd. At the end of that post, I asked how to make that variable persist. To do that, you can create an environment variable. For example, you can create an environment variable called sqlcmdeditor, and give it the value of your…