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 |
|
satya068
Posting Yak Master
233 Posts |
 Posted - 2010-03-19 : 06:10:17
|
| Hi..could anyone able to sort this problem.what i amm trying to do is i am copying PAS_RDB from MRD-SQL-BOLT into NEW SERVER MRD-SQL-BOREP WHEN I AM LOGGING INTO SQL2005 WITH WINDOWS AUTHENTICATION in my local machineServer Name:MRD_SQL_BOREPAuthentication:WINDOWS AUTHENTICATION ERRORMESSAGE'An error occured while eastiblishing 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'.when i loginto the server MRD-SQL-BOREP THERE I OPEN SQL2005 AND LOGIN WITH WINDOWS ANTHENTICATION its work fine. why i am not able to login through my local machine?thanx but when i am trying to login to sql2005 from local machine why the above error is comming. |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-03-19 : 16:51:39
|
| You need to open the server for remote connections, using the SQL Server Surface Area Configuration Tool.Login to the server using an admin account, and go to:Start --> Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Surface Area ConfigurationWhen the tool opens, click on "Surface Area Configuration for Services and Connections". In the tree view control, locate the correct server instance, then click on Database Engine --> Remote Connections. Select "Local and remote connections", the appropriate protocol, and click Ok.There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
|
|
|
SQL Connection Error