Friday, March 9, 2012

help! backing up sql server 2005 using osql.exe

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