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:324124 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
