Programming Microsoft Web Forms (Pro Developer)
ISBN: 0735621799
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 70
Pages: 70
Authors: Douglas J. Reilly
Chapters 5 7 of this book require that you have access to SQL Server 2005 Express Edition (or SQL Server 2005) to create and use the BikeBlog database, which is included with the source code for this book. If you are using SQL Server 2005 Express Edition, log in as Administrator on your computer, and follow these steps to grant access to the user account that you will use to perform the exercises in these chapters:
On the Windows Start menu, point to All Programs, point to Accessories, and then click Command Prompt to open a command prompt window.
In the command prompt window, type the following command:
sqlcmd S YourServer\SQLExpress E
Replace YourServer with the name of your computer.
You can find the name of your computer by running the hostname command in the command prompt window, before running the sqlcmd command.
At the 1> prompt, type the following command, including the square brackets, and then press Enter:
sp_grantlogin [YourServer\UserName]
Replace YourServer with the name of your computer, and replace UserName with the name of the user account that you will be using.
At the 2> prompt, type the following command, and then press Enter:
go
If you see an error message, make sure that you typed the sp_grantlogin command correctly, including the square brackets.
At the 1> prompt, type the following command, including the square brackets, and then press Enter:
sp_addsrvrolemember [YourServer\UserName], dbcreator
At the 2> prompt, type the following command, and then press Enter:
go
If you see an error message, make sure that you typed the sp_addsrvrolemember command correctly, including the square brackets.
At the 1> prompt, type the following command, and then press Enter:
exit
Close the command prompt window.