I'm a little late to the show. I was at the cottage. IIRC it needs to be compyname\SQLEXPRESS.
For me it's: Server Type: Database Engine Server Name: MEDIC\SQLEXPRESS Authentication: Windows Authentication HTH On Thu, Jul 29, 2010 at 4:40 PM, Scott Raley <sra...@itc-llc.com> wrote: > > I took all the defaults when I installed it. Maybe I'll go grab the dev > edition if its free. I don't need it very long, just have to do data > conversions between two apps and they need sql server. > > -----Original Message----- > From: Judah McAuley [mailto:ju...@wiredotter.com] > Sent: Thursday, July 29, 2010 4:31 PM > To: cf-community > Subject: Re: win7 and sql 2008 express > > > Ah, I missed the part about studio express not being able to connect. > Did you install it as a named instance (which is the default) or did > you tell it to install as the default instance (which sounds weird, I > know). If you did it as a named instance, I find that things get > weird. It is one of the reasons I tend to use SQL Server Developer > edition instead of Express on my local box. I'd uninstall it and > reinstall it, making sure not to do the named instance. Or use > Developer edition. Also, take a look at the Event log just to see if > it is throwing any errors. > > judah > > On Thu, Jul 29, 2010 at 12:58 PM, Scott Raley <sra...@itc-llc.com> wrote: > > > > But even with that its own studio express should be able to connect to it > > but I'll try > > > > -----Original Message----- > > From: Judah McAuley [mailto:ju...@wiredotter.com] > > Sent: Thursday, July 29, 2010 3:55 PM > > To: cf-community > > Subject: Re: win7 and sql 2008 express > > > > > > TCP/IP is not enabled by default on sql express. You have to go into > > the Configuration Manager (which is a seperate app) and enable the > > networking protocol. By default, it only turns on shared memory or > > named pipes, can't recall which off the top of my head, which is fine > > for .Net apps but no love for jdbc. > > > > Judah > > > > On Thu, Jul 29, 2010 at 12:49 PM, Scott Raley <sra...@itc-llc.com> > wrote: > >> > >> Anyone have sql express 2008 working on a windows 7 machine? It > installed > >> fine and all services are starting but nothing can connect to it and > when > > it > >> browses it can't find any sql servers running. > >> > >> > >> > >> > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:324364 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
