all groups > sql server new users > july 2006 >
You're in the

sql server new users

group:

Two instances - authentication question


Two instances - authentication question mcron
7/28/2006 1:48:02 PM
sql server new users:
I have an existing installation of SQL Server 2000 configured for Windows
authentication. I have a new application that requires SQL Server and
Windows authentication. If I install SQL Server 2000 on this server again,
am I creating another "instance"? Is the authentication method specific to
an instance (in my case, one instance uses Windows and one instance uses SQL
Server and Windows)?
Thanks in advance for the help,
Re: Two instances - authentication question Arnie Rowland
7/28/2006 2:02:11 PM
Yes, the authentication method is Instance specific.

Be sure to verify if the application is capable of using an instance other
than the default instance (naming issues). If the application requires the
default instance, you could move your current databases, jobs, etc. to the
new instance. (Not too bad of a chore.)

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


[quoted text, click to view]

Re: Two instances - authentication question mcRon
7/28/2006 2:17:02 PM
Thanks for the tip on the instance names.

And thanks for helping me with this question.

McR

[quoted text, click to view]
AddThis Social Bookmark Button