Missing dll file: authentication

Showing posts with label authentication. Show all posts

Wednesday, March 21, 2012

Mixing SQL Server and MSDE and authentication

We install MSDE2000 under a named instance and with SQL Server
authentication, and specify a password for 'sa'.
I recently had someone install it on a system that already had SQL Server
installed.
On that system, we could not connect to the named instance using the "sa"
user and password specified in the installer. Using ODBC, we kept getting
the error 18452 - Login failed for user 'sa'.
How does the presence of SQL Server affect this? Does the 'sa' password for
the SQL Server default instance take precedence?
hi,
"JJ" <jjjj@.nospam.com> ha scritto nel messaggio
news:uAPJ05LGEHA.2732@.tk2msftngp13.phx.gbl...
> We install MSDE2000 under a named instance and with SQL Server
> authentication, and specify a password for 'sa'.
> I recently had someone install it on a system that already had SQL Server
> installed.
> On that system, we could not connect to the named instance using the "sa"
> user and password specified in the installer. Using ODBC, we kept getting
> the error 18452 - Login failed for user 'sa'.
> How does the presence of SQL Server affect this? Does the 'sa' password
for
> the SQL Server default instance take precedence?
>
it shoul'd really not...
all specified settings are instance specific, the only difference is that
the 1st instance (default) will listen to default TCP/IP port 1433, while
all other ubsequent instances will pass throught UDP port 1434 if they have
been set to dinamically retrieve the port number... but this another
story...
if you can reproduce the problem and are "sure" [ =;-) ] that the MSDE
instance has been installed specifying the SECURITYMODE=SQL parameter, you
are wellcome to open a case with Microsoft PSS...
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi again,
anyway, try checking the HKLM\Software\Microsoft\Microsoft SQL
Server\Instance Name\MSSQLServer\LoginMode registry key... it shoul'd be 2
or 0 for mixed mode authentication...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||That's the strange part - I did check that in the registry and it was set to
2, so I tried setting it to 0 (then stopped and restarted the MSDE instance)
and got the same error.
Unfortunately, I can't check it again because we ended up just using SQL
Server and uninstalling MSDE for the user with the problem. (It was
actually a mistake for the user to have done the install with MSDE because
usually if they have SQL Server already, we want them to just use that. I
can't think of a good reason for an end user to have both SQL Server and
MSDE installed on the same system. But I was curious to find out whether or
not it should have worked.)
It may indeed have been the dynamic port issue - I did not check the client
configuration to see if it was trying to go to a specific port (i.e. 1433).
But I would have thought it just wouldn't have connected since the server
name contained the instance name.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:c4ju2l$2h7scp$1@.ID-207518.news.uni-berlin.de...
> hi again,
> anyway, try checking the HKLM\Software\Microsoft\Microsoft SQL
> Server\Instance Name\MSSQLServer\LoginMode registry key... it shoul'd be 2
> or 0 for mixed mode authentication...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Mixed Mode vs. Windows Authentication

I am trying to create a query that can determine if a user id is using mixed mode/windows/both authentication. I need to do this so that it can run on both sql server 2000 and 2005, meaning I can't use any of the sys.* views. Is there a single query could use for both systems?
-Kyle

Hi kschlap,

there is no method for your issue.

but maybe you can try to build a view to select cross these 2 servers.

create view v_loginid_info

select 'servname'='mssql2k', loginid

from mssql2k.master.dbo.sysprocesses

union all

select 'servname'='mssql2k05', loginid

from mssql2k05.master.sys.sysprocess

try to think about.

hoping this can help you.

Best Regrads,

Hunt.

|||I have found the query...

select name, is_policy_checked
from sys.sql_logins

When I use this query, it doesn't pick up the windows authenticated users. Is there a way to get it to pick up all users?
-Kyle|||

How about something like this:

select name, isntuser from syslogins

isntuser=1 means Windows authentication

isntuser=0 means SQL Server authentication

Ben

sql

Mixed mode security on XP

Hi,
I am trying to get a demo going on an XP laptop.
To do this I am trying to set Authentication on the server Security tb to
"SQL Server and Windows".
Changing this setting is not sticking. IE I make the change, click OK, check
and the change is gone. If I restart SQL Server, the change is not there.
HELP!
TIA
-TimWhoops. I did not have SP3a in...

