enable remote connection for sql sever 2008 R2

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)

enable remote connection for sql sever 2008 R2

Author

Topic

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-04-15 : 13:38:36

How to enable remote connection for sql server 2008 R2 on windows 2008 64 bit. There is no surface area configuration in 2008. Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-15 : 14:04:38

It's almost certainly already enabled. Are you thinking you need to enable it based upon an error? If so, you should read this: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

To answer your question though, here you go: http://forums.asp.net/t/1338911.aspx/1?how+to+enable+remote+Connection+sql+server+2008

I got that link by a very quick google of your problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-04-15 : 15:03:48

Thanks tara. I was looking for surface area configuration as in 2005 but I did not find. This is new installation.

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-04-15 : 15:08:02

Another thing. Do we need to install CU6 right now after installation of 2008 r2 or it is not necessary. Client said we can install it later on.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-15 : 15:16:34

Whether or not you install it is not something I can answer for you. Some companies do not trust CU's as they aren't tested as much as service packs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-16 : 01:28:20

CUs are for specific machine and customers request to microsoft so wait for Service Pack

There is no any Surface Area configuration in SQL Server 2008,this is depreciated in it

What do u mean by remote connection,you mean DAC ,if you want to use DAC then use SQLCMD

If you cant connect remotely to the SQL Server Instance then check firewall on both node

If you have named instance with different port then you should connect as

SERVERNAME\INSTANCENAME,1435
or
SERVERIP\INSTANCENAME,1435

you don't need to define the port on the server where SQL Server binaries exist means SQL Server installation in the connection

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-16 : 12:29:32

CUs are not specific requests. They are cumulative updates that contains lots of bug fixes.

We do not wait for service packs at my company.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-17 : 08:22:48

visit this link what is microsoft saying regarding CUs

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2489376&kbln=en-us

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-17 : 12:10:03

I know exactly what they say. My point is that they are cumulative. When you install them, you get numerous bug fixes and not a specific one. For a specific one, you have to install the QFE.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources