WSS30/MOSS07: Replace WebApp pool user

During a fault finding situation I ran into the problem where I wanted to replace the system account for the application pool for a WebApp.

(I got an “Service unavailable” error message when even the settings.aspx on the site was called, if I remember correct.) 

I succeeded to create a new web application user manually by doing following:

1. In Windows Local Users & Groups: Create a new app pool user. Lets call him sp_proc_myapp1
2. Put the new user into the groups WSS_WPG and IIS_WPG
3. In SQL manager: Create a new SQL login for the new user and set the default db to wss_content_myapp1
4. SQL login user mapping:
   • sp_adminContent_xxx: public, WSS_Content_AppPools
   • sp_Content: public, WSS_Content_AppPools
   • wss_content_xxx: public, db_owner
5. Replace the user on the Application pool from the IIS manager

But instead of doing it manually like in the example above you can just use Central Admin to create a new web application and use the user from step 1 above as app pool user. Then Central Admin does the rest for you :-) and you only have to change app pool user in step 5.

OLEDB: Create connection string

A little trick to create a OLEDB connection string:

• On a Windows desktop (or any other folder) create a new text file.
• Rename the file to MyNewConnection.udl
• Double click the file which will open the guide Data Link Properties.
• Insert your connection data, test the connection and close the guide by pressing OK
• Open the file in your favorite text editor and view the connectionstring

Examples of generated connection strings:

•  Provider=SQLOLEDB.1;Password=MyPsw;Persist Security Info=True;User ID=MyUser;Initial Catalog=MyDb;Data Source=mydbserver\mydbinstance
• Provider=MSDASQL.1;Persist Security Info=False;MyUser ID=user1;Data Source=MyOdbcDsn;Initial Catalog=MyDB

Thanx to Rakesh Moturi

The End

Moss07: Discovering samples from Book – Inside MOSS 2007 – Part 1

This post examines the samples from the book:  Inside MOSS 2007

To be able to execute the samples you need to:

1) Download samples and execute the setup

Chapter 2. P.32 – Walkthrough: Creating a collaboration Portal

Whois

As so many times before ZoneAlarm, the firewall, alerts me with some network traffic.

But what can I do with an IP address. Do I trust it?

Found a nice site that provides Whois service to present me with owner of the IP range:

http://www.ip-adress.com/whois/213.199.170.72

XP – down

My 5 year old PC with many partitions and several OS’s needed a repair of XP.
When times are good I only have to reinstall an OS with years between. This also meens I never remember how to do.

This time there was a partion that needed more space.  I had some space infront of it, so I could move the whole partition a little forward using Partition Magic. With a Windows version that is straight forward.
Unfortunately XP in that partition wouldn’t fully load and stopped before login after the move. Probably due to bad sectors on the disk.

TFS 2008 inst: Errors

While trying to install TFS 2008 as in standalone mode on a Win server 2003 several installation prerequisites had to be met:

VPC: HowTo optimize VPC

When you are using VPC’s, there are ways to optimize performance and enhance usage.

In Bios:

• Create full isolation between VPC’s: In Bios: Enable Virtualization Technology.

In VPC Console:

• Enable use of special chars like “{” by using AltGr: File – Options – Keyboard – Change AltGr to RightCtrl
• Add RAM and increase memory amount allocated to the Virtual Machine: Select the VM – Settings – Memory – increase using the ruler, while the VM is shut down.

Each Virtual Machine:

• Sync the HW of your PC with your image: With the VM open: Action – Install or update VM additions – Select C:\Program Files\Microsoft Virtual PC\Virtual Machine Additions\VMAdditions.iso

If your host is Win2k8 srv and the VPC is Hyper-V then use Remote Desktop as Client. Graphics update is faster and the look and feel is like when you are operating the production environment.

Link: http://blogs.msdn.com/Virtual_PC_Guy/

Thanx to Peter Karpinski

Cisco VPN Client maybes

If you also has a Cisco VPN Client V.4.6.01.0019 you might have been anoyed about it quite often.

WSS: HowTo build a WSS project – Installation requirements

Here are some suggestions of how you can get the first touch on WSS.

Here might be supplemented with a list of installation requirement.