"Mercury" <me@.spam.com> wrote in message
news:d3dhcp$i08$1@.lust.ihug.co.nz...
> Hi,
> I am trying to get a demo going on an XP laptop.
> To do this I am trying to set Authentication on the server Security tb to
> "SQL Server and Windows".
> Changing this setting is not sticking. IE I make the change, click OK,
> check and the change is gone. If I restart SQL Server, the change is not
> there.
> HELP!
> TIA
> -Tim
>

Mixed Mode Authentication Conversion-Post Setup

I need help changing the authentication mode from Windows Authentication to Mixed Mode (for Project Server 2003). I am unable to find the Enterprise Management area. Evidently in this area, I can make this change. Is this the place to make these changes, or is there a better place? I am a novice, only days into this process. I need to setup a Project Server, and it needs Sql to breathe. Please help me!!

Kristoff, what SKU of SQL Server 2005 are you using? Standard, eval, etc? You should be able to go to the start menu and launch /SQL Server Management Studio from there. Are you seeing it there?

Thanks,
Sam Lester (MSFT)

Mixed Mode Authentication

What do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?

>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>
No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle

Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...[vbcol=seagreen]
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> Server on my network, I
> tells me that my
> installation.
> with "Windows Only" will
> services and still no

Mixed Mode Authentication

What do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?

>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle

Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx
.gbl...[vbcol=seagreen]
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> Server on my network, I
> tells me that my
> installation.
> with "Windows Only" will
> services and still no

Mixed Mode Authentication

Hi folks,
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveWhat do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>|||David,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" will
> not switch to "Windows and SQL". I have restarted the services and still no
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle :)
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> >--Original Message--
> >Hi folks,
> >
> >I have a microsoft SQL server 2000 on a Windows 2003
> Server on my network, I
> >am trying to install project server 2003. Project server
> tells me that my
> >SQL server must be in Mixed mode to complete the
> installation.
> >
> >The problem is that the server which was installed
> with "Windows Only" will
> >not switch to "Windows and SQL". I have restarted the
> services and still no
> >joy, what else can I do to change to mixed mode?
> >
> >thanks
> >Dave
> >
> >
> >.
> >|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>>David,
>>Is SQL Server a local administrator on the machine? Does it have access
>>to the registry? This state is stored in the registry, and if SQL Server
>>doesn't have write permission to the registry it could fail.
>>The registry key is
>>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
>>SQLServer\<instance_name>\MSSQLServer\LoginMode
>>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
>>may still see 0 for SQL Server only (servers upgraded from 6.5).
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>David Hodgson wrote:
>>Hi folks,
>>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> network, I
>>am trying to install project server 2003. Project server tells me that
> my
>>SQL server must be in Mixed mode to complete the installation.
>>The problem is that the server which was installed with "Windows Only"
> will
>>not switch to "Windows and SQL". I have restarted the services and still
> no
>>joy, what else can I do to change to mixed mode?
>>thanks
>>Dave
>>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Just thought of something there, what do you mean is the "SQL Server" a
> > local administrator on the machine?
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >
> >>David,
> >>
> >>Is SQL Server a local administrator on the machine? Does it have access
> >>to the registry? This state is stored in the registry, and if SQL Server
> >>doesn't have write permission to the registry it could fail.
> >>
> >>The registry key is
> >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> >>SQLServer\<instance_name>\MSSQLServer\LoginMode
> >>
> >>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> >>may still see 0 for SQL Server only (servers upgraded from 6.5).
> >>
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>David Hodgson wrote:
> >>
> >>Hi folks,
> >>
> >>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> >
> > network, I
> >
> >>am trying to install project server 2003. Project server tells me that
> >
> > my
> >
> >>SQL server must be in Mixed mode to complete the installation.
> >>
> >>The problem is that the server which was installed with "Windows Only"
> >
> > will
> >
> >>not switch to "Windows and SQL". I have restarted the services and
still
> >
> > no
> >
> >>joy, what else can I do to change to mixed mode?
> >>
> >>thanks
> >>Dave
> >>
> >>
> >
> >
> >sql

Mixed Mode Authentication

Mixed Mode

After installing SQL Server 2005 I found that I inadvertantly used Windows Authentication Mode and I would like to change to Mixed Mode (Windows Authentication and SQL Server Authentication) - what is the best way to do this? In Microsoft SQL Server 2000 you could simply go into Enterprise Manager, edit the SQL Server Registration Properties, edit the Properties of the SQL Server and edit the Properties of the SQL Server Agent.

