Re: SQL 2008 remote Management Studio connection

BTW, can you recommend some good books for SQL 2008?

"Richard Lawson" <nospam@xxxxxxxxxx> wrote in message
news:uwV0pomdJHA.5344@xxxxxxxxxxxxxxxxxxxxxxx
I am not sure what I used to search. I started on Google and then went to
MSDN. Something like "SQL 2008 remote connection." Many thanks.

Rich Lawson, Application Developer, Phoenix


"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ucJOkGmdJHA.2096@xxxxxxxxxxxxxxxxxxxxxxx
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: Not allowed to switch authentication modes
    ... It would not be enough to set a password to make the "sa" Login work. ... And to be able to connect using "sa" account you must change the authentication mode to Mixed Mode from Windows Authentication. ... > uninstall the entire sql server, ...
    (microsoft.public.sqlserver.security)
  • SQL Service Pack doesnt upgrade SQL Server
    ... For the Authentication mode I used SQL authentication and gave the sa password. ... The server is a W2k Domain Controller on Windows service pack 3. ...
    (Focus-Microsoft)
  • newbie connection problem
    ... Authentication Mode = SQL, and ... On the server, I can connect to it fine, both via my app and the configure ... SQLState 8001 error 17: serber does not exist or connection denied. ...
    (microsoft.public.sqlserver.msde)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast