An installation package for the product Microsoft SQL Server Native client cannot be found

An installation package for the product Microsoft SQL Server Native client cannot be found. Try again using a valid copy of the installation package ‘sqlncli.msi’

Few days back one of my co-worker came to me and asked me to install SQL server 2005 Express edition on a testing server as he had to test something. It was not a tough job at all so I asked my junior to perform this. He had to double click exe and next, next..... and finish work was there.

He started installation and it went smooth for a part but suddenly it thrown an error that “An installation package for the product Microsoft SQL Server Native client cannot be found. Try again using a valid copy of the installation package ‘sqlncli.msi’”.

He came to me with error message and I asked him for installing it using new setup but result was same.It thrown same error when it started installation of SQL native client. I searched for solution and found its creating a conflict with old installation of SQL on some other computer and it was creating problem due to installed SQL over network.

For solving this problem I simply copied the data on local machine, disabled network and installed it. Installation went smooth and whole installation completed in minimum possible time.

So for removing this error follow these three steps only

1) Copy the installation file on your computer if it’s on network

2) Disable your network

3) Install SQL server 2005 Express.

Hope it helped you and solved your problem.

If you find any issue in this, send an email to me with details.

Thanks

AP Dubey

Read More......

How to configure DHCP server in DWL-3200AP.

As I already explain about basic configuration of DWL-3200AP in my previous post here ,its second part of same tutorial.

Step by step guide to enable DHCP server in DWL-3200AP

1. Open your browser type URL of your access point. If you have any doubts visit my previous post.
2. Click advance setting, DHCP server, and Dynamic pool setting.
3. For DHCP server control select enable in front of Function Enable/Disable.
4. Assign a range of free IP in your network to this dynamic pool setting.
5. IP Assigned from:à in this field give an IP from where your wireless devices will start getting IP.
6. The Range of pool. In this range of pool you have to give last IP address that wireless device should get from DHCP.
7. Submask, its subnet mask of your network.
8. Default gateway, WINS and DNS should be same as you give manually on all other computer manually.
9. Lease time, you can give any amount in this I would recommend 6000.
10. Make the status ON and click on Apply.
11. Now click on system and restart. In 30 second it will reboot and now you can connect with your access point wirelessly using DHCP setting on client computer.
    

Things need to remember while doing this setting.

1. IP range that you give for DHCP should be free and you must not assign this IP to anyone else it might create IP conflict problem and it will make your entire network unstable.
2. You cannot create another network using this access point.
3. You can just expand your network this router cannot work as access point.
4. For maximum utilization keep your access point at a place from where you can receive signal at every corner.
5. For maximum benefit of the access point check if you can avoid walls and windows for better signals.

Hope it was helpful for you and it solved your problem.

If you find any problem in this or if some thing is not clear for you, you can visit my previous post here for basic and easy configuration of DWL-3200AP.

Thanks for being here
AP Dubey

Read More......

DWL-3200 AP easy configuration guide

I bought a new DWL-3200AP for making my wireless network strong and stable but I never did configuration of this device earlier. I was familiar with many other wireless routers but never got chance to configure an access point.

I searched on internet for some easy solution for this but I was unlucky for finding an easy configuration guide. After not finding it on internet I made call to few of my friend s and finally made it done.

If you want to go for the typical and complicated installation guide you can go ahead with that.
For simplest configuration keep reading.


Here is complete step by step guide for configuring DWL-3200AP

1. Connect your access point in your network as guided by “D-link installation guide”.
2. Default IP of Access point is 192.168.0.50 so you need to make sure your computer IP is in range.
3. If your computer IP is in same range no need to do any change else give it your computer IP as 192.168.0.10 or any other in this range.
4. You are done at preparation part now open your browser and type http://192.168.0.50/ and press enter.
5. It should ask for user name and password. Give username “admin” and password is blank.
6. Now it will open a page similar to this.
7. Click on basic settings and click on LAN.
8. In IP address text box give a new free IP that is in your network range.
9. Give subnet mast and default gateway and click on apply.
10. Now click on system and click on apply setting and restart button
11. It’s necessary to restart it for making any new change else it won’t work properly.
12. It will take 30 second to reboot.
13. Connect access point with new settings. It will ask for user name and password and it will open same screen.
14. Now click on basic settings and wireless.
15. In this screen you will get many drops down boxes for configuring settings.
16. I am guiding you for access point mode only at present I am not writing for any other mode.
17. For making an access point select mode as Access point.
18. Give a name to Wireless network Name (SSID).
19. Enable SSID broadcast.
20. Select a channel or let it be auto select.
21. If you want your network to be secure in authentication select “WPA-Personal”.
22. Cipher type “Auto” and Group Key Update Interval time “1800”.
23. Give a passphrase in passphrase text box.
24. Click on Apply and click system and click on Restart.
    

If you have DHCP server/router in your network or if you want to give IP address manually on all of wireless device you are done with settings and you don’t need to make any changes. You can connect with your newly created wireless network now.

If you don’t have DHCP server in your network and you wish to give IP address automatically on all of the wireless network device Please keep reading on how to enable dhcp on DWL-3200AP.

For any advance setting in this access point I will write another tutorial guide very soon.

Hope it was helpful for you and it solved your problems

Thanks for being here.
AP

Read More......

IP shuffling automatically in 2 different ranges on Netgear router.

IP changing automatically in 2 different ranges on Netgear router.

I use a netgear router for my wireless connection and since last 2 days i was getting a strange problem. Internet and local network stopped working on all the computers that were connected with my netgear router. I tried to find out a solution on Google but ended up with no useful result.

Finally I decided to reset my router to factory default setting and then I reconfigured it and it worked great after that. It’s not tough at all but then also let me explain it in short.

Here are the steps.

1. Disconnect your router from you main network but make sure you have power running on your router.
2. Near power cable you will find a small button inside metal plate, press it for 30 seconds or more using a pen or any other pointed device, it will restart your router that means all the light will go off and on.
3. After restart of router all of the settings that you configured are gone and router is set as default factory setting.
4. Connect your laptop desktop with any of its LAN port using a Parallel LAN cable.
5. Set your computer to get IP from DHCP.
6. Your computer will get an IP in range of 192.168.1.*, in most cases you will receive IP as 192.168.1.2.
7. When you received IP on your computer open any browser preferably Firefox.
8. Type http://192.168.1.1 and press enter.
9. It will ask you for username and password.
10. Give username as admin and password as password.
11. Now configure all the setting as you have done earlier.

If you are not familiar with settings what you need to do you can drop me an email I will try to assist you for solution of your problem.

Precaution that you should take care before doing this

1. Do it only if you are familiar with router setting else you might end up with a down wireless network.
2. Make sure you right all the things on a paper before resetting router to default factory setting.
3. Information that you should note down is setting of your ISP, your local network setting that you gave in your router, wireless key and passphrase. Your local and regional settings.
4. Make sure you take a backup of your router so you can use that router backup whenever needed

Hope it helped you if you find any problem feel free to send me an email on my mail id
apdubey@gmail.com

Thanks for being here
AP Dubey

Read More......