i am using VS05 and sql05express. After I created a new web application i want to add a database. But when I do so i got the following message:
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 the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
is anybody know what's wrong here? what should i do? thx
This error has been asked many times on the forum
Firstly you should ensure you have enabled remote connection of the SQL Express from 'SQL Server Surface Area Configuration'; then enable TCP/IP and Named Pipe protocol on both Server and Client side in 'SQL Server Configuraiton Manager'. After that, if you still have problem, you should check your conneciton string.|||thank you very much, now i am all set to go
No comments:
Post a Comment