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.
Author |
Topic |
satimis
Starting Member
6 Posts |
Posted - 2010-07-11 : 08:00:38
|
Hi folks,Windows server 2008 R2 Enterprise 64 bitSQL server 2008 64 bitThis is a newly installed box.Start -> SQL Server Management StudioSQL Server can be login with following settings;Server type: Database EngineServer name: (local)Authentication: Windows AuthenticationUser 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 - EmptyNetwork Servers - (... Retrieving data)Database Engine-> WSER2008R202 (10.50) (highlight it) -> OKlogin: administratorWarning:-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 StudioRight click "server" -> Properties -> Connection(check) "Allow remote connection to this server"Please help. TIAB.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 ShawSQL 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 ServicesSQL Server (MSSQLSERVER)SQL Server BrowserSQL Server Agent (MSSQLSERVER)All are running.Edit:Where can I recheck the login name and password. ThanksB.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 ShawSQL 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/ |
|
|
|
|
|