How do you log on as SA????

[Richard Holliingsworth]

Hello:
I'm a FoxPro developer setting up my first SQL Server (7.0) app. and I
need to ask how to log on as SA? I guest this sounds stupid, but when I
created the logons for the group, I set them up as "Windows
Authentication" and now the logon happens automatically when I start
Enterprise Manager so I never get a chance to logon as something else.

Is there a way to force Enterprise Manager to let me log on as SA?

Thanks,
Richard

[Louis Frolio]

Richard Holliingsworth <wi*********************@boeing.com> wrote in message news:<HJ********@news.boeing.com>...

Hello:
I'm a FoxPro developer setting up my first SQL Server (7.0) app. and I
need to ask how to log on as SA? I guest this sounds stupid, but when I
created the logons for the group, I set them up as "Windows
Authentication" and now the logon happens automatically when I start
Enterprise Manager so I never get a chance to logon as something else.

Is there a way to force Enterprise Manager to let me log on as SA?

Thanks,
Richard

Enterprise Manager / SQL Server Group / local (sql server)

right click on sql instance and choose the security tab. you will see
what you need to change.

L

[xAvailx]

Richard,

Just change your SQL Server Registration.

In Enterprise Manager go to >> YOUR SERVER >> Right Click, Edit SQL
Server Registration >> Change it from SQL Server Authentication to
Windows Authentication.
Then try connecting again.

HTH,

BZ

Richard Holliingsworth <wi*********************@boeing.com> wrote in message news:<HJ********@news.boeing.com>...

Hello:
I'm a FoxPro developer setting up my first SQL Server (7.0) app. and I
need to ask how to log on as SA? I guest this sounds stupid, but when I
created the logons for the group, I set them up as "Windows
Authentication" and now the logon happens automatically when I start
Enterprise Manager so I never get a chance to logon as something else.

Is there a way to force Enterprise Manager to let me log on as SA?

Thanks,
Richard

[AaronH]

Richard Holliingsworth <wi*********************@boeing.com> wrote in message news:<HJ********@news.boeing.com>...

Hello:
I'm a FoxPro developer setting up my first SQL Server (7.0) app. and I
need to ask how to log on as SA? I guest this sounds stupid, but when I
created the logons for the group, I set them up as "Windows
Authentication" and now the logon happens automatically when I start
Enterprise Manager so I never get a chance to logon as something else.

Is there a way to force Enterprise Manager to let me log on as SA?

Thanks,
Richard

Not sure if it works the same way in 7.0, but in SQL Server 2000 you
can just change the authentication scheme to "Mixed Mode."
(right-click the server in Enterprise Manager, select properties, and
go to the Security tab. On the security tab, select "SQL Server and
Windows Authentication") Afterwards, you'll be able to use either a
Windows account or SQL account.