Archive for the ‘SQL Server’ Category
SQL Server – Change ‘sa’ password
Many of us forget things, especially if we do things very lightly and not doing it as usual. Remembering passwords is one of these. Now if so happens if you forget your ’sa’ password for the MS SQL then we can do the following:
Note: You should be a member of Administrators Group/Administrator for Windows to change this. I usually make these changes on the SQL Server itself. You can check it further in Microsoft SQL Server’s documentation for details. My example here is using the “sqlcmd.exe” though this will work with osql.exe too.
- Open command prompt
- Type the following on the command prompt: C:\> sqlcmd -E-Q “EXEC sp_password NULL, ‘newpassword’,’sa’” Note: The ‘newpassword’ is the password of your choice.
- Hit Enter/Return Key
That’s it!
Where’s port 1433 in SQL Server 2005?
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)
I also encountered the same problem using our products in Control Manager 5.0, InterScan Web Security Suite 3.1 and InterScan Messaging Security Suite 7.0 (using MSSQL 2005) that I’m unable to telnet port 1433 and unable to find this port listening using netstat.
NOTE: In this example, I used my Vista Ultimate PC installed with VS 2005 SP1 and MS SQL Server 2005 Sp1 + SQL Management Studio. I also assume you double check already that there’s no firewall and/or any other program that could block the port 1433. Otherwise, you can visit the Microsoft site for further details – http://support.microsoft.com/kb/914277
- Go to Start > Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager
- Click [+] SQL Server 2005 Network Configuration (32bit) and select Protocols for MSSQLSERVER
- Right-click the TCP/IP and select Enabled. You will be notified that in order for the changes to take effect you need to restart the SQL Server related services
- Right-click again the TCP/IP and select Properties; click the IP Addresses tab
- You should select Yes for the Enabled parameter as shown in the image with red circle around it
- Click Apply and OK to close
- Once you’ve returned to SQL Server Configuration Manager, select SQL Server 2005 Services and restart both the services
- Check if you’re able to logon now
