ansaurus

Question

Answer 1

A:

Make sure you're connecting to (local)\SQLEXPRESS instance and not to the default instance.

Patonza 2009-11-16 13:19:41

Answer 2

A:

Where is the stored procedure that created the database? Just because there is a connection string does not guarantee that there was a database created.

Woot4Moo 2009-11-16 13:19:50

Database was created and my ASP.NET application use it succesfully.

Tomas 2009-11-16 13:27:21

Answer 3

+1 A:

You won't see databases created with "User Instance=True" unless you login as the exact user the database was created under, and the database has been attached.

Given that if ASP.NET created the database it's likely it was created by Network Service then you are not going to see it at all. Whilst you could manually try to attached it as a user instance yourself, you may well end up messing up the permissions or hitting the "database already exists" problem.

blowdart 2009-11-16 13:22:13

Didn't know about user instances. Thank you :)Here's a technical article describing this feature: http://msdn.microsoft.com/en-us/library/bb264564(SQL.90).aspx

Patonza 2009-11-16 13:26:16

Exactly, it was created by Network Service(ASP.NET). I need to back-up it, how to do that?

Tomas 2009-11-16 13:29:08

You need to find out where the file *is* (probably in the App_data directory of your web application), then simply copy it after shutting down that web application.

blowdart 2009-11-16 13:38:18

The database was created using SQL script by application, it's name is "bugs", I have tried to search for files *.MDF and files which was found do not match my database.

Tomas 2009-11-16 13:48:02

And how do you know they don't match? With user instances they can end up *anywhere*. Normally the connection string specifies a path with AttachDbFileName=, otherwise it may be in :\Documents and Settings\<UserName>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS, or in the Network Service case perhaps under \Public\Local. You, as a normal user, may not even have access to it.

blowdart 2009-11-16 14:12:24

Yes, files are here, they are hidden and windows search didn't found them. I will take files and create new database with my mssql server account and change connection string in my asp.net application. Thank you for your help!

Tomas 2009-11-16 14:31:48

ansaurus

tags:

views:

answers:

SQL Server database is not visible

related questions