It's a server property. In SQL Workbench, open object explorer, add your server, right-click on it and select properties. It should be in there somewhere.

Monday, March 19, 2012

Mixed Authentication

Hi All,

We have started to get the strangest errors with our SQL Server. We use
Windows and SQL Server authentication, and have done successfully for
the last year or so. However last week i had trouble connecting to the
enterprise manager with my domain credentials. Users connecting to Query
Analyser have no problems when using their SQL Server logins, the issue
only seems to arrise when a Domain account is provided for
authentication. If we reboot the server all is well for about 1 - 2
hours and then we loose the Domain credentials again. Even SQL Agent
fails to work when stated with the DOMAIN\Administrator account!

As i said this has worked for a long time, and we have not made any
changes to the Domain or installed any patches for any of the servers.
The error messages normally involve something along the lines of "No
User 'NULL' blah blah" and "No Trusted SQL Server". We also have an
excel report that is failing with the SQL Server error number 18452. I
have looked this up on MSDN, and this seems to fall in to the same
category as our other errors.

Any Ideas?

We can't reboot the server every 2 hours!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Adam Stewart (adams@.gem.co.uk) writes:
> We have started to get the strangest errors with our SQL Server. We use
> Windows and SQL Server authentication, and have done successfully for
> the last year or so. However last week i had trouble connecting to the
> enterprise manager with my domain credentials. Users connecting to Query
> Analyser have no problems when using their SQL Server logins, the issue
> only seems to arrise when a Domain account is provided for
> authentication. If we reboot the server all is well for about 1 - 2
> hours and then we loose the Domain credentials again. Even SQL Agent
> fails to work when stated with the DOMAIN\Administrator account!
> As i said this has worked for a long time, and we have not made any
> changes to the Domain or installed any patches for any of the servers.
> The error messages normally involve something along the lines of "No
> User 'NULL' blah blah" and "No Trusted SQL Server". We also have an
> excel report that is failing with the SQL Server error number 18452. I
> have looked this up on MSDN, and this seems to fall in to the same
> category as our other errors.

I would suspect that this is more of a Windows issue than an SQL Server
issue, so you may have better success in a Windows forum.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

mixed & windows authentication

Hi,
i am confused by the windows & mixed mode authentication
Under Windows Authentication , do i need to create a login
in SQL server ?
thks & rdgs
Hi,
Under Windows Authentication , do i need to create a login in SQL server ?
No need to create a login in SQL server if you are using in Windows
Authentication, Instead you just grant permission to Windows user or group
account to connect to Microsoft SQL Server ( refer sp_grantlogin in books
online) . But while allowing the access automatically a entry will put in to
SYSXLOGINS system table in Master database. All the User policies / Password
policies like password expiration, Password length , password
combination,... will be maintained by OS itself.
Windows Authentication:-
Only Windows users/groups will be able to connect to SQL Server.
Mixed Authentication:
Mixed Mode allows users to connect to an instance of SQL Server, through
either a Windows user account
or a SQL Server login.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
> Hi,
> i am confused by the windows & mixed mode authentication
> Under Windows Authentication , do i need to create a login
> in SQL server ?
> thks & rdgs
|||thks Hari
>--Original Message--
>Hi,
>Under Windows Authentication , do i need to create a
login in SQL server ?
>No need to create a login in SQL server if you are using
in Windows
>Authentication, Instead you just grant permission to
Windows user or group
>account to connect to Microsoft SQL Server ( refer
sp_grantlogin in books
>online) . But while allowing the access automatically a
entry will put in to
>SYSXLOGINS system table in Master database. All the User
policies / Password
>policies like password expiration, Password length ,
password
>combination,... will be maintained by OS itself.
>Windows Authentication:-
>Only Windows users/groups will be able to connect to SQL
Server.
>Mixed Authentication:
>Mixed Mode allows users to connect to an instance of SQL
Server, through
>either a Windows user account
>or a SQL Server login.
>Thanks
>Hari
>MCDBA
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
authentication[vbcol=seagreen]
login
>
>.
>

mixed & windows authentication

