February 25, 2009 at 2:50 pm
I am using Visual Web Developer 2008 Express and I have a number of applications I have started to develop just to see what the commands do and to follow tutorials. A lot of them have the Data Connections Ikon and an ASPNETDB.MDF with its yellow can to its left. In all applications every .mdf file has a red x at its lower right corner and in all cases I get the above message printed when I click on the expansion button to its left.
Something, somehow or other, in my computer has been inadvertently changed. What is it?
Where is it? In the IIS? where is it.
If repairing this situation requires the sp_configure command, please say where to type it or where to find it. I need the name of the application- VWD 2008 Express, MSFT Visual Studio, what is the name. What do I pull down on the main menu. Which item do I select? There are a ton of sp_configure comments in forums and none of them say where I should write or find sp_configure. I've written it in the black window that comes up with the run command and it says it never heard of the command.
If it was so simple to inadvertently turn whatever it is off, it should be just as simple to turn it back on. I can't do any SQL Server development until I get the thing turned back on.
Many thanks.
March 15, 2009 at 1:20 pm
The database has to be attached to SSE before it will work. You normally attch a database with a connectionString. Are your connectionStrings in order?
Is SSE running? Check the Configuration Manager and make sure it's running.
If you have a red X on the yellow database can, try right-clicking the database and in the dropdown menu, click Attach" and then see if you can open the database from "Database Explorer" and read the contents of a table.
When you installed SSE, did you configure to disable user instance?
If user instances are truly disabled in SSE, you will need to reconfigure sSE to enable user instances. I don't think this is the case if you didn't run any commands to disable user instances.
April 20, 2009 at 1:37 am
wht is SSE
April 22, 2009 at 6:27 pm
SSE = SQL Server Express
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply