Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2007-04-26 : 07:22:26
|
| Hello,I created a database name dbBA and I was seeing it on my Microsoft SQL Server Management Studio. However, now I can't see it. I can see the System Databases, Adventure Works database, etc but not my database.So I though it was maybe deleted and I tried to create a new one with the same name. It says it already exists.Finally I opened the Query Window and I tried:DROP DATABASE dbBAI got an error. I think this should be used only inside a database since I need to select a database.Anyway, could somebody help me out in understanding why did I stoped seeing my database when it seems that ti exists?Thanks,Miguel |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-26 : 07:24:26
|
| Have you created database on local machine or some other machine connected to network? Also do you have named instance of SQL Server on your machine? in the form of ServerName\InstanceName?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
shapper
Constraint Violating Yak Guru
450 Posts |
Posted - 2007-04-26 : 07:44:20
|
Hi,I will try to answer your questions.quote:
Have you created database on local machine or some other machine connected to network?
I am using my computer. It is not connected to any network.I created it locally. Note that I was seeing the database and I even created some tables and installed the Asp.Net 2.0 Membership tables using ASPNET REGSQL. Now that tool does not identify my table. It has all tables in the list but not mine.quote:
Also do you have named instance of SQL Server on your machine? in the form of ServerName\InstanceName?
When I connect to server the windows shows:Server Name: SHAPPER (It is the only one I have an always used)Authentication: Windows AuthenticationUsername: SHAPPER\Miguel (This is disabled since I am using Windows Authentication)My computer has only one user (Miguel) and this is the current user.What should I do?Thanks,MiguelHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
nduggan23
Starting Member
42 Posts |
Posted - 2007-04-26 : 07:57:21
|
| Does the User account have full system admin access? and did you create the table as SA by any chance? The user may not have permissions to view the db.... |
|
|
|
shapper
Constraint Violating Yak Guru
450 Posts |
Posted - 2007-04-26 : 09:38:34
|
quote:
Originally posted by nduggan23
Does the User account have full system admin access? and did you create the table as SA by any chance? The user may not have permissions to view the db....
How can I check if the user account has full system admin access.I am using Windows XP Professional with IIS.The only user I have is my computer is listed as Computer Administrator.what is strange is that I created the database and was able to see it for a few days always with this user. Now I stopped being able to do that. I didn't do anything to it. Can this be due to some SQL 2005 update which my Windows Update made or because of VS 2005 SP1 installation?Thanks,Miguel |
|
|
|
shapper
Constraint Violating Yak Guru
450 Posts |
Posted - 2007-04-26 : 11:43:55
|
| Hello,I just solved it. I deleted the .mdf files from SQL directory and created the database again. Now it is working and accessible.I believe the problem had something to do with the SQL and VS2005 updates I made.Thanks,Miguel |
|
|
|
|
|
|
|
|
Database Problem