Re: How to login in MsSqlServer
From: BP Margolin (bpmargo@attglobal.net)
Date: 08/07/02
- Next message: BP Margolin: "Re: Stop the SQL admin"
- Previous message: Joe: "Re: How to clone the properties of roles from one server to other server?"
- In reply to: kentersoft@sina.com: "How to login in MsSqlServer"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Wed, 7 Aug 2002 01:01:10 -0400
I would take a guess that you have SQL Server in Windows Authentication mode
rather than Mixed Authentication mode.
To alter this, without having to login, check out:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q285097
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
<kentersoft@sina.com> wrote in message
news:11de01c23d2d$2f81e5e0$3bef2ecf@TKMSFTNGXA10...
> Hi:
> I disable administrator and BUILTIN\administrators's
> access right, only the sa have login access, Now I can't
> login in to the server, can help me.
> Another when develop internet problem, if i don't add
> iUsr_MachineName to the Sql Server account, i want to use
> Sql validate the user, how to set.
> Thanks!
>
- Next message: BP Margolin: "Re: Stop the SQL admin"
- Previous message: Joe: "Re: How to clone the properties of roles from one server to other server?"
- In reply to: kentersoft@sina.com: "How to login in MsSqlServer"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