Hi,
i am confused by the windows & mixed mode authentication
Under Windows Authentication , do i need to create a login
in SQL server ?
thks & rdgsHi,
Under Windows Authentication , do i need to create a login in SQL server ?
No need to create a login in SQL server if you are using in Windows
Authentication, Instead you just grant permission to Windows user or group
account to connect to Microsoft SQL Server ( refer sp_grantlogin in books
online) . But while allowing the access automatically a entry will put in to
SYSXLOGINS system table in Master database. All the User policies / Password
policies like password expiration, Password length , password
combination,... will be maintained by OS itself.
Windows Authentication:-
Only Windows users/groups will be able to connect to SQL Server.
Mixed Authentication:
Mixed Mode allows users to connect to an instance of SQL Server, through
either a Windows user account
or a SQL Server login.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
> Hi,
> i am confused by the windows & mixed mode authentication
> Under Windows Authentication , do i need to create a login
> in SQL server ?
> thks & rdgs|||thks Hari
>--Original Message--
>Hi,
>Under Windows Authentication , do i need to create a
login in SQL server ?
>No need to create a login in SQL server if you are using
in Windows
>Authentication, Instead you just grant permission to
Windows user or group
>account to connect to Microsoft SQL Server ( refer
sp_grantlogin in books
>online) . But while allowing the access automatically a
entry will put in to
>SYSXLOGINS system table in Master database. All the User
policies / Password
>policies like password expiration, Password length ,
password
>combination,... will be maintained by OS itself.
>Windows Authentication:-
>Only Windows users/groups will be able to connect to SQL
Server.
>Mixed Authentication:
>Mixed Mode allows users to connect to an instance of SQL
Server, through
>either a Windows user account
>or a SQL Server login.
>Thanks
>Hari
>MCDBA
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
authentication[vbcol=seagreen]
login[vbcol=seagreen]
>
>.
>

mixed & windows authentication

Hi,
i am confused by the windows & mixed mode authentication
Under Windows Authentication , do i need to create a login
in SQL server ?
thks & rdgsHi,
Under Windows Authentication , do i need to create a login in SQL server ?
No need to create a login in SQL server if you are using in Windows
Authentication, Instead you just grant permission to Windows user or group
account to connect to Microsoft SQL Server ( refer sp_grantlogin in books
online) . But while allowing the access automatically a entry will put in to
SYSXLOGINS system table in Master database. All the User policies / Password
policies like password expiration, Password length , password
combination,... will be maintained by OS itself.
Windows Authentication:-
Only Windows users/groups will be able to connect to SQL Server.
Mixed Authentication:
Mixed Mode allows users to connect to an instance of SQL Server, through
either a Windows user account
or a SQL Server login.
Thanks
Hari
MCDBA
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
> Hi,
> i am confused by the windows & mixed mode authentication
> Under Windows Authentication , do i need to create a login
> in SQL server ?
> thks & rdgs|||thks Hari
>--Original Message--
>Hi,
>Under Windows Authentication , do i need to create a
login in SQL server ?
>No need to create a login in SQL server if you are using
in Windows
>Authentication, Instead you just grant permission to
Windows user or group
>account to connect to Microsoft SQL Server ( refer
sp_grantlogin in books
>online) . But while allowing the access automatically a
entry will put in to
>SYSXLOGINS system table in Master database. All the User
policies / Password
>policies like password expiration, Password length ,
password
>combination,... will be maintained by OS itself.
>Windows Authentication:-
>Only Windows users/groups will be able to connect to SQL
Server.
>Mixed Authentication:
>Mixed Mode allows users to connect to an instance of SQL
Server, through
>either a Windows user account
>or a SQL Server login.
>Thanks
>Hari
>MCDBA
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:796801c4843b$fcf94cf0$a601280a@.phx.gbl...
>> Hi,
>> i am confused by the windows & mixed mode
authentication
>> Under Windows Authentication , do i need to create a
login
>> in SQL server ?
>> thks & rdgs
>
>.
>

Wednesday, March 21, 2012

Mixing SQL Server and MSDE and authentication

Mixed Mode vs. Windows Authentication

Mixed mode security on XP

Mixed Mode Authentication Conversion-Post Setup

Mixed Mode Authentication

Mixed Mode Authentication

Mixed Mode Authentication

Mixed Mode Authentication

Mixed Mode Authentication

Mixed Mode

Monday, March 19, 2012

Mixed Authentication

mixed & windows authentication

mixed & windows authentication

mixed & windows authentication

Missing dll file

Blog Archive

About Me