Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot connect to Sql Server database: non-system databases are not shown

I'm trying to connect to SQL Server 2008 express database from Visual Studio 2010 using data connection wizard. I choose new connection -> MS Sql Server then I choose the only available server name (PAVEL-PC\SQLEXPRESS). The problem is i cannot see my database in the combobox below. System databases (like master, model, msdb etc) are shown though. I've managed to find similar questions (like this one: Cannot connect to SQL Server database in Visual Studio because my database isn't there) and it seems I'm having permission issues. However I cannot understand which user (and where) should I add.

The account name which I'm running my Visual Studio on is Pavel. My computer name is Pavel-PC. I'm not sure what my SQL Servers account names are, but it was installed using default settings.

like image 420
Pavel Murygin Avatar asked May 13 '11 17:05

Pavel Murygin


1 Answers

Here is the answer to my question:

use "PAVEL-PC" instead of "PAVEL-PC\SQLEXPRESS"

like image 80
Pavel Murygin Avatar answered Oct 02 '22 21:10

Pavel Murygin