How do you log on as SA???? -- sql server (alternate)

froliol NO[at]SPAM yahoo.com
8/13/2003 10:36:45 AM

[quoted text, click to view]

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.

bjzamora NO[at]SPAM hotmail.com
8/13/2003 10:49:53 AM

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

[quoted text, click to view]

aaronharclerode NO[at]SPAM yahoo.com
8/13/2003 12:56:55 PM

[quoted text, click to view]

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

Richard Holliingsworth
8/13/2003 2:26:23 PM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (alternate)

sql server (alternate) : How do you log on as SA????