Instances of SQL Server have disappeared

Hi,

We had 5 instances of SQL Server running on one of our machines and everything looked to be working fine. Today I installed another instance for a new application and once done and rebooted the new instance didn't show in the SQL Server Enterprise Manager. At this point we decided to uninstall it. After that 4 of the existing instances have diapered as well even though they are running and responding requests from their respective applications.

I did some googling and all I could see is something related to a command called nscontrol but I couldn't find any nscontrol executable on that machine.

Does anyone have any idea what this problem could be?

Thanksnscontrol is related to SQL Notification Services. I don't think that would be part of your solution.

I'm confused why you are installing a new instance of SQL Server for each application?

In any case, are you having any better luck? If not, can you go to the Windows command prompt on the server where SQL Server is running and type in osql -L and see if your instances are all listed? Have you checked your system's event log for any clues? How about the SQL Server error log?

I know that you should be able to run up to 16 instances of SQL Server, so you are probably not hitting that limitation.

Terri|||I'm with Terri. Instead of running 5 instances of SQL Server, why not use 1? And use 5 different databases? Seems like a better solution to me. Probably less overhead too.|||Sorry for not posting sooner, someone here has experienced something similar and the solution was to reregister every instance in Enterprise Manager. We can't explain why this thing happens but looks like this is what had to be done.

With respect to using instances rather then databases, the theory here is that we try to stay away from database administration and delegate it to the groups that actually need that application and databases that is why we give different instances to different groups of people. I hope that this explains somehow our situation.|||Glad you got it sorted out.

Yes, I had done research after you had made that post and read the cases for having multiple instances on the same server. That does make sense. Just keep in mind you can't have more than 16 instances :-)

Terri|||Yes, we knew about 16 instances limit.

Thanks

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>

Instance name

I have two machines install SQL Server 2000.
One has the same name as my machine name, eg. alan.
Another machine has the name as 'Local'.
Why is that the case ?Alan
> Another machine has the name as 'Local'.
> Why is that the case ?
A person, who installed SQL Server specified LOCAL as name of the SQL Server
If you want to change the name ,just delete the registration from EM and
create a new one with name of the machine
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>I have two machines install SQL Server 2000.
> One has the same name as my machine name, eg. alan.
> Another machine has the name as 'Local'.
> Why is that the case ?
>|||How do I create a new one with name of the machine when setup ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
> A person, who installed SQL Server specified LOCAL as name of the SQL
> Server
> If you want to change the name ,just delete the registration from EM and
> create a new one with name of the machine
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>|||Hi,
I really don't understand why I installed SQL Server 2000 on 2 machines, one
in my office, one at home, why one has the machine name, eg. "alan", at my
office. But on my home machine, the server instance is called "LOCAL"?
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eixndxxoGHA.1600@.TK2MSFTNGP04.phx.gbl...
> How do I create a new one with name of the machine when setup ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23AYAhS1nGHA.4340@.TK2MSFTNGP05.phx.gbl...
>> Alan
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>> A person, who installed SQL Server specified LOCAL as name of the SQL
>> Server
>> If you want to change the name ,just delete the registration from EM and
>> create a new one with name of the machine
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:OUKgcJ1nGHA.3700@.TK2MSFTNGP03.phx.gbl...
>>I have two machines install SQL Server 2000.
>> One has the same name as my machine name, eg. alan.
>> Another machine has the name as 'Local'.
>> Why is that the case ?
>>
>

Installing the samples after an install

Hi,

I stupidly did not install the samples for 2005 when I installed the dev edition on my machines. Now I would like to. Unfortunately, I can't seem to find a way to do it. The installation process always says I have the documentation installed (I have books online installed). It appears that there is no way to install the samples if you have installed the documentation and workstation items.

Is there somewhere I can download the samples?

Thanks for any help.
]Monty[Do the following:

1) Go to Add/Remove Programs
2) Click on the entry for SQL Server 2005 and click the Change button
3) Select "Workstation Components" and click Next (this will launch the feature in maintenance mode which allows you to add or remove components)
4) Follow the dialogs accepting the defaults.
5) On the "Change or Remove..." dialog select the "Change Installed Components" option.
6) On the "Feature Selection" dialog expand the "Documentation, Samples, and Sample Databases" node.
7) Select the samples you want installed (e.g. Sample Databases and/or Code Samples). Follow the dialogs to the end
- If your installing the Sample Databases you'll be prompted for an instance to connect them to.
- If your installing the Code Samples, this process drops the Code Sample MSI to your machine. You'll need to go to "Start -> All Programs -> Microsoft SQL Server 2005 -> Documentation and Samples -> Samples" and run "Microsoft SQL Server 2005 Samples (English)" to install the actual code samples.

