| Groups | Blog | Home |
dotnet academic : Walkthroughs
I have installed Visual Studio.NET 2003 Academic. It came with a book called
“Visual Studio.NET Walkthroughs.†I tried to use these walkthroughs to learn how to use this stuff, but I cannot make a connection to the Pubs database. After several days of reading newsgroup posts, trying to install/uncover/whatever the Pubs database, and trying to decipher Microsoft instructions, I don’t get it. How do I make a connection to the Pubs database? Please don’t assume that I know anything because I’ve proven to myself that I’m getting dumber and dumber. I’m trying to learn how to use this stuff. When I get to the Data Adapter Connection Wizard, I click NEW CONNECTION. Under Server Name, I enter (local). I select USE WINDOWS NT INTEGRATED SECURITY. When I try to select the database on the server, I get: [DBNETLIB][Connection Open(Connect()).]SQL Server does not exist or access denied. I click OK. Login failed. Catalog information cannot be retrieved. Can anyone help a complete idiot? Remember, don't assume anything. Thanks --
[quoted text, click to view] "Sublant" <Sublant@discussions.microsoft.com> wrote in message news:C616179E-CCA8-4FFB-B08E-DC4CF9439D82@microsoft.com... > I have installed Visual Studio.NET 2003 Academic. It came with a book called > "Visual Studio.NET Walkthroughs." I tried to use these walkthroughs to learn > how to use this stuff, but I cannot make a connection to the Pubs database. > After several days of reading newsgroup posts, trying to > install/uncover/whatever the Pubs database, and trying to decipher Microsoft > instructions, I don't get it. How do I make a connection to the Pubs > database? Please don't assume that I know anything because I've proven to > myself that I'm getting dumber and dumber. I'm trying to learn how to use > this stuff. > > When I get to the Data Adapter Connection Wizard, I click NEW CONNECTION. > Under Server Name, I enter (local). > I select USE WINDOWS NT INTEGRATED SECURITY. > When I try to select the database on the server, I get: > > [DBNETLIB][Connection Open(Connect()).]SQL Server does not exist or access > denied. > > I click OK. > > Login failed. Catalog information cannot be retrieved. > > Can anyone help a complete idiot? Remember, don't assume anything. > > Thanks > > -- > Sublant Let's start with some basics. Have you installed MSDE (the desktop version of SQL Server)? If not, you'll have to download and install MSDE. The messages you are getting indicate that Visual Studio cannot find a SQL Server instance. As I deal with this situation every day where I teach, I have canned instructions for MSDE installation and setup, including the sample databases. If you want these please let me know. First, I want to be sure my assumption above is correct. -- Peter [MVP Visual Developer] Jack of all trades, master of none.
No, I have not installed MSDE. I have downloaded it now. Is there any
special place I should install it? I really do appreciate your help. [quoted text, click to view] "Peter van der Goes" wrote:
> > "Sublant" <Sublant@discussions.microsoft.com> wrote in message > news:C616179E-CCA8-4FFB-B08E-DC4CF9439D82@microsoft.com... > > I have installed Visual Studio.NET 2003 Academic. It came with a book > called > > "Visual Studio.NET Walkthroughs." I tried to use these walkthroughs to > learn > > how to use this stuff, but I cannot make a connection to the Pubs > database. > > After several days of reading newsgroup posts, trying to > > install/uncover/whatever the Pubs database, and trying to decipher > Microsoft > > instructions, I don't get it. How do I make a connection to the Pubs > > database? Please don't assume that I know anything because I've proven to > > myself that I'm getting dumber and dumber. I'm trying to learn how to use > > this stuff. > > > > When I get to the Data Adapter Connection Wizard, I click NEW CONNECTION. > > Under Server Name, I enter (local). > > I select USE WINDOWS NT INTEGRATED SECURITY. > > When I try to select the database on the server, I get: > > > > [DBNETLIB][Connection Open(Connect()).]SQL Server does not exist or access > > denied. > > > > I click OK. > > > > Login failed. Catalog information cannot be retrieved. > > > > Can anyone help a complete idiot? Remember, don't assume anything. > > > > Thanks > > > > -- > > Sublant > > Let's start with some basics. Have you installed MSDE (the desktop version > of SQL Server)? If not, you'll have to download and install MSDE. The > messages you are getting indicate that Visual Studio cannot find a SQL > Server instance. > As I deal with this situation every day where I teach, I have canned > instructions for MSDE installation and setup, including the sample > databases. If you want these please let me know. > First, I want to be sure my assumption above is correct. > > -- > Peter [MVP Visual Developer] > Jack of all trades, master of none. > >
[quoted text, click to view] "Sublant" <Sublant@discussions.microsoft.com> wrote in message Here's an excerpt from my "standard" instructions:news:49B0A96A-7C90-465D-A45C-30E10E2CC139@microsoft.com... > No, I have not installed MSDE. I have downloaded it now. Is there any > special place I should install it? > > I really do appreciate your help. > > "Peter van der Goes" wrote: > 3. Execute the file: SQL2KDeskSP3.exe. This step will extract the contents of the file to a designated folder. Make a note of the destination folder. You'll need it later. This step does not install MSDE (although the dialogs seem to hint that it does)! 4. Navigate to the folder you created in Step 2. In that folder, you will find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing SETUP.EXE will install MSDE. 5. To execute SETUP.EXE correctly, you must supply an instance name and a system administrator password as part of the command: i.e. the command must be: SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword" where yourSAPassword is your actual system administrator password. This password is needed only to install MDSE, not to use it. Access to MSDE is controlled by normal "NT Security" which should allow users access based on network logon and password. It is very important the the INSTANCENAME parameter be NetSDK, as this name will enable you to generate the sample databases automatically instead of having to run SQL scripts from the command line. 6. Once installation is complete, you must reboot the PC before you will see MSDE. After the reboot, you should see the MSDE icon in SysTray. 7. You now must execute the file: ConfigSamples.exe to configure sample applications and MSDE system databases. This step will also create user databases in the following location: C:\Program Files\Microsoft SQL Server\MSSQL\Data. Don't mind the step numbers. My early steps are for my students only and won't affect your outcome. If you cannot locate the file ConfigSamples.exe as a download, feel free to email me at: pvan AT rose DOT edu, and I'll be glad to send it to you. It contains the SQL scripts to create your sample databases. -- Peter [MVP Visual Developer] Jack of all trades, master of none.
Okay, everything went well with the installation. However, in the SysTray, I
have an icon for SQL Server that reports "Not Connected." I've opened the SQL Server Service Manager window. It asks for the Server and the Services. I couldn't find any help with this one. What do I do here? Thanks [quoted text, click to view] "Peter van der Goes" wrote:
> > "Sublant" <Sublant@discussions.microsoft.com> wrote in message > news:49B0A96A-7C90-465D-A45C-30E10E2CC139@microsoft.com... > > No, I have not installed MSDE. I have downloaded it now. Is there any > > special place I should install it? > > > > I really do appreciate your help. > > > > "Peter van der Goes" wrote: > > > Here's an excerpt from my "standard" instructions: > 3. Execute the file: SQL2KDeskSP3.exe. This step will extract the contents > of the file to a designated folder. Make a note of the destination folder. > You'll need it later. This step does not install MSDE (although the dialogs > seem to hint that it does)! > > > > 4. Navigate to the folder you created in Step 2. In that folder, you will > find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing > SETUP.EXE will install MSDE. > > > > 5. To execute SETUP.EXE correctly, you must supply an instance name and a > system administrator password as part of the command: i.e. the command must > be: > > > > SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword" > > > > where yourSAPassword is your actual system administrator password. This > password is needed only to install MDSE, not to use it. Access to MSDE is > controlled by normal "NT Security" which should allow users access based on > network logon and password. It is very important the the INSTANCENAME > parameter be NetSDK, as this name will enable you to generate the sample > databases automatically instead of having to run SQL scripts from the > command line. > > > > 6. Once installation is complete, you must reboot the PC before you will see > MSDE. After the reboot, you should see the MSDE icon in SysTray. > > > > 7. You now must execute the file: ConfigSamples.exe to configure sample > applications and MSDE system databases. This step will also create user > databases in the following location: C:\Program Files\Microsoft SQL > Server\MSSQL\Data. > > > > Don't mind the step numbers. My early steps are for my students only and > won't affect your outcome. > > If you cannot locate the file ConfigSamples.exe as a download, feel free to > email me at: > > > > pvan AT rose DOT edu, and I'll be glad to send it to you. It contains the > SQL scripts to create your sample databases. > > > -- > Peter [MVP Visual Developer] > Jack of all trades, master of none. > >
Yes, there is an instance of SQL Server in Server Explorer. I can view the
databases from Server Explorer. If I right-click on the icon in the SysTray, STOP, PAUSE, and START are not available. I can open the SQL Server Service Manager. Also available are EXIT, OPTIONS, and ABOUT. If I open the Service Manager, I'm asked for a Server and Services, neither of which have anything in the drop-down boxes. There are START/CONTINUE, PAUSE, and STOP buttons, and a checkbox for AUTO-START SERVICE WHEN OS STARTS. It reminds at the bottom that I am NOT CONNECTED - \\ Under OPTIONS, I am asked for the DEFAULT SERVICE, a POLLING INTERVAL, and a checkbox for VERIFY SERVICE CONTROL ACTION. I did find and execute ConfigSamples.exe. I don't understand why the Server Explorer can find the databases, but the SQL Server is not connected. Is VS simply reading the database files? I really do appreciate your help. [quoted text, click to view] "Peter van der Goes" wrote:
> > "Sublant" <Sublant@discussions.microsoft.com> wrote in message > news:E1341F29-E649-44EF-85E8-E9D0059A2D9B@microsoft.com... > > Okay, everything went well with the installation. However, in the > SysTray, I > > have an icon for SQL Server that reports "Not Connected." I've opened the > > SQL Server Service Manager window. It asks for the Server and the > Services. > > I couldn't find any help with this one. What do I do here? > > > > Thanks > > > We're going to need a SQL Server expert here. What happens if you > right-click on the icon and select "SQL Server Agent - Start"? If that > option does not appear, what options do you see? What do you see in Server > Explorer (in Visual Studio)? Is there an instance of SQL Server showing? > And, did you locate the file I mentioned previously with the sample > databases (ConfigSamples.exe) and run it? > > -- > Peter [MVP Visual Developer] > Jack of all trades, master of none. > >
[quoted text, click to view] "Sublant" <Sublant@discussions.microsoft.com> wrote in message We're going to need a SQL Server expert here. What happens if younews:E1341F29-E649-44EF-85E8-E9D0059A2D9B@microsoft.com... > Okay, everything went well with the installation. However, in the SysTray, I > have an icon for SQL Server that reports "Not Connected." I've opened the > SQL Server Service Manager window. It asks for the Server and the Services. > I couldn't find any help with this one. What do I do here? > > Thanks > right-click on the icon and select "SQL Server Agent - Start"? If that option does not appear, what options do you see? What do you see in Server Explorer (in Visual Studio)? Is there an instance of SQL Server showing? And, did you locate the file I mentioned previously with the sample databases (ConfigSamples.exe) and run it? -- Peter [MVP Visual Developer] Jack of all trades, master of none.
[quoted text, click to view] "Sublant" <Sublant@discussions.microsoft.com> wrote in message I'm plumb out of ideas, Sublant, but there is a newsgroup dedicated to MSDEnews:B6B21AF4-47E1-46E9-8301-11BE63C036C3@microsoft.com... > Yes, there is an instance of SQL Server in Server Explorer. I can view the > databases from Server Explorer. If I right-click on the icon in the SysTray, > STOP, PAUSE, and START are not available. I can open the SQL Server Service > Manager. Also available are EXIT, OPTIONS, and ABOUT. If I open the Service > Manager, I'm asked for a Server and Services, neither of which have anything > in the drop-down boxes. There are START/CONTINUE, PAUSE, and STOP buttons, > and a checkbox for AUTO-START SERVICE WHEN OS STARTS. It reminds at the > bottom that I am NOT CONNECTED - \\ > > Under OPTIONS, I am asked for the DEFAULT SERVICE, a POLLING INTERVAL, and a > checkbox for VERIFY SERVICE CONTROL ACTION. > > I did find and execute ConfigSamples.exe. I don't understand why the Server > Explorer can find the databases, but the SQL Server is not connected. Is VS > simply reading the database files? > > I really do appreciate your help. > where you should find more help. microsoft.public.sqlserver.msde Good luck! -- Peter [MVP Visual Developer] Jack of all trades, master of none.
Don't see what you're looking for? Try a search.
|
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |