Steps For using CF8 libraries in DremWeaver8 editor
Download dreamwwaver extension library from http://www.adobe.com/support/coldfusion/downloads.html#cfdevtools
double click on the MXP fille
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
right click on Databases in sql sever management studio express-restore database
give database name in "To database"
check radio button "from device" >> click on "_ _ _" >> click on "add" >> select the location of bak file & then click OK & again ok
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 )
finally click on "OK"
Steps For using CF8 libraries in DremWeaver8 editor
Download dreamwwaver extension library from http://www.adobe.com/support/coldfusion/downloads.html#cfdevtools
double click on the MXP fille
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
right click on Databases in sql sever management studio express-restore database
give database name in "To database"
check radio button "from device" >> click on "_ _ _" >> click on "add" >> select the location of bak file & then click OK & again ok
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 )
finally click on "OK"
No comments:
Post a Comment