Programming Microsoft ASP.NET 2.0 Core Reference
ISBN: 0735621764
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 112
Pages: 112
Authors: Dino Esposito
Chapters 5 through 11 of this book require that you have access to SQL Server 2005 Express Edition (or SQL Server 2005) to create and use the Northwind Traders database. 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 be using for performing the exercises in these chapters:
On the Windows Start menu, click All Programs, click 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 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 you have 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 you have 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.