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 |
|
krajdba
Starting Member
43 Posts |
 Posted - 2008-04-23 : 09:17:39
|
| Hi I am trying to connect to SQL Server Managements Studio. However, I am encountering connection problems. Please help....Error...TITLE: Connect to Server------------------------------Cannot connect to MSSQL1.------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476------------------------------BUTTONS:OK------------------------------Raj. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 11:28:55
|
| Did you enable TCP/IP and remote connection? |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-04-23 : 17:52:49
|
| check your firewall settings |
|
|
|
krajdba
Starting Member
43 Posts |
Posted - 2008-04-24 : 03:29:39
|
| I enabled TCP/IP and Remote connection, after this I re-started the server. Now, sql server service not starting. Where to look for firewall settings....?Raj. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-04-24 : 04:30:01
|
quote:
Originally posted by krajdba
I enabled TCP/IP and Remote connection, after this I re-started the server. Now, sql server service not starting. Where to look for firewall settings....?Raj.
1.What OS are you using ?2.Do you have any antivirus ? and what version ?Try start >> control panel >> windows firewall |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-24 : 21:58:39
|
| Check windows app event log to find out why sql didn't start. |
|
|
|
monikad
Starting Member
1 Post |
Posted - 2012-05-29 : 02:39:49
|
| check whether your server name is in running or stopped in Sql Server Configuration Manager.If it is stopped then right click on it and say start.monika |
|
|
|
|
|
|
unable to connect TCP/IP error