SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 enable remote connection for sql sever 2008 R2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Peter99
Constraint Violating Yak Guru

494 Posts

Posted - 04/15/2011 :  13:38:36  Show Profile  Reply with Quote
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

USA
37133 Posts

Posted - 04/15/2011 :  14:04:38  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

Peter99
Constraint Violating Yak Guru

494 Posts

Posted - 04/15/2011 :  15:03:48  Show Profile  Reply with Quote
Thanks tara. I was looking for surface area configuration as in 2005 but I did not find. This is new installation.
Go to Top of Page

Peter99
Constraint Violating Yak Guru

494 Posts

Posted - 04/15/2011 :  15:08:02  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 04/15/2011 :  15:16:34  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

Jahanzaib
Posting Yak Master

Pakistan
115 Posts

Posted - 04/16/2011 :  01:28:20  Show Profile  Visit Jahanzaib's Homepage  Reply with Quote

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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 04/16/2011 :  12:29:32  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

Jahanzaib
Posting Yak Master

Pakistan
115 Posts

Posted - 04/17/2011 :  08:22:48  Show Profile  Visit Jahanzaib's Homepage  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 04/17/2011 :  12:10:03  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000