Friday, March 23, 2012

how to register a table

I was advised to use a table in addition to the standard aspnet_ tables for keeping extra data and to register it with the rest of the database. However, when I tried to register it, I couldn't even see a database to choose from then received an error. All the tables, including the ones I created, work when I run my VSE 2005 project. If someone can give me some A-B-C guidance, I'd appreciate it.

ur query is not clear, give some of ur working example...

|||

I'm not sure how I'd give a working example since the question has to do with a database and there's not much I can show. I run aspnet_regsql so I can add a table to the standard aspnetdb.mdf. When I try to see what databases are available from the wizard that runs, I get the error "Connection failed to query a list of database names from the SQL server." On the other hand, when I use the <default> database shown in the wizard, I get the message "Setup failed. Exception: Unable to connect to SQL Server database"

This problem is quite common, I'm sure, and I don't know what other information I can give, except that I obviously need to somewhere insert a missing step that I've omitted. Do I need to run aspnet_regiis or something? I do this and only get a list of all the different options.

|||

OK, I think I'm good now. Upon reading through some more posts regarding this problem, I picked up that I needed to write \sqlexpress after the server name. Problem solved.

No comments:

Post a Comment