Francisco H Tapia
my.lists at verizon.net
Tue Mar 18 10:08:48 CST 2003
Thanks John, (I'll cc you directly in order to speed up response time). While altho server=localhost is not valid, server=VSdotNET will be, which IMHO is much much better,... in an alpha version of some software that we are woring on we went with the localhost and I had some code to auto-start the MSDE instance of localhost, but was not for the life of me able to connect to it. This happend because of the way that the install was deployed I know know as the default installsheild version that MS put out was buggy especially in WindowsNT... go figure.. In the next deployment we are going to attempt a wise scripted install to help us along... :D -Francisco http://rcm.netfirms.com On Monday, March 17, 2003 1:35 PM [GMT-8], John Frederick <j.frederick at att.net> wrote: : I never had a full SQL Server 2000 and it seemed to me that : uninstalling an Evaluation copy didn't remove it completely. I : finally gen'ed a new W2k Prof, installed VS .NET Prof, and then ran : the MSDE Setup to install MSDE 2. The setup.ini specifies a named : instance with name: VSdotNET. Then I used the Evaluation cdrom to : install ONLY the Client Tools. I asked the local gurus if I could : somehow convert the named instance to the default. The answer was : no. As it is, it doesn't respond to Server=localhost and I'm in for : a lot of connect string editing when I deploy. I think I've explored : all the wrong ways to do this. You're invited to email to : j.frederick at att.net or phone <snip> if you want a faster : cycle time on this dialog. We can post the solution in the forum. : : -----Original Message----- : From: dba-sqlserver-admin at databaseadvisors.com : [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of : Francisco : H Tapia : Sent: Monday, March 17, 2003 10:47 AM : To: dba-sqlserver at databaseadvisors.com : Subject: Re: [dba-SQLServer]Northwind : : : how did you install MSDE as an instance w/ Sql Server 2000 already : installed? I have not been able to do that ever, in fact the install : just quits :S : : -Francisco : http://rcm.netfirms.com : : On Sunday, March 16, 2003 10:14 AM [GMT-8], : Arthur Fuller <artful at rogers.com> wrote: : :: Northwind is installed (with pubs) in any MSDE or SQL 2000 instance. :: You will also find a NorthwindCS.adp (IIRC) that connects to the :: Northwind database. :: :: -----Original Message----- :: From: dba-sqlserver-admin at databaseadvisors.com :: [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of Susan :: Harkins Sent: March 16, 2003 12:39 PM :: To: SQLList :: Subject: [dba-SQLServer]Northwind :: :: :: Northwind shows up on my list of SQL Server sample databases -- I :: also have Access and MSDE installed on the same system. Is this :: really a SQL Server database or is it the MSDE sample database? I'm :: guessing the latter. :: :: Susan H. : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com