Problem on login SQL Server Management Studio

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Problem on login SQL Server Management Studio

Author

Topic

satimis
Starting Member

6 Posts

Posted - 2010-07-11 : 08:00:38

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

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-11 : 08:14:44

Sounds like the service isn't running. Check that the SQL service is started.

--
Gail Shaw
SQL Server MVP

satimis
Starting Member

6 Posts

Posted - 2010-07-11 : 09:08:42

quote:
Originally posted by GilaMonster

Sounds like the service isn't running. Check that the SQL service is started.

Hi Gail,

Start -> SQL Server Configuration Manager -> SQL Server Services

SQL Server (MSSQLSERVER)
SQL Server Browser
SQL Server Agent (MSSQLSERVER)

All are running.

Edit:

Where can I recheck the login name and password. Thanks

B.R.
satimis

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-12 : 01:24:51

If you're using windows authentication (which you state in the first post), the password isn't stored in SQL. SQL verifies your credentials from AD.

What does the error log say?

--
Gail Shaw
SQL Server MVP

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2010-07-12 : 04:13:25

Could you check the protocols are enabled - e.g Named Pipes , or tcp\ip . You will find this information in the SQL Server Configuarion Manager.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

sebantom1979
Starting Member

6 Posts

Posted - 2013-03-04 : 06:35:51

http://answerforu.com/2011/06/08/no-process-is-on-the-other-end-of-the-pipe-microsoft-sql-server-error-233/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources