Enable Sa user and remote connection from SQL Server 2005
1. Enable “sa” user
b.In general panel of Properties set password for sa user
2. Change mode to mix-mode
- Check that you have allowed both SQL Server and Windows Authentication mode (If you’re not use Windows Authentication mode). For instance, user ‘sa’.
- Login to SQL Server using SQL Server Management Studio Express on local SQL Server with Windows Authentication user. This will use Windows account to authenticate to SQL Server.
- In Object Explorer, right click on the instance name and select Properties.
- On the left, select Security and change Server authentication to SQL Server and Windows Authentication mode. If the choice is already selected, that means you have already allowed SQL Server authentication.
- There’ll be an information window shows that you need to restart SQL Server to takes effect of the changes.
- Right-click on the instance name again, select Restart to restart SQL Server service.
If you want to enable remote connection from sql server 2005
1. Open SQL Server Surface Area Configuration from Start–> All programs–> Microsoft Sql Server 2005 –> Configuration
2. Select Surface Area Configuration for Services and Connections
3.On the left side, expand your SQL Server instance -> Database Engine -> Remote Connections. On the right side, select Local and remote connections -> using both TCP/IP and named pipes.
4.On the left side, select SQL Server Browser -> Service.
On the right side, if the startup type is Disable, you need to change to Automatic and click Apply and click Start button to start the service. Then, click OK.
If it does’nt work, check the default port of SQL Server by telnet to localhost on port 1433
If that port doen’t open. Open that port by open SQL Server Configuration Manager
Double click on TCP/IP
On tab IP Address, in IP All catalog, change the TCP port into 1433
