in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

echef

From the cluttered (and clustered) brain of Josef Nielsen... A great place for Food, Friends, and... uh... SharePoint of course!

SQL 2005 Embedded Edition... What the heck is that?

So I ran in to a copy of SQL 2005 Embedded today... first time I've seen it.  It was on a MOSS install that some folks were testing, and they wanted the content moved over to our Production environment. No Problem, says I... I went to go make a backup of the Context DB to import in to the Production farm to move the content, but I couldn't connect to the DB server with my Management Studio. 

Scratching my head with a perplexed look on my face, I loaded the Management Studio on the local server and tried opening it up there.  No Dice...  Apparently, it is an IP disabled version that only allow local named pipes connections, or something. 

The only way I found to connect to the thing was by telling the Management Studio to connect to \\.\pipe\mssql$microsoft##ssee\sql\query 

 Not very intuitive... but it works...

Comments

 

Cenk Ozkan said:

Wow. At last somebody who as written something about connecting to the elusive Embedded Edition. Thank you very much, was scratching my head for a while !

November 3, 2007 6:24 PM
 

Mark Owen said:

Hi, I realise that this is a late reaction, but I have just come across your blog entry.

I found that the answer to this problem was to do with the SQL Express Browser. By default, this is disabled, preventing access from the network. Once I enabled this, there was no problem with connecting.

February 14, 2008 3:31 AM
 

manish said:

i dont know why Microsoft releases such versions but people like you save us from this mess..thanks alot.....great work

April 11, 2008 5:28 AM
 

Gadgetty.co.uk: For gadgets, technology and cyber-ramblings » Blog Archive » Connecting to SQL EE said:

Pingback from  Gadgetty.co.uk: For gadgets, technology and cyber-ramblings  » Blog Archive   » Connecting to SQL EE

September 30, 2008 6:40 AM

About josef.nielsen

I'm a long time computer nerd, living and loving technology wherever I can find it. I've recently shifted from a focus in MS SQL server, MSCS Clustering, and High Availability Engineering to focus on collaboration technologies, including SharePoint 2007. I recently moved from my long-time home in Seattle Washington to Salt Lake City.

Need SharePoint Training? Attend a SharePoint Bootcamp!

Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts