Board index MS SQL Server

How to change authentication ??

How to change authentication ??

Post by Bill » Sat, 03 Mar 2001 18:41:30



Hi everyone,

When I installed my MS SQL Server 2000, I used Windows authentication to
connect to SQL Server. Can I change it to SQL Server authentication? (I use
Windows 2000)

The reason I want to change it is that I want to use ADO to connect VB and
SQL Server. ADO askes me to input UID and Pwd of SQL Server. I tried to use
Windows 2000's user name and password to connect VB and SQL Server, I
failed.

Does anybody have any suggestion for me?

Thanks,
Bill Han

 
 
 
Top

How to change authentication ??

Post by Leopol » Sat, 03 Mar 2001 19:55:28


You may consider sticking to Windows authentication and use OLE DB.
You don't have to specify userID or Password.
The connection then looks like
    Set ADOConnection = New ADODB.Connection
    ADOConnection.Open "Provider=sqloledb;Data Source=Bach;Initial
Catalog=Revenue;Integrated Security=SSPI"
    Set rs = ADOConnection.Execute(lstrSQL, , adCmdStoredProc)

For more info, search for SSPI in Books On Line.



Quote:> Hi everyone,

> When I installed my MS SQL Server 2000, I used Windows authentication to
> connect to SQL Server. Can I change it to SQL Server authentication? (I
use
> Windows 2000)

> The reason I want to change it is that I want to use ADO to connect VB and
> SQL Server. ADO askes me to input UID and Pwd of SQL Server. I tried to
use
> Windows 2000's user name and password to connect VB and SQL Server, I
> failed.

> Does anybody have any suggestion for me?

> Thanks,
> Bill Han


 
 
 
Top

How to change authentication ??

Post by Wayne Snyde » Sat, 03 Mar 2001 22:41:16


In order to change the security model... Go to SEM, right click your server,
go to the security tab, and select SQL Security... YOu must then bring SQL
server down and back up..

--
Wayne Snyder MCDBA, MCSE, MCT, SQL Server MVP
IKON Education Services, C*te, NC
(Please respond only to newsgroups)

Quote:> Hi everyone,

> When I installed my MS SQL Server 2000, I used Windows authentication to
> connect to SQL Server. Can I change it to SQL Server authentication? (I
use
> Windows 2000)

> The reason I want to change it is that I want to use ADO to connect VB and
> SQL Server. ADO askes me to input UID and Pwd of SQL Server. I tried to
use
> Windows 2000's user name and password to connect VB and SQL Server, I
> failed.

> Does anybody have any suggestion for me?

> Thanks,
> Bill Han

 
 
 
Top

How to change authentication ??

Post by Bill » Sun, 04 Mar 2001 17:55:48


It's a big help.
Thanks,
Bill Han


> You may consider sticking to Windows authentication and use OLE DB.
> You don't have to specify userID or Password.
> The connection then looks like
>     Set ADOConnection = New ADODB.Connection
>     ADOConnection.Open "Provider=sqloledb;Data Source=Bach;Initial
> Catalog=Revenue;Integrated Security=SSPI"
>     Set rs = ADOConnection.Execute(lstrSQL, , adCmdStoredProc)

> For more info, search for SSPI in Books On Line.



> > Hi everyone,

> > When I installed my MS SQL Server 2000, I used Windows authentication to
> > connect to SQL Server. Can I change it to SQL Server authentication? (I
> use
> > Windows 2000)

> > The reason I want to change it is that I want to use ADO to connect VB
and
> > SQL Server. ADO askes me to input UID and Pwd of SQL Server. I tried to
> use
> > Windows 2000's user name and password to connect VB and SQL Server, I
> > failed.

> > Does anybody have any suggestion for me?

> > Thanks,
> > Bill Han

 
 
 
Top

How to change authentication ??

Post by Bill » Sun, 04 Mar 2001 17:56:09


It's a big help,

Thanks,
Bill Han


> In order to change the security model... Go to SEM, right click your
server,
> go to the security tab, and select SQL Security... YOu must then bring SQL
> server down and back up..

> --
> Wayne Snyder MCDBA, MCSE, MCT, SQL Server MVP
> IKON Education Services, C*te, NC
> (Please respond only to newsgroups)


> > Hi everyone,

> > When I installed my MS SQL Server 2000, I used Windows authentication to
> > connect to SQL Server. Can I change it to SQL Server authentication? (I
> use
> > Windows 2000)

> > The reason I want to change it is that I want to use ADO to connect VB
and
> > SQL Server. ADO askes me to input UID and Pwd of SQL Server. I tried to
> use
> > Windows 2000's user name and password to connect VB and SQL Server, I
> > failed.

> > Does anybody have any suggestion for me?

> > Thanks,
> > Bill Han

 
 
 
Top

1. Can't change Authentication mode.

I can't change SQL 2000 Authentication mode for the life of me. It is
checked "Windows Only". When I check "SQL Server and Windows" then "OK", and
I close the window, and reopen the window, "Windows only" is again checked.
I have tried rebooting after I checked mixed mode, restarting the server,
standing on my head and yelling, nothing I can do will make the mixed mode
method remain checked! I can't do anything with this server unless I can get
it to work in mixed mode! Please help!

--
Thomas Colson
CCNA, MCP

(919)673-8023

2. Stored Procedure in OS/390

3. Admin question: cannot change authentication in EM

4. (PDXJOBS) Programmer RBA1149

5. How to change authentication ??

6. Foxpro Server using DDE

7. how to change authentication mode

8. How to detect TableA contain ColumnA?

9. I couldn't change authentication to mixed mode. Why?

10. Change MSDE authentication to mixed mode

11. change sqlserver authentication

12. Changing from SQL to Windows Authentication problem

13. Change Authentication Mode


All times are UTC
Board index