Monday, June 23, 2008

Resolving issues in sql server & dream weaver

Steps For using CF8 libraries in DremWeaver8 editor


  1. Download dreamwwaver extension library from http://www.adobe.com/support/coldfusion/downloads.html#cfdevtools

  2. double click on the MXP fille

  3. if you open the dreamweaver editor, close it & open it again



SQL SERVER - Fix : Error : 40 - could not open a connection to SQL server.


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 default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 - could not open a connection to SQL server. )


Fix/Workaround/Solution:

1) Make sure SQL SERVER is up and the instance you try to connect is running.

2) Your system Firewall should not block SQL Server port.

3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration.Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.

4) Now follow this KB Article of MSDN depending on your server : http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277



For restoring database in sql server 2005


  1. right click on Databases in sql sever management studio express-restore database

  2. give database name in "To database"

  3. check radio button "from device" >> click on "_ _ _" >> click on "add" >> select the location of bak file & then click OK & again ok

  4. click on options in left menu >> change the path in "restore as" to the location where mdf & ldf files exists (make sure name doesnot in the specified folder )

  5. finally click on "OK"



Steps For using CF8 libraries in DremWeaver8 editor


  1. Download dreamwwaver extension library from http://www.adobe.com/support/coldfusion/downloads.html#cfdevtools

  2. double click on the MXP fille

  3. if you open the dreamweaver editor, close it & open it again



SQL SERVER - Fix : Error : 40 - could not open a connection to SQL server.


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 default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 - could not open a connection to SQL server. )


Fix/Workaround/Solution:

1) Make sure SQL SERVER is up and the instance you try to connect is running.

2) Your system Firewall should not block SQL Server port.

3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration.Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.

4) Now follow this KB Article of MSDN depending on your server : http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277



For restoring database in sql server 2005


  1. right click on Databases in sql sever management studio express-restore database

  2. give database name in "To database"

  3. check radio button "from device" >> click on "_ _ _" >> click on "add" >> select the location of bak file & then click OK & again ok

  4. click on options in left menu >> change the path in "restore as" to the location where mdf & ldf files exists (make sure name doesnot in the specified folder )

  5. finally click on "OK"



No comments: