September 28, 2010 at 3:52 am
Good day!
I am newly in SQL Server 2005 and now I encountered error when i try to login. This is some of the information:
Microsoft SQL Server 2005 Express Edition
Server Type: Database Engine
Servername:Servername\MSFW
Authentication:SQL Server Authentication
Login: sa
Password:xxxx
and when i press the connect button the error appear:
Error:
Cannot connect to Servername\MSFW
Additional Informations:
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may becaused by the fact that under the default settings SQL Server does not allow remote connections.(Provider:SQL Network Interfaces error:26-Error Locating Server/Instance Specified) (Microsoft SQL Server).
I have no idea how i can solve this problem..
Any help is highly appreciated..
Thank you in advance.
October 28, 2010 at 11:12 am
I understand that servername is not your local machine?
You have to log on to the server and run SQL Server Surface Area Configuration tool. There in Surface Area Configuration for Services and Connections you have to enable remore access.
How to configure SQL Server 2005 to allow remote connections
Regards
Piotr
...and your only reply is slàinte mhath
October 28, 2010 at 11:32 am
You'll also need to go to server configuration for the SQL Service and make sure the connections allow TCP/IP or Named Pipes, instead of just shared memory. SQL Express usually only allows shared memory.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 5, 2011 at 1:48 am
Hi,
Prior to connect the SQL Server, go to SQL Server Configuration Manager, Click on Protocols for MSSQLServer and Enabled TCP/IP and put port whichever you want. by Default it is 1433. Then you try.
Regards
Palash Gorai
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply