The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
27 views

Install SQL Server 2012 missing vs_Setup.msi from Visual Studio 2010

I am trying to install SQL Server 2012 Enterprise with SQL Server Data Tools included. I understand that SQL Server Data Tools is part of what was formerly known as BIDS. The installation for SQL ...
0
votes
1answer
52 views

VS 2012 SSIS Data Flow Designer Source Assistant Error: [SSIS.Pipeline]: Component ", clsid {4CAC … Could not be created

I am creating my first SSIS package to support the E of our ETL from an external Oracle database to our internal SQL Server 2012 databse. Using Visual Studio 2012 and I have installed the Microsoft ...
1
vote
1answer
51 views

Is it possible to restrict SQL Server DB_Owner when connecting using SQL Server Mgt Studio? [duplicate]

Here is the back story. A developer created an EXE program. The exe program has the ability to access a SQL Servre database. In order to do that we create an Active Directory group. Let's call this ...
1
vote
1answer
262 views

SQL Server is configured to allow remote connections

I use SQL Server 2012 and SSAS Tabular Mode (My Instance Name Is MSSQLSERVER2012T) Then I download AdventureWorks Tabular Model SQL Server 2012 From This link I open it with Visual Studio 2010 and ...
0
votes
1answer
237 views

Support to SQL Server 2000 from Visual Studio 2013(SQL Server 2012)?

I can't access to a database created by SQL Server 2000 from Visual Studio 2013, I asked this before in StackOverflow, but I don't get an useful answer: ...
2
votes
1answer
159 views

VS2012 setup spoils SQL Server 2012 Data Tools for everybody or just me?

On Windows 7 Prof I have installed SQL Server 2012 R2 with, as I am pretty well remember, client tools. Then, I tried to install Visual Studio 2013 Ultimate but failed. Then I've installed VS2012 ...
1
vote
2answers
211 views

sqlpackage.exe ignoring BlockOnPossibleDataLoss?

I have a dacpac that has set the BlockOnPossibleDataLoss set to false, however the deployment is blocked when I run it with sqlpackage.exe, telling me "The column [a] is being dropped, data loss could ...
2
votes
1answer
69 views

Can I default to T-SQL only view in VS 2012?

When creating new tables in a database project in VS 2012, opened sql files default to a split view. One is the T-SQL text editor view, and the other is the Design view. I've never used the design ...
1
vote
2answers
399 views

Microsoft SQL Server how can i detach localdb to run on any computer

I am working on a personal project and have implemented a database system using the Entity Framework code first tutorial on msdn, link below, http://msdn.microsoft.com/en-gb/data/jj193542 I am ...
2
votes
0answers
229 views

SQL71561 Error on Schema compare after initial import from database

I have created a new sql server project with SSDT 2012, then I went to import an existing database and it created all my scripts. After that I did a schema compare between the project and the database ...