This is one of the most frequently asking question on sql/asp fourms.
Reasons for this error:
- Make sure your connection string data are correct and only that particular string is you calling.
- You need to enable the listener on port 1433 in the SQL Server Configuration Manager control panel
- Enable the "sa" user. It's disabled by default after the install.
- Set a password on the "sa" user.
- Enable SQL Authentication + NT Authentication mode.
- Make sure the Windows firewall isn't blocking port 1433.
- Try the default instance name instead of SQLEXPRESS.
- Make sure the remote connection is using TCP/1433
If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)
No comments:
Post a Comment