VB.Net Standard 2003 and MSDE

[David Lee]

Need some help bad here. Am using VB.Net Standard 2003 supplied for
a class and I need to install Msde and the sample databases to work on
homework. Following the documentation I can download sql2kdesksp3.exe
and get the server running. I cannot then install the sample databases
according to directions. Log file follows:

2:28:26 AM Wednesday, October 01, 2003: [Begin Samples Configuration]
12:28:26 AM Wednesday, October 01, 2003: [Pass] Modified the sourceview node
of web.config.: C:\PROGRA~1\Microsoft Visual Studio .NET
2003\SDK\v1.1\QuickStart\web.config
12:28:26 AM Wednesday, October 01, 2003: [Pass] Detected NetSDK instance of
SQL Server.
12:28:29 AM Wednesday, October 01, 2003: [Pass] Added QuickStart user to SQL
Server.
12:28:29 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script.
(Script/ExitCode): InstPubs.sql/1
12:28:31 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: Pubs: Cannot open database requested in login 'Pubs'.
Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:32 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script.
(Script/ExitCode): InstNwnd.sql/1
12:28:34 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: Northwind: Cannot open database requested in login
'Northwind'. Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:34 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script.
(Script/ExitCode): Grocer.sql/1
12:28:36 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: GrocerToGo: Cannot open database requested in login
'GrocerToGo'. Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:36 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script.
(Script/ExitCode): Portal.sql/1
12:28:38 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: Portal: Cannot open database requested in login 'Portal'.
Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:38 AM Wednesday, October 01, 2003: [Pass] Set NetSamplePath
environment variable.
12:28:39 AM Wednesday, October 01, 2003: [Pass] Executed
....\Samples\QuickStart\Register.bat.
12:28:39 AM Wednesday, October 01, 2003: [Pass] Replaced destination file
with source file. (destination/source):
StartSamples.htm/Setup\HTML\StartSamplesGDN.htm
12:28:39 AM Wednesday, October 01, 2003: [End Samples Configuration]
12:28:39 AM Wednesday, October 01,
2003: -----------------------------------------

Ok. Then I cannot connect to the server in VB.Net. One problem Is We are
using VS professional in class so the setup is different.

My Lab Tech cannot tell me how to do it. My instructor could not so he said
lets go see the Network gurus and maybe they will help. Well when I talked
to the Network geniuses their eyes glazed over and They said " Oh no we
can't tell you how to set up Sql Server and configure it in a few minutes.
You must take our classes". I said no no no Simple Msde setup to no avail.
I have tried every possible combinations from all the documentation I have
found. Any ideas. Thanks

[Rick Rothstein]

Almost everybody here is using VB6 or lower. While you may get a stray
answer to VB.NET questions here, you should ask them in newsgroups devoted
exclusively to .NET programming. Look for newsgroups with the word "dotnet"
in their name.

For the news.devx.com news server, try these

vb.dotnet.discussion
vb.dotnet.technical

For the microsoft news server, try these newsgroups...

microsoft.public.dotnet.general
microsoft.public.dotnet.languages.vb

There are some others, but these should get you started.

Rick - MVP


"David Lee" <da****************@mindspring.com> wrote in message
news:Z3*****************@newsread1.news.atl.earthl ink.net...

Need some help bad here. Am using VB.Net Standard 2003 supplied for
a class and I need to install Msde and the sample databases to work on
homework. Following the documentation I can download sql2kdesksp3.exe
and get the server running. I cannot then install the sample databases
according to directions. Log file follows:

2:28:26 AM Wednesday, October 01, 2003: [Begin Samples Configuration]
12:28:26 AM Wednesday, October 01, 2003: [Pass] Modified the sourceview node of web.config.: C:\PROGRA~1\Microsoft Visual Studio .NET
2003\SDK\v1.1\QuickStart\web.config
12:28:26 AM Wednesday, October 01, 2003: [Pass] Detected NetSDK instance of SQL Server.
12:28:29 AM Wednesday, October 01, 2003: [Pass] Added QuickStart user to SQL Server.
12:28:29 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script. (Script/ExitCode): InstPubs.sql/1
12:28:31 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: Pubs: Cannot open database requested in login 'Pubs'.
Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:32 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script. (Script/ExitCode): InstNwnd.sql/1
12:28:34 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: Northwind: Cannot open database requested in login
'Northwind'. Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:34 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script. (Script/ExitCode): Grocer.sql/1
12:28:36 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: GrocerToGo: Cannot open database requested in login
'GrocerToGo'. Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:36 AM Wednesday, October 01, 2003: [Fail] Error executing SQL script. (Script/ExitCode): Portal.sql/1
12:28:38 AM Wednesday, October 01, 2003: [Fail] Could not add QuickStart
user to database.: Portal: Cannot open database requested in login 'Portal'. Login fails.
Login failed for user 'BIGCHEESE\Ken Darnell'.
12:28:38 AM Wednesday, October 01, 2003: [Pass] Set NetSamplePath
environment variable.
12:28:39 AM Wednesday, October 01, 2003: [Pass] Executed
...\Samples\QuickStart\Register.bat.
12:28:39 AM Wednesday, October 01, 2003: [Pass] Replaced destination file
with source file. (destination/source):
StartSamples.htm/Setup\HTML\StartSamplesGDN.htm
12:28:39 AM Wednesday, October 01, 2003: [End Samples Configuration]
12:28:39 AM Wednesday, October 01,
2003: -----------------------------------------

Ok. Then I cannot connect to the server in VB.Net. One problem Is We are
using VS professional in class so the setup is different.

My Lab Tech cannot tell me how to do it. My instructor could not so he said lets go see the Network gurus and maybe they will help. Well when I talked
to the Network geniuses their eyes glazed over and They said " Oh no we
can't tell you how to set up Sql Server and configure it in a few minutes.
You must take our classes". I said no no no Simple Msde setup to no avail.
I have tried every possible combinations from all the documentation I have found. Any ideas. Thanks