Friday, March 23, 2012
How to register SQLExpress 2005 from SQL Server Management Studio?
I noticed SQL2005 XE installation does not come with SQL Server
Management Studio. If I install SQL2005 XE on a machine, how can I
connect to it thru SQL Server Management Studio from my workstation?
In sql2k, you can register a SQL MSDE thru EM, is there a change to
this in sql2k5? I went thru the readme file for sql2005 xe but there's
no mention of this topic.
I do not want to use SSMSE mentioned in this article to manage the
sql2005 xe, I want to use the regular SQL Server Management Studio to
manage it.
<http://support.microsoft.com/kb/907716>
Thank you"=== Steve L ===" <steve.lin@.powells.com> wrote in message
news:1132274300.199134.140290@.g44g2000cwa.googlegroups.com...
>
> I noticed SQL2005 XE installation does not come with SQL Server
> Management Studio. If I install SQL2005 XE on a machine, how can I
> connect to it thru SQL Server Management Studio from my workstation?
> In sql2k, you can register a SQL MSDE thru EM, is there a change to
> this in sql2k5? I went thru the readme file for sql2005 xe but there's
> no mention of this topic.
> I do not want to use SSMSE mentioned in this article to manage the
> sql2005 xe, I want to use the regular SQL Server Management Studio to
> manage it.
> <http://support.microsoft.com/kb/907716>
>
Register it just like any named instance. However by default TCP/IP, Named
Pipes and the Browser service are disabled in Express Edition installs.
Enable them to connect to the named instance from a remote machine.
David|||hmm...that's what i thought. however i was unable to register the XE.
(i understand TCP/IP was disabled by default).
can the machine have hyphen in it? such as 'my-test-machine'?
Labels:
database,
iconnect,
install,
installation,
machine,
management,
microsoft,
mysql,
oracle,
register,
server,
servermanagement,
sql,
sql2005,
sqlexpress,
studio,
thru
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment