Questions tagged [sql-server-express]
37 questions
20
votes
2 answers
How to install SQL Server 2016 on Windows 7
I know it's clearly stated in System Requirements that Windows 7 is not supported. But I'm sure that these limitations are artificial to force users to buy newer versions of Windows. And also as I suppose there is no serious changes in system core.…
5
votes
3 answers
Can I install Microsoft SQL Management Studio by itself?
I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008.
Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't install it without installed the SQL Server by…
5
votes
0 answers
How to access to a SQL Server Instance from a WSL2 Debian System?
I would like to connect from my WSL 2 Debian System to a SQL Server instance. This is because I want to develop an cossplatform app in Python and make some tests.
WSL 1
As far as I know with WSL 1 I just have one adapter that is share between host…
ChesuCR
- 201
3
votes
2 answers
How do I connect to an MS SQL instance on AWS?
I've taken these steps:
Created an AWS account
Spun up an MS SQL Server Express instance
Added a security group for TCP 1433, my IP, prefix 32
Added forwarding for my home firewall, for port 1433, to my dev computer
Using SQL Management Studio on…
user49214
3
votes
1 answer
How to copy multiple SQL Server Management Studio Express result tables at one time?
I have a query that spits out multiple result tables and I want to be able to select all of the tables at once, hit copy and then paste them all to one Excel file all at the same time. I would also be ok with exporting, if someone knows how to do…
tarheel
- 423
2
votes
1 answer
Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See
My computer has the following Software involved.
Microsoft Windows 7
Microsoft SQL Server 2008 R2
Microsoft SQL Server Management Studio
Moreover, I have the following Drive partitions:
C: drive
D: drive
E: drive
Therefore, when I created the…
user1338998
- 259
- 1
- 9
2
votes
2 answers
Configuring VM with SQL Express to be accessed using SSMS from host
I'm trying to configure my VM with SQL Server 2008 R2 Express so that I will only be able to remotely access SQL using SQL Server Management Studio from host machine.
VM configuration
running Windows Web Server 2008 R2
There are two NICs:
Bridged…
Robert Koritnik
- 2,096
1
vote
1 answer
Why can't I connect to my local SQL Server Express (2014)?
After I installed Microsoft SQL Server Express (2014) on my local computer (for testing while building a web interface which uses databases), I could connect just fine, but for some random reason, now (after I've finally gotten the .mdb files…
VoidKing
- 345
1
vote
2 answers
How can I convert MS Access 2003 (2000 file format) to Sql Server Express 2014?
I've been searching for the past two days on how to get this conversion done, but every suggestion I've seen yields no effective results.
I've installed Sql Server Express 2014 and have verified that I can log into it successfully.
Here is what I've…
VoidKing
- 345
1
vote
3 answers
How to stop and start or restart background processes while restarting laptop
I am facing an issue on my laptop which is installed with windows 8.1
When ever i turn ON my Windows 8.1 laptop, I can instantly login with my password, as I would expect.
However, if I use my PIN instead, the system mostly freezes for about one…
Srinivas
- 23
1
vote
1 answer
Missing arguments in SQL 2012 command line installation
I am new to SQL installation through command line.
We are developing an application and using Installation Shield.
I need to install SQL server on clients pc, so I am using command line silent installation of SQL.
Problem is only MS-SQL…
Vikram Singh
- 405
1
vote
3 answers
SQL Server Express while attaching a database getting error 5120
I have SQL Server Express installed on my local machine. When I try to attach a database file, it's giving me the following error
Unable to open physical file "C:\Adventures2012_data.mdf. Operating system error 5: 5 (Access is denied) (Microsoft…
Sohail
- 391
1
vote
1 answer
SQL Server Express "hangs", on startup
I recently installed SQL Server 2012 "Express", and, also, Visual Studio 2012.
I was working with it, and all worked ok.
At some point, a few hours ago, SQL Server Express, however, started "hanging", on Startup. I have tried uninstalling, and,…
user2606742
- 133
1
vote
1 answer
SQL Login fails for app but not for SSMS
I wrote a simple test application in C# (4.5) which does nothing more than connect to a database and display a message. (Basically just to test the deployment and DB connection.) On my local workstation everything works fine. I installed SQL…
David
- 858
1
vote
1 answer
Installing Visual Studio's SQL Server express later
I installed VS2010 Ultimate while ago whithout installing SQL Server Express. I also installed SP1 and Lightswitch over it.
Now I changed my mind. I tried add/remove features but now that option is not available any more. What can I do about it?
usr-local-ΕΨΗΕΛΩΝ
- 4,862