Friday, 14 September 2012

Windows 2008 server missing MDB Access ODBC drivers to create system DSN


When you open ODBC Sources to create a system DSN for MDB Access, then you see that there are no drivers for such an action. To view 32-bit version of ODBC Driver, you can use the C:\Windows\SysWOW64\odbcad32.exe instead.

You can then create a desktop shortcut so that you dont need to type this command all the time.

The INSTALLSHAREDDIR command line value was not specified. This value must be specified when the INSTALLSHAREDWOWDIR value is specified.


When installing SQL Server 2008 Express on Windows 2008 64 bit server, you may encounter below error. I have got this error in godaddy's virtual server.

Error: The INSTALLSHAREDDIR command line value was not specified. This value must be specified when the INSTALLSHAREDWOWDIR value is specified.
To solve this issue, install sql server using command prompt. Here is how you can do it.

Open command prompt, go to the folder where your installation exe file is located and give the command like below.
SQLEXPRWT_x64_ENU.exe /ACTION=install /INSTANCEDIR=C:\SQLInstall\Microsoft SQL Server /INSTALLSQLDATADIR=C:\DATA /INSTALLSHAREDDIR=C:\SQLInstall\Microsoft SQL Server /INSTALLSHAREDWOWDIR=C:\SQLInstall\Microsoft SQL Server /FEATURES=SQL /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT=NT AUTHORITY\Network Service/SQLSYSADMINACCOUNTS=BUILTIN\ADMINISTRATORS /AGTSVCACCOUNT=NT AUTHORITY\Network Service /IACCEPTSQLSERVERLICENSETERMS

Note: Modify the parameter values as per your system needs.

One more step/ prerequisite which might be required in some cases:
The system name and system login name should not be same which generally happens in some hosting servers. Renaming the server first and then installing sql server through command prompt will solve the issue.

Google apps email with godaddy hosting


If you would like to use your Google Apps Email Account in GoDaddy Hosting to send mail using ASP Form then do the following smtp settings:

smtpserver: relay-hosting.secureserver.net
smtpserverpost: 25

How to Create Password Protected Directory using iis 7


1. Go to the website where you desire to password protect the folder.
2. Click on the folder that you want to set password.
3. Double Click on Authentication
4. Disable Anonymous Authentication.
5. Enable Basic Authentication.

Thats it. Now when you try to access any pages in this folder, it will prompt for user name and password. Give any valid user that you have created like FTP user and it will allow.

How to set up filezilla server on windows server 2008



Download Filezilla Server from http://filezilla-project.org/


Installation Wizard:

image

image

image

Select where you want to install the server

image

I prefer to turn off the server admin interface:

image

That's it. It’s done, now you just need to setup users, and allow port 20-21 through your firewall:

image

That's it for the basic server setup. Now onto configuring server options:

image

Once setup, and you’ve configured your network properly, test it out. By default you’ll need to configure the windows firewall or you won’t be able to connect:

Go into the Windows Firewall (Control Panel > System and Security > Windows Firewall).
Click Advanced Settings
Right Click on Inbound Rules and create new rule

image

image

Set the program you want to allow:

image

image

image

Give it a name

image

Create Users:
If all's gone well, your server's up and running—but no one can use it yet, since you haven't given anyone permission. To set up a server user, from the Edit menu choose Users. In the Users dialog on the right hand side, hit the Add button to create a new user and assign a password. Then, on the left side, select "Shared Folders" to set what folders that user will have access to on your server. Here I've created a user named gina and granted read access to the C:\data\ directory.

Notice you can fine-tune file access rights for each user: grant read-only rights (download only), write rights (to upload files), and whether or not the user can delete files or create directories, too.

Build a Home FTP Server with FileZilla