Can anyone help unlock SQL?

I'm a newcomer to SQL2005 Express and have a problem on my local machine after FTP'ing my database todiscountasp.

When I go to the database explorer (MS Visual Web developer express) - there is an icon of a databse with what appears to be a mains cable coming from it (it never used to be there). This now appears to be preventing meapplying updates/inserts etc to any of my databases.

I have detached all of my databases, used 'app_offline' and even re-installed SQL Server Express and Visual Web Developer 2005 Express.

But it is still there and I cannot pathom how to clear this problem.

Can anyone help me (please bear in mind that I am a beginner)?????

Many thanks in anticipation......

 

Have you tried to stop the service from the SQL Configuration Manager?
(It should be listed under Configuration tools, in the Start menu program group.)

 

Whats the error message you getting?

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Good job on the image, that sort of thing helps a lot.

As for the disabled generation options, it won't let you have access to those until you create a primary key on the table.
Until you do it considers the table naked, well, OK, I made up the naked part just to be funny.

 

Many thanks Wisemx - it works!


But I do have another problem - pls could you help me with this one as well?


I have moved & renamed by files on the local machine and now get the following error when I try to view the application in the browser:
The resource cannot be found.


Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /PeriodEnd/default.aspx

I've spent a few hours now looking on the web and have seen articles that talk about IIS and removing a '/' - but I have XP home edition - and I cannot find IIS !

Do you have any idiot-proof directins for me?

Many thanks for your help

 

Many thanks for the replies so far...


I have restarted the SQLExpress and SQL Explorer, but it has not made any difference. There are no error messages.


When I create a new table, it does not allow me to specify updates etc, but it will let me specify updates on tables that existed before the problem.


I have attached a paint.bmp to show the icons with the broken powerlead symbol (no. 1 in .bmp)


(2) SQL config manager, showing what is running


(3) trying to select updaes on a new table.


Thanks for your thoughts so far, do you have any further suggestions?

 

are you using vs.net development web server or pws?

Post Edited By Moderator (bruce [DASP]) : 2/26/2007 11:08:35 PM GMT