July 11, 2010 at 7:55 am
Hi folks,
Windows server 2008 R2 Enterprise 64 bit
SQL server 2008 64 bit
This is a newly installed box.
Start -> SQL Server Management Studio
SQL Server can be login with following settings;
Server type: Database Engine
Server name: (local)
Authentication: Windows Authentication
User name: WSER2008R202\Administrator (greyout)
Password: (greyout)
But I can't login with;
Authentication: SQL Server Authentication.
The login name and password taken down during installation can't work.
On the drop-list of Server name:(local)/(local)/<Browse for more ....>
Local Servers - Empty
Network Servers - (... Retrieving data)
Database Engine
-> WSER2008R202 (10.50) (highlight it) -> OK
login: administrator
Warning:-
TITLE: Connect to Server
------------------------------
Cannot connect to WSER2008R202.
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
On SQL Server Management Studio
Right click "server" -> Properties -> Connection
(check) "Allow remote connection to this server"
Please help. TIA
B.R.
satimis
July 11, 2010 at 8:24 am
I don't think that this is the error you get when SQL authentication is turned off. If you check on the Security tab of the Properties for this SQL Server, is the radio button set to Windows and SQL Authentication?
Is this a local instance of SQL Server? Meaning, are you logging into a SQL instance running on the machine where SSMS is running?
Firewall perhaps?
July 11, 2010 at 10:05 am
Steve Jones - Editor (7/11/2010)
I don't think that this is the error you get when SQL authentication is turned off. If you check on the Security tab of the Properties for this SQL Server, is the radio button set to Windows and SQL Authentication?Is this a local instance of SQL Server? Meaning, are you logging into a SQL instance running on the machine where SSMS is running?
Firewall perhaps?
Hi Steve,
Thanks for your advice.
I found out the cause. The login should be "sa" NOT "administrator" nor "Administrator" nor "WSER2008R202\Administrator"
B.R.
satimis
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply