Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssms]

SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

191 questions
0
votes
1 answer

Cannot delete SQL Server project file?

I have a .ssmssqlproj file in a Sharepoint folder, but I cannot delete it. It says that some application may currently use it. That is not true, because I don't have SSMS open. How to delete this SQL Server Management Studio project file?
atricapilla
  • 605
  • 6
  • 12
  • 15
0
votes
1 answer

How to change schedule of backup jobs using SQL Management Studio

I have an SQL Server 2005 on our lab network, I installed MS SQL Management studio on separate computer to connect to the SQL Server to schedule a backup job of a few database. It worked fine for the backup jobs as scheduled, my question is how am I…
Bonifacio Acebedo
  • 1
  • 1
  • 1
0
votes
2 answers

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection

Sql server is in Mixed Mode and I changed the user Password through Windows Authentication Mode from Security. After that when I try to connect the server it throw the error TITLE: Connect to Server ------------------------------ Cannot connect to…
Azhar
  • 115
  • 3
  • 4
  • 10
0
votes
1 answer

SQL Server: How to create local server group?

In SQL Server 2008 EE, how can I create a local server group? And also, what is the benefit of using local server groups?
atricapilla
  • 605
  • 6
  • 12
  • 15
0
votes
2 answers

How to export a MSSQL table in MSSQL studio express 2005?

is there any way to export a table to a file without any additional tools? I can't install anything on that server.
dan
0
votes
1 answer

SQL Server 2005 Express: Cannot install database diagram support objects

I'm refering to this question where the final solution was When I finally realized this, and connected via VPN to the corporate network, everything worked like a charm. Now in same situation I'm in corporate domain using VPN, still I'm not able to…
IsmailS
  • 101
  • 3
0
votes
1 answer

Display Fusion & SQL Server Management Studio 2008

When opening SQL Server Management Studio 2008 using Display Fusion on Windows 7 with multi-monitor, the software opens, but doesn't display the 'New Server Connection' window, and then I can't close SSMS apart from ending the task on Windows Task…
Curtis
  • 109
  • 1
  • 8
0
votes
4 answers

SQL Server Management Studio - Error connecting to remote DB

All right, here is the deal: I'm connecting to a Windows 2003 Server using VPN. On this server, there is a remote SQL Server 2005 Express engine. I can connect to the database using Visual Studio 2008. What I can't do though, is connect to…
Julien Poulin
  • 135
  • 3
  • 7
0
votes
2 answers

Can't connect to local SQL Server

I'm banging my head against the wall here and can't get things figured out. Yesterday I uninstalled SQL Server 2008 Express and installed a full copy of SQL Server 2008 R2. Everything installed fine but I can't connect to the database to save my…
D.M.
  • 103
  • 1
  • 3
0
votes
2 answers

Can't connect to MS SQL Server database using SSMS

I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will…
user43633
0
votes
2 answers

Does SQL Server Management Studio 2008 Activity Monitor work with SQL Server 2000?

I am trying to use SQL Server Management Studio 2008's Activity Monitor with an SQL Server 2000 instance to diagnose some query performance issues. I can connect SMSS 2008 to the db fine, and use it to browse objects and run queries. But when I…
Andrew Janke
  • 115
  • 5
0
votes
2 answers

What ports does Management Studio use to connect to SQL Server (2005)

I have SQL Server 2005 operating on a remotely hosted server and wish to access it from my own machine using management studio The firewall on the remote server is allready setup to allow all traffic from my external IP - and that works…
Martin
  • 552
  • 4
  • 14
  • 25
0
votes
3 answers

SQL Server Managment Studio 2005 to an Express database

I just installed SQL Server Standard Edition with the Management Studio. I'm able to connect to my SQL server instance but I can't connect to a SQL Server Express instance on a remote computer. Is the Management Studio Standard able to connect to…
Julien Poulin
  • 135
  • 3
  • 7
0
votes
0 answers

Can't login to SSRS (SQL Server Reporting Services) using SSMS (SQL Server Management Studio)

I'm having an issue logging on to my reporting server via SSMS. I use the same hostname\instance found in the reporting server config GUI at the top. This used to work, but I have made some changes recently to support a new SSL cert and now I can…
Arvo Bowen
  • 795
  • 5
  • 15
  • 33
0
votes
2 answers

SQL Server Management Studio connection fails to COM errors

I have an instance of SQL Server 2008 running on a Windows 2008 server. I am able to connect to this SQL server from several machines on my network. However, I cannot connect using SQL Management Studio on the SQL Server itself. When I hit "Connect"…
Justin
  • 895
  • 3
  • 12
  • 26
1 2 3
…
12
13