Hi, I have an issue with ASP.NET 2.0 and SQL Server 2005
My project when hosted in a machine its working, but in case of some other machine it is throwing the following error
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I have turned off my firewall and network configuration for sql server and its also done as tcp/ip and named pipes…though it is not working …The surprise is if I run using IDE its running , in the same machine after hosting it is not running, where the db is in another machine. What could be the problem? Any suggestions would be highly appreciated. Regards,Naveen
Regards,
Naveen
This is usually issue with user name, password and permissions.
First did you check your connection string? You need to change server name.
Second, are you using Windows authentication or mixed mode in your SQL Server?
|||Thanks millet, it worked when I changed the permission
|||Hi Naveen,
Can u pls. post the changes you made. because i'm also getting this error.
No comments:
Post a Comment