Solving development problems  |  About this blog

If you saved a password for a network drive in windows and want to remove it, press the keys [Windows] + [R] to open the windows command line. Then enter

control keymgr.dll

and click on “OK” to open the windows credential manager which allows you to manage and delete passwords saved in Windows.

This procedure works for Windows XP, Vista and Windows 7.

1 – Go to Terminal, copy & paste this command: gksudo nautilus that will open Terminal as root

2 – Navigate to your new drive, Right Click, select the Permissions tab

3 – Change the Owner drop-down menu to your name, then change Folder Access to Create & Delete Files, then File Access to Read & Write, then Group to your name, Folder Access to Create & Delete Files, File Access to Read & Write then click Apply Permissions To Enclosed Files.

You will now have full access to your drive.

Standard Security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Standard Security alternative syntax
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

Trusted Connection
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Trusted Connection alternative syntax
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connecting to an SQL Server instance
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;

Trusted Connection from a CE device
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;

We have experienced problem how to add MimeType that has two extensions, such as .exe.config

You can not do this using IIS7 GUI manager.

Instead of this use IIS7 console programme:

"C:\Windows\System32\inetsrv\appcmd.exe" set config "Default Web Site/sicer08" -section:system.webServer/staticContent /+"[fileExtension='.exe.config',mimeType='application/octet-stream']"

One more problem we expirienced on Windows 2008 Server 64-bit is that you can not see configuration files. They should be in C:\Windows\System32\inetsrv\Config\ but you can not see them using Windows Explorer, 32-bit application on 64-bit system so you need to find and install Microsoft IIS Admin Tool in order to manage these files (you will get one new icon in IIS7 Management Studio when you click on you IIS webserver and its name is Configuration Editor – you can edit then in Notepad – oh no…).

If you got this strange message on MySQL:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Then you will need to do the following:

1. Start DOS mysql script manager with command (I assume that you put MySQL/bin to the PATH enviroment variable):
   mysql -u [dbusername] -p, where dbusername is username for your database
2. Enter your current password and you will get mysql > prompt
3. Type:
   SET PASSWORD = OLD_PASSWORD(‘MyPassword’);
4. Type:
   FLUSH PRIVILEGES;

And thats it!