Mar 12, 2009 03:26 AM|plum|LINK
Problem solved...it turn out that in ASP.NET SQL server setup wizard when it asks for server name, I have to specifiy the
instance name as well as the server name when MS refer to "Server Name" they really mean "Server Instance Name") eg if your server was named 'bigturnip' then you need to specify 'bigturnip\sqlexpress' (where sqlexpress is the instance name
- this one just happens to be the default used by SQL Server 2005 SQLExpress). By default the server name was entered as merely "bigturnip" but after i added "\sqlexpress", then everything worked. If anyone else is having this remote connection problem and
when they did select remote connection and still does not work this is the way to solve the problem.....
This helped me greatly, Thanks!