Hi
I am trying to make a backup of my SQL server 2005, used with Web Developer 2005 Express, in osql.exe (can't find any other way of doing it). I get the error that "under the default settings SQL server does not allow remote connections".
I connect to it fine from the Web Developer 2005 and my application . I followed another post's instructions where I enabled the TCP/IP and named pipes for "Protocols for SQLEXPRESS", but didn't work. In fact when I changed TCP/IP properties/ IP Addresses/TCP Dynamic port to nothing , and TCP Port to 1357, the server wouldn't start again !! (not doin THAT again)
Regards
Amanda
Godditt !!!!
I needed to enable the SQL Server Browser service, found in article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Thanks...
No comments:
Post a Comment