starting SQL

This OUGHT to be the easiest thing in the darned world. I am on my third install of MS SQL (2005). After the install, everything runs fine for a few days, then the automatic start up (connect) stops working and I am unable to restart it.. until I re-install MS SQL. As of now, my best guess is that this may have something to do with a Norton Antivirus / AntiSpyware full scan being run?? This is the only thing I can think of....

So, what the heck is going on here? Why is it disconnecting? Why can't I re-connect? Is this a common problem??? if so, how on earth does anyone develop software for it??

Right now I am deeply frustrated with this product. Anyone with any advise is appreciated.

This is the error message I get.

TITLE: Browse Server for Database
------------------------------

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ken Barrett18y ago
Thanks, and yes I did run the surface configuration tools giving myself permission to develop the databases... and it was working. I'll take a closer look at Norton and see what I can find.

Thanks again.
0
Scott Lysle18y ago
It could be Norton; I don't use norton but I assume they have a control panel that will allow you to block or allow access for applications. You might want to look at that to see what is set up there. I also assume that your ran the 2005 surface area configuration tool to setup the features that you need for your development work.
0