Dan|||Thanks a ton, man.

]Monty[|||

The sample databases and samples can also be downloaded from this site:
http://msdn.microsoft.com/sql/downloads/samples/

Regards,

sql

Integrated Security across machines

I have two machines called MA and MB. MA is hosting IIS and MB is hosting SQL
Server. I'd like to use integrated security to access SQL Server in my
application hosted in IIS. How should I configure the SQL Server so that it
can recognize the Network Service account in another machine?
Thanks.
Daniel
Hello Daniel,
I understand that you'd like to web application could access SQL Server by
using Network service account. If I'm off-base, please let me know.
Usually it is suggested that you use a domain account under the situation
in the application pool of IIS, and configure "impersonate" to false in
web.config of ASP.net application.
The other opiton is configure "impersonate" to true, and grant each client
domain user proper permission on remote SQL Server. Please note under this
situation, IIS has to be use Kerberos authentication and it shall be
enabled to "delegate" the user credential to remote SQL server.
891031Common security issues when you access remote resources from ASP.NET
applications
http://support.microsoft.com/default.aspx?scid=kb;EN-US;891031
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn2.microsoft.com/en-us/library/aa302387.aspx
How to configure an ASP.NET application for a delegation scenario
http://support.microsoft.com/default.aspx?scid=kb;EN-US;810572
It is not recommended to use Network Service account under the situation.
Since Network service account actually use machine account to access remote
server, you may try to add the "domain\server$" to SQL Server login and
grant it some permission. However, this may not work as expected and may
bring security hole.
If you have any comments or feedback, please feel free to let me know.
Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Using a domain account is a nice way I think. But we have one problem that is
the company IT policy states that each AD account must bind to an actual
human user. So up to now, we can't create AD accounts for our system. And AD
account for user has a policy of changing password every 45 days. I think
there must be a good reason for the company to establish this policy, may be
for the sake of SOX. Do you know the reason for such policy? How do other
people work around such problems?
Thanks.
Daniel
|||Many companies will also have policies for service accounts
with service accounts being in a different OU from user
accounts. They should have some requirements for service
accounts and what accounts services will use.
-Sue
On Wed, 28 Feb 2007 01:13:13 -0800, Daniel
<daniel.shen@.newsgroup.nospam> wrote:

>Using a domain account is a nice way I think. But we have one problem that is
>the company IT policy states that each AD account must bind to an actual
>human user. So up to now, we can't create AD accounts for our system. And AD
>account for user has a policy of changing password every 45 days. I think
>there must be a good reason for the company to establish this policy, may be
>for the sake of SOX. Do you know the reason for such policy? How do other
>people work around such problems?
>Thanks.
>Daniel
|||Hello Daniel,
I agree that this policy is for security purpose. However, as Sue
mentioned, it makes sense to have different policy to have service
accounts. Or you have to change the password of service account accordingly
and restart services when necessary. This could be done by a script or
manually.
Please let's know if you have further questions or concerns, please feel
free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hello Daniel,
Just want to check in if you have further questions on the issue. Please
feel free to post back if you need any help.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Integrated Security across machines

I have two machines called MA and MB. MA is hosting IIS and MB is hosting SQ
L
Server. I'd like to use integrated security to access SQL Server in my
application hosted in IIS. How should I configure the SQL Server so that it
can recognize the Network Service account in another machine?
Thanks.
DanielHello Daniel,
I understand that you'd like to web application could access SQL Server by
using Network service account. If I'm off-base, please let me know.
Usually it is suggested that you use a domain account under the situation
in the application pool of IIS, and configure "impersonate" to false in
web.config of ASP.net application.
The other opiton is configure "impersonate" to true, and grant each client
domain user proper permission on remote SQL Server. Please note under this
situation, IIS has to be use Kerberos authentication and it shall be
enabled to "delegate" the user credential to remote SQL server.
891031 Common security issues when you access remote resources from ASP.NET
applications
http://support.microsoft.com/defaul...kb;EN-US;891031
Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication
http://msdn2.microsoft.com/en-us/library/aa302387.aspx
How to configure an ASP.NET application for a delegation scenario
http://support.microsoft.com/defaul...kb;EN-US;810572
It is not recommended to use Network Service account under the situation.
Since Network service account actually use machine account to access remote
server, you may try to add the "domain\server$" to SQL Server login and
grant it some permission. However, this may not work as expected and may
bring security hole.
If you have any comments or feedback, please feel free to let me know.
Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Using a domain account is a nice way I think. But we have one problem that i
s
the company IT policy states that each AD account must bind to an actual
human user. So up to now, we can't create AD accounts for our system. And AD
account for user has a policy of changing password every 45 days. I think
there must be a good reason for the company to establish this policy, may be
for the sake of SOX. Do you know the reason for such policy? How do other
people work around such problems?
Thanks.
Daniel|||Many companies will also have policies for service accounts
with service accounts being in a different OU from user
accounts. They should have some requirements for service
accounts and what accounts services will use.
-Sue
On Wed, 28 Feb 2007 01:13:13 -0800, Daniel
<daniel.shen@.newsgroup.nospam> wrote:

>Using a domain account is a nice way I think. But we have one problem that
is
>the company IT policy states that each AD account must bind to an actual
>human user. So up to now, we can't create AD accounts for our system. And A
D
>account for user has a policy of changing password every 45 days. I think
>there must be a good reason for the company to establish this policy, may b
e
>for the sake of SOX. Do you know the reason for such policy? How do other
>people work around such problems?
>Thanks.
>Daniel|||Hello Daniel,
I agree that this policy is for security purpose. However, as Sue
mentioned, it makes sense to have different policy to have service
accounts. Or you have to change the password of service account accordingly
and restart services when necessary. This could be done by a script or
manually.
Please let's know if you have further questions or concerns, please feel
free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hello Daniel,
Just want to check in if you have further questions on the issue. Please
feel free to post back if you need any help.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.