All Questions
Tagged with sql-server sql-management-studio
23
questions
1
vote
1
answer
533
views
SQL Server started, but SQL Server Management Studio not connecting to it
Problem statement
I have installed (Developer Edtion) and started my SQL Server, but when trying to connect to it through SQL Server Management Studio, it shows this error:
My configuration for SQL ...
2
votes
1
answer
287
views
Apex SQL complete freezes SQL management studio
I am using SSMS 18.4
I installed APEX sql complete, and every 30 minutes it freezes my management studio.
So I'd have to go to Task Manager and end it from there.
Did anybody have issues like ...
- 138
0
votes
0
answers
305
views
Trying to connect to SQL Server through SQL Server Management Studio for the first time won't connect
Hey all so my problem is that I try to connect before even accessing the object explorer or anything and have ended up with this error. I've tried using Windows Authentication which is what I want to ...
- 1
0
votes
0
answers
112
views
Issue with Microsoft SQL server management studio 2019
When i installed Microsoft SQL server management studio it runs properly with no issue but i have installed XAMPP for mysql on my system but when i run it afterwards SQL server does not working.
does ...
0
votes
1
answer
267
views
SQL server 2016 connecting to SQL Management Studio
I am using a SQL Server Management Console and the SQL Server 2016 Evaluation edition trying to connect a local server on Windows 10. I am connecting to an Azure cloud instance cluster because I have ...
0
votes
1
answer
1k
views
Rename SQLServer instance after rename computer
I have SQL Server 2012 running on Windows Server 2012. I renamed the Windows Server and need to adjust the SQL Server for the new name to get my Maintenance Plans running.
When I run Select @@...
- 121
1
vote
0
answers
810
views
Can't connect to database in SSMS 2017
I used to be able to connect, and now I can't. I have tried uninstalling and reinstalling SSMS. I have not changed my antivirus/firewall settings at all.
OS: Windows 10 Home
TITLE: Connect to Server
...
- 1,182
2
votes
2
answers
365
views
How to trigger SQLServer suggestion popupmenu
I have a very big job to do on a very large SQLServer DB, with unusually large table names.
Having the popup menu suggesting the names of the tables and such, would really come in handy, but it ...
- 163
0
votes
2
answers
1k
views
Restore Failed for server; Cannot open backup device; The system cannot find the file specified
I am trying to restore a database in sql server management studio in sql 2008 using these steps:
Open SQL Management Studio.
Right Click on Databases.
Choose "Restore Databases..."
Enter a "To ...
3
votes
4
answers
7k
views
SSMS 2017 - How to restore .sql file association?
After installing SQL Server Management Studio 2017 and uninstalling SSMS 2016, Windows 10 shows the "How do you want to open this .sql file" screen every time I try to open a sql file.
When I look at ...
- 166
2
votes
1
answer
3k
views
Always encrypt connection from SQL Server Management Tool
I've noticed that the "Encrypt connection" checkbox seems to default to unchecked.
Is there a way to default this to being checked?
- 133
8
votes
3
answers
3k
views
SMS slow when connecting to Azure SQL Server
I host 2 databases on Azure SQL Server Db. Two very small 40Mb databases. Very limited access to them. If I look at my DTU, its like 0 peaking at 5%.
However when ever I open either of the databases ...
- 201
2
votes
2
answers
3k
views
SQL : Restrict view of tables in database
This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
- 21
-2
votes
1
answer
66
views
How to install MS SQL Management Srudio for SQL Server 2008?
I have downloade SQLManagementStudio_x86_ENU.exe file, but when I run it, it starts global SQL server 2008 installer where I can't find any signs of Management Studio.
- 12.8k
5
votes
1
answer
3k
views
Copying out color theme background from SQL management studio to Outlook
I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
- 151