SharePoint Blogs / SharePoint University
SharePoint Blogs and SharePoint University - all in one place!
echef » SQL 2005 Embedded Edition... What the heck is that?
Need SharePoint Training? Attend a SharePoint Bootcamp!

Please delete cookies related to sharepointblogs.com and sharepointu.com to resolve login issues!

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...

Posted 08-23-2007 3:19 PM by josef.nielsen

Comments

Cenk Ozkan wrote re: SQL 2005 Embedded Edition... What the heck is that?
on 11-03-2007 6:24 PM

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 !

Mark Owen wrote re: SQL 2005 Embedded Edition... What the heck is that?
on 02-14-2008 3:31 AM

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.

manish wrote re: SQL 2005 Embedded Edition... What the heck is that?
on 04-11-2008 5:28 AM

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

Gadgetty.co.uk: For gadgets, technology and cyber-ramblings » Blog Archive » Connecting to SQL EE wrote Gadgetty.co.uk: For gadgets, technology and cyber-ramblings » Blog Archive » Connecting to SQL EE
on 09-30-2008 6:40 AM

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

Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2009 SharePoint Experts, Inc.