Begginer Needs Help with MSSQL Sever 2000

[Ian Bowler]

Hello, I'm a beginner reading "Microsoft Visual C# .NET Step By Step". I'm in Chapter 29, "Accessing Data with Web Forms". According to the author, I need to grant SQL access to the ASP.NET service by completing several steps, the first of which is: In the command prompt window, type osql -E -S your_computer\NetSDK where your_computer is your computer name. This command starts the osql query tool, allowing you to enter SQL commands. You will see the prompt 1>. I currently have MSSQLSever 2000 running in the taskbar. when I follow the above step, I get the following error message in the command prompt: [DBMSLPCN]SQL Server does not exist or access denied. [DBMSLPCN]ConnectionOpen >. I've never used SQL before. I just installed it from the SQL2000.msi. Thanks in advance! -newbie

[Tim Featherston]

You don't have access to your SQL server, and there could be several reasons for that. Do you have Enterprise Manager? If so, it is a little friendlier. If you have Enterprise Manager, create a Windows Authentication login account for the ASPNET account (uUsually is "[MACHINE_NAME]\ASPNET", then make that login a user in the database you are using. You also don't need to use the ASPNET account. You can create your own SQL server Login, then in your ConnectionString use "server=[YOUR_SERVER];database=[YOUR_DATABASE];uid=[USER_ID];password=[YOUR_PASSWORD]" Tim Featherston www.QBSix.com