FTP using IE

You can use IE to do neat FTPs
use ftp://username@IP address
This should work fine. No command line arguments

Remote connections to SQL Server 2005 Express

Try connecting a SQL server 2005 Express server from a remote machine, you would get an error.

Error would be something like this
============================
Message : 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: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)

This is because the default setting for SQL server 2005 Express allows local connections only.

For configuring the remote connections ,

1. go to the SQL Server Surface area configuration application and click on Remote connections,select Local and Remote connections
2. Restart the SQL Server service

SQL Server 2005 - Adding an user

Should be a very basic stuff for most.

But it took me sometime.Therefore blogging it so that I do not waste a minute in it later on

1. Add the user to the server level by ensuring that in the User Mapping section ( Right click Properties ) , the default schema for the databases is dbo.
2. The role membership in the User Mapping section ( Right click Properties ) should be db_owner
3. Go to the respective database such as Pubs where the user has been added say user1
4. Right click the properties of user1
5. Ensure that the section( Schemas owned by the user ) has the db_owner checked
6. Ensure that the section( Database role membership) has the db_owner checked