Re: SQL 2008 remote Management Studio connection

It is documented in Choosing an Authentication Mode http://msdn.microsoft.com/en-us/library/ms144284.aspx
and How to: Change Server Authentication Mode http://msdn.microsoft.com/en-us/library/ms188670.aspx
I'm always looking for ways to make key information more discoverable. Perhaps I should add more indexing. What words were you searching on?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Richard Lawson" <nospam@xxxxxxxxxx> wrote in message news:%23WyqgSddJHA.556@xxxxxxxxxxxxxxxxxxxxxxx
Wow. That was so easy. I never would have found that the sa account was disabled. I have been search MSDN since yesterday but never saw this documented, which I am sure it is.

Tnx.

Rich Lawson, Application Developer, Phoenix


"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E8B9378F-6499-4317-9E7B-4FC28BAC4991@xxxxxxxxxxxxxxxx
Is the server in Mixed mode? To find out:
1. Connect using Management Studio using Windows Authentication.
2. In Object Explorer, right-click the server name and then click Properties.
3. On the Security tab, is SQL Server and Windows Authentication mode selected?
Have you restarted SQL Server since changing this?
If the server was installed in Windows Authentication mode, and then changed to SQL Server and Windows Authentication mode then the sa account was disabled. If you are trying to connect with the sa account it must be enabled and assigned a password.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Richard Lawson" <nospam@xxxxxxxxxx> wrote in message news:uPt8ilcdJHA.3948@xxxxxxxxxxxxxxxxxxxxxxx
I cannot connect remotely to SQL 2008 Server using Management studio using SQL Server authentication. It does work with Windows Authentication. Also, I cannot connect to SQL 2008 Server using a remote application and SQL authentication.

The same process works fine with the SQL 2000 Servers.

Tnx

Rich





.

Relevant Pages

  • Re: problem with connecting to sql server via a wireless applicati
    ... Yes since I cant pinge the server IP from the device I need to investigate ... Also I can't change from Windows authentication to mixed mode to allow both ... Visual Studio 2005 and it doesn't have SQL Server Management Studio. ... to port 1433 and changed the connection string to the suggested format. ...
    (microsoft.public.sqlserver.clients)
  • Re: Authentication
    ... If you install SQL Server in Windows Authentication Mode, then change to Mixed Authentication Mode, the sa account is disabled. ...
    (microsoft.public.sqlserver.connect)
  • Re: OK - Im stupid....How do you create a user?
    ... not a Windows login, you'll need to change the authentication mode SQL ... Server uses from "Windows Authentication" to "SQL Server and Windows ... Windows authentication mode if at all possible. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows authentication from ASP.NET to SQL Server
    ... > our intranet server and our database server, both of which are on our ... > Windows authentication works for our intranet server - my domain user ... Permissions on the SQL Server are ... > Successful Network Logon: ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Single Sign on
    ... Is you server and users in a domain configuration? ... do is create an NT global group that contains your user accounts. ... This is SQL Server Windows Authentication model and only ...
    (microsoft.public.sqlserver.setup)
Loading