SQLExpress

19 Jan 2006 6:43 PM

Arne

I can open SQL Server Manangement studio and connnect to computer\sqlexpress.
My databases are listed.
I can also do sseutil -l which list a different set of databases on the same
machine.
How can that be?

19 Jan 2006 6:49 PM

Roger Wolter[MSFT]

Magic.

Actually, you are using two different SQL Server instances which have
different databases attached: the normal instance which you are attaching to
with Management Studio and a "User Instance" which is what sseutil will
attach to by default. There's more information on how this works here:

http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Show quoteHide quote

"Arne" <A***@discussions.microsoft.com> wrote in message
news:EA62CDB1-7838-4DC7-9AC6-25CE9F187792@microsoft.com...
>I can open SQL Server Manangement studio and connnect to
>computer\sqlexpress.
> My databases are listed.
> I can also do sseutil -l which list a different set of databases on the
> same
> machine.
> How can that be?

19 Jan 2006 7:05 PM

Arne

Roger,
It sounds like a user instance is a local database only. Can a normal
instance in sqlexpress be seen over the network?
I am trying to deploy a database at a customer site, with sqlexpress. I
would like the instance to been seen on the network. Would a user instance be
a bad choice?

Arne

Show quoteHide quote

"Roger Wolter[MSFT]" wrote:

> Magic.
>
> Actually, you are using two different SQL Server instances which have
> different databases attached: the normal instance which you are attaching to
> with Management Studio and a "User Instance" which is what sseutil will
> attach to by default. There's more information on how this works here:
>
> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Arne" <A***@discussions.microsoft.com> wrote in message
> news:EA62CDB1-7838-4DC7-9AC6-25CE9F187792@microsoft.com...
> >I can open SQL Server Manangement studio and connnect to
> >computer\sqlexpress.
> > My databases are listed.
> > I can also do sseutil -l which list a different set of databases on the
> > same
> > machine.
> > How can that be?
>
>
>

19 Jan 2006 7:53 PM

Roger Wolter[MSFT]

User instances can't be seen over the network. You will have to attach the
database to the normal instance before it can be seen on the network. Also
remember that SQL Express by default is local only also so you will have to
use the Surface Area Configuration tool to enable remote connections and
sqlbrowser before you can connect remotely.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Show quoteHide quote

"Arne" <A***@discussions.microsoft.com> wrote in message
news:95FC1F5F-4D81-47D0-BAAB-71A9AD2BA48D@microsoft.com...
> Roger,
> It sounds like a user instance is a local database only. Can a normal
> instance in sqlexpress be seen over the network?
> I am trying to deploy a database at a customer site, with sqlexpress. I
> would like the instance to been seen on the network. Would a user instance
> be
> a bad choice?
>
> Arne
>
> "Roger Wolter[MSFT]" wrote:
>
>> Magic.
>>
>> Actually, you are using two different SQL Server instances which have
>> different databases attached: the normal instance which you are attaching
>> to
>> with Management Studio and a "User Instance" which is what sseutil will
>> attach to by default. There's more information on how this works here:
>>
>> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>>
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>>
>> "Arne" <A***@discussions.microsoft.com> wrote in message
>> news:EA62CDB1-7838-4DC7-9AC6-25CE9F187792@microsoft.com...
>> >I can open SQL Server Manangement studio and connnect to
>> >computer\sqlexpress.
>> > My databases are listed.
>> > I can also do sseutil -l which list a different set of databases on the
>> > same
>> > machine.
>> > How can that be?
>>
>>
>>