开发者

SQL Server database is not visible

开发者 https://www.devze.com 2022-12-11 19:11 出处:网络
I have installed ASP.NET application with database on our server. ASP.NET application created database using connection string below. The problem is that I do not see database in SQL Server Management

I have installed ASP.NET application with database on our server. ASP.NET application created database using connection string below. The problem is that I do not see database in SQL Server Management Studio. I use "Windows Authentication" account to login to SQL Server. How to solve this problem? Also I see two sqlservr.exe instances in process manager.

server=(local)\SQLEXPRESS;d开发者_运维技巧atabase=bugs;Integrated Security=True;Connect Timeout=30;User Instance=True


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.


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


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消