I need to set up a ADDITIONAL server with unique userid/password. How?

I already have a SQL Server defined. I want to do some testing using a
different userid/password for the server. Reason: I am emulating another
site for testing purposes. Since the userid/password seems to be at the
Server level, and not a database level, it looks like I need to define
another server with a different userid/password combo. Is this right or am
I missing the boat?
(Yes, I need SQL Server security. I can't get by with Windows-only)
TIA,
Larry WoodsLogins are at the server level.
Users are at the database level.
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||> Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo.
You can create the desired login using a script like the one below.
EXEC sp_addlogin 'MyLogin', 'MyPassword'
USE MyDatabase
EXEC sp_adduser 'MyLogin'
--if role-based security
EXEC sp_addrolemember 'MyRole', 'MyLogin'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> I already have a SQL Server defined. I want to do some testing using a
> different userid/password for the server. Reason: I am emulating another
> site for testing purposes. Since the userid/password seems to be at the
> Server level, and not a database level, it looks like I need to define
> another server with a different userid/password combo. Is this right or
am
> I missing the boat?
> (Yes, I need SQL Server security. I can't get by with Windows-only)
> TIA,
> Larry Woods
>|||O.K. Here is my situation. The ONLY SQL Server that I have defined was
defined with Windows-only security; therefore no SQL Server security. Now,
I need a SQL Server defined that has both Windows and SQL Server security.
That's why I "think" that I need to define a second server.
Make sense?
TIA,
Larry Woods
"Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> Logins are at the server level.
> Users are at the database level.
>
> "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > I already have a SQL Server defined. I want to do some testing using a
> > different userid/password for the server. Reason: I am emulating
another
> > site for testing purposes. Since the userid/password seems to be at the
> > Server level, and not a database level, it looks like I need to define
> > another server with a different userid/password combo. Is this right or
> am
> > I missing the boat?
> >
> > (Yes, I need SQL Server security. I can't get by with Windows-only)
> >
> > TIA,
> >
> > Larry Woods
> >
> >
>|||You can switch down from Windows only to Mixed Mode for your current server,
create an SQL Server login and do testings for that login, as you wish. Just
make sure you consider security in doing that, and make sure that you set a
password for sa before switching down. :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
news:e14MnO7%23DHA.2860@.tk2msftngp13.phx.gbl...
> O.K. Here is my situation. The ONLY SQL Server that I have defined was
> defined with Windows-only security; therefore no SQL Server security.
Now,
> I need a SQL Server defined that has both Windows and SQL Server security.
> That's why I "think" that I need to define a second server.
> Make sense?
> TIA,
> Larry Woods
> "Paul Wehland" <pwehland@.eMeSeN.COM> wrote in message
> news:u4uwo5d%23DHA.4084@.tk2msftngp13.phx.gbl...
> > Logins are at the server level.
> > Users are at the database level.
> >
> >
> > "Larry Woods" <larry@.NOSPAMlwoods.com> wrote in message
> > news:epwQ74V%23DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > I already have a SQL Server defined. I want to do some testing using
a
> > > different userid/password for the server. Reason: I am emulating
> another
> > > site for testing purposes. Since the userid/password seems to be at
the
> > > Server level, and not a database level, it looks like I need to
define
> > > another server with a different userid/password combo. Is this right
or
> > am
> > > I missing the boat?
> > >
> > > (Yes, I need SQL Server security. I can't get by with Windows-only)
> > >
> > > TIA,
> > >
> > > Larry Woods
> > >
> > >
> >
> >
>