Tuesday, October 22, 2013

Cannot create new folder in Windows 7

Unable to create a new folder in Windows 7. From within Windows Explorer if I select the "New Folder" option, nothing happens. Also, from the Desktop, the "Folder" option does not show when right-clicking and selecting "New".

Solution

Download Reg Fix

Wednesday, August 7, 2013

Changing the name of a SQL Server PC

1. Delete all maintenance plans before renaming the server
2. Go to Microsoft SQL Server Management Studio
3. Click new query
4. Run the following procedures without       "< ---------------------------------------------------------------------------------
sp_dropserver 'KUSERVER'                           <GO                                                                  
sp_addserver 'ANUSERVER', local               <GO

---------------------------------------------------------------------------------
5. Restart the PC
6. Go to Microsoft SQL Server Management Studio
7. Click new query
8. Change Database to "msdb "
9. Copy this Query to new query, change 2nd line (New Server Name) & execute query.
---------------------------------------------------------------------------------
DECLARE @oldservername as varchar(max)
SET @oldservername='
ANUSERVER'-- set the new server name to the current server name
declare @newservername as varchar(max)
set @newservername = @@servername
declare @xml as varchar(max)
declare @packagedata as varbinary(max)-- get all the plans that have the old server name in their connection string
DECLARE PlansToFix Cursor FOR
SELECT id
FROM sysssispackages
WHERE (CAST(CAST(packagedata AS varbinary(MAX)) AS varchar(MAX)) LIKE '%Data Source=' + @oldservername + '%')

OPEN PlansToFix
declare @planid uniqueidentifier
fetch next from PlansToFix into @planid
while (@@fetch_status<>-1) -- for each plan
begin
if (@@fetch_status<>-2)
begin
select @xml=cast(cast(packagedata as varbinary(max)) as varchar(max))
from sysssispackages where id= @planid -- get the plan's xml converted to an xml string
declare @planname varchar(max)select @planname=[name] from sysssispackages where id= @planid -- get the plan name
print 'Changing ' + @planname + ' server from ' + @oldservername + ' to ' + @newservername -- print out what change is happening
set @xml=replace(@xml,'Data Source=' + @oldservername,'Data Source=' + @newservername) -- replace the old server name with the new server name in the connection string
select @packagedata=cast(@xml as varbinary(max)) -- convert the xml back to binary
UPDATE sysssispackages SET packagedata = @packagedata WHERE (id= @planid) -- update the plan
end
fetch next from PlansToFix into @planid -- get the next plan
end
close PlansToFix
deallocate PlansToFix

------------------------------------------------------------------------------ 
10. restart SQLSERVER Service or Restart your pc
11. Create maintenance plans
12. If this doesn't work, leave a comment here and I will help you....

Thursday, February 14, 2013

Thunderbird Mail Account Settings Cpanel

This summary is not available. Please click here to view the post.

Monday, February 4, 2013

Version's Parameters must be greater than or equal to zero parameter name:build

After starting setup and clinking installation
Click on install new instance
setup support rules - runs fine
click ok
click install support files - completes
Then on the
Please Wait wile SQL Server 2008 R2 Nov CTP setup processes the current operation.....

Error:
SQL Server Setup failure
SQL Server setup has encauntered the folowing error:
Version's Parameters must be greater than or equal to zero
parameter name:build

Click OK



Solution
====== 
----------------------------------------------
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup\CurrentVersion]
"Language"=dword:00000409
"CurrentVersion"="8.00.194"
"CSDVersionNumber"=dword:00000300
"CSDVersion"="8.00.760"

----------------------------------------------
copy following info into a raji'saqlfix.reg file or recreate the following in the registry manually and the SQL Server 2008 R2 installer should continue successfully:
 http://www.sendspace.com/file/rqrxne

Monday, September 12, 2011

Sharing the Internet with DialUp Connection

How to use Internet Connection Sharing

To use Internet Connection Sharing to share your Internet connection, the host computer must have one network adapter that is configured to connect to the internal network, and one network adapter or modem that is configured to connect to the Internet.

1) On the host computer

On the host computer, follow these steps to share the Internet connection:
  1. Log on to the host computer as Administrator or as Owner.
  2. Click Start, and then click Control Panel.
  3. Click Network and Internet Connections.
  4. Click Network Connections.
  5. Right-click the connection that you use to connect to the Internet. For example, if you connect to the Internet by using a modem, right-click the connection that you want under Dial-up.
  6. Click Properties.
  7. Click the Advanced tab.
  8. Under Internet Connection Sharing, select the Allow other network users to connect through this computer's Internet connection check box.
  9. If you are sharing a dial-up Internet connection, select the Establish a dial-up connection whenever a computer on my network attempts to access the Internet check box if you want to permit your computer to automatically connect to the Internet.
  10. Click OK. You receive the following message:
    When Internet Connection Sharing is enabled, your LAN adapter will be set to use IP
    address 192.168.0.1. Your computer may lose connectivity with other computers on
    your network. If these other computers have static IP addresses, it is a good idea to set them
    to obtain their IP addresses automatically. Are you sure you want to enable Internet
    Connection Sharing?
  11. Click Yes.
The connection to the Internet is shared to other computers on the local area network (LAN). The network adapter that is connected to the LAN is configured with a static IP address of 192.168.0.1 and a subnet mask of 255.255.255.0

2) On the client computer

To connect to the Internet by using the shared connection, you must confirm the LAN adapter IP configuration, and then configure the client computer. To confirm the LAN adapter IP configuration, follow these steps:
  1. Log on to the client computer as Administrator or as Owner.
  2. Click Start, and then click Control Panel.
  3. Click Network and Internet Connections.
  4. Click Network Connections.
  5. Right-click Local Area Connection, and then click Properties.
  6. Click the General tab, click Internet Protocol (TCP/IP) in the This connection uses the following items list, and then click Properties.
  7. In the Internet Protocol (TCP/IP) Properties dialog box, click Obtain an IP address automatically (if it is not already selected), and then click OK.

    Note You can also assign a unique static IP address in the range of 192.168.0.2 to 192.168.0.254. For example, you can assign the following static IP address, subnet mask, and default gateway:
       IP Address      192.168.0.2    Subnet mask     255.255.255.0    Default gateway 192.168.0.1      
  8. In the Local Area Connection Properties dialog box, click OK.
  9. Quit Control Panel.

3) To configure the client computer to use the shared Internet connection, follow these steps:
  1. Click Start, and then click Control Panel.
  2. Click Network and Internet Connections.
  3. Click Internet Options.
  4. In the Internet Properties dialog box, click the Connections tab.
  5. Click the Setup button.

    The New Connection Wizard starts.
  6. On the Welcome to the New Connection Wizard page, click Next.
  7. Click Connect to the Internet, and then click Next.
  8. Click Set up my connection manually, and then click Next.
  9. Click Connect using a broadband connection that is always on, and then click Next.
  10. On the Completing the New Connection Wizard page, click Finish.
  11. Quit Control Panel.
When you now start Microsoft Internet Explorer, the client computer will try to connect to the Internet by using the host computer's shared Internet connection.