Re: SQL Server Service Manager not started unless network protocol support enabled.
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 02/09/04
- Next message: eric: "Re: MSDE Installation Problem"
- Previous message: Andrea Montanari: "Re: Question about Max Server Memory setting."
- In reply to: Mark: "SQL Server Service Manager not started unless network protocol support enabled."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 9 Feb 2004 16:40:05 +0100
hi Mark,
"Mark" <anonymous@discussions.microsoft.com> ha scritto nel messaggio
news:7F73A68C-467D-4E84-A0E8-942B78F7EC75@microsoft.com...
> I am using MSDE as the backend to a VB application I am building and have
a few
>questions:
>
> 1) When initially installing the instance I opted to specify an Instance
Name. My
>understanding is that this will reduce the chance of conflicts with any
other MSDE instances
>when it is installed on a target machine. When I first tried this I
noticed upon restart that the
>SQL Server Service Manager did not seem to start. After a bit of research
I have
>discovered that I need to enable network support for this to work. My
question is why do I
>need to enable network support when using a named instance? My application
will not
>need network support as it wil be running locally, so I would be a little
concerned about
>securirty.
>
> 2) How do I go about actually shipping a database with MSDE when
installing on a target
>machine, is it case of creating a SQL file with a collection of CREATE
TABLE statements,
>whic can be executed on the DB after installation?
>
> 3) Are there any specific guides for installing MSDE using Visual Studio
Installer?
>
> Many thanks for any advice.
1) there are some issues regarding the Service Manager not showing the
running instances... these usually are ODBC related issues, such as problems
with names longer than 16 chars, disabled network protocols instances....
but usually the related Service is running with no problems... please make
sure your service is running and accordingly set up at boostrap time, using
the service MMC applet...
2) please have a look at old posts like http://tinyurl.com/ytqza
3) recenlty Microsoft is releasing a resource for hepling deploying MSDE...
it seems to be still RC so some components require to set the working date
at 2003/12/31 at least in order to run smoothely... don't know when the RTM
will be released...
please have a look at http://www.microsoft.com/sql/msde/techinfo/reskit.asp
for further info..
hth
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: eric: "Re: MSDE Installation Problem"
- Previous message: Andrea Montanari: "Re: Question about Max Server Memory setting."
- In reply to: Mark: "SQL Server Service Manager not started unless network protocol support enabled."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
