Re: Cannot connect using sa

Hi All,

I had the same problem and I fixed it by enabling "SQL Server and
Windows Authentication Model"

Now I can connect by using SQL Server Management Studio Express in
local, but when I try to remote connect by using SQL Analyzer I get
error 18456.

Well, I am using a new user called 'test' for connecting SQL server. I
don't know the 'sa' password and i am confident about if it is a good
idea to change the 'sa' password.

Is 'sa' used by the system is some way?

The server is not in either: the local network, workgroup nor domain.
Therefore i am using SQL Authentication for login.

I am connecting by typing just the server IP address. It means that I
am not using the instance name (SQLExpress) at all. is that correct?

Since I can connect the SQLServer but the user is being refused, from
my point of view the problem could be:
- SQL Authentication has not been property activated for remote access
- Remote connection is not accessing to the correct instance:
SQLExpress (The only one)
- The user 'test' had not been property initialized.

Obviously I am beginner and I would appreciate you help very much.

Thanks in advance.
Diego

.

Relevant Pages

  • Re: Cannot connect a remote sql server
    ... I too have written quite a bit about connecting. ... Hitchhiker's Guide to Visual Studio and SQL Server ... such as the server's firewall, SQL Server's remote connection setting, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Connecting to MS SQL Express from other PC
    ... "Mixed mode" authentication enables SQL Server authentication AND SSPI (Windows domain) authentication. ... I also have a long whitepaper on connecting on my blog. ...
    (microsoft.public.sqlserver.connect)
  • connecting to sql remote database
    ... i am able to connect to remote sql server ... using windows authentication. ...
    (microsoft.public.sqlserver.connect)
  • sql server remote connection
    ... > change it to administrator account, i am able to connect to remote sql server ... > using windows authentication. ...
    (microsoft.public.sqlserver.clients)