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.

192 questions
0
votes
2 answers

SQL Server does not exist or access denied on a local machine

I have the following exception when trying to open a connection to the server since last week. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I'm using MSSQL Server 2008 Express Allow remote connections is…
FabricePA
  • 101
  • 1
  • 2
0
votes
1 answer

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an…
Dylan Dodds
  • 1
  • 1
  • 2
0
votes
1 answer

SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!

I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export the column names. How do I get column names to be…
RTB
  • 1
0
votes
1 answer

windows 7 - sql server 2012 - Maintenanace Cleanup Task

My Team Foundation Server creates backups. I want to clear backups that are older than 5 days. Create Maintenanace Cleanup Task in Maintenance Plans of Management of Sql Server 2012. Point there folder, file extension bak, checkbox 'Delete files…
Maxim Yefremov
  • 271
  • 1
  • 3
  • 17
0
votes
1 answer

MS SQL Server 2008 R2 downloads for practice

I plan to download MS SQL Server 2008 R2 SP1 - Express Edition. I know I need one of the two applications to download with it: 1) SQL Server 2008 R2 Express with Tools and 2) SQL Server 2008 R2 - Management Studio Express. Which one (1 or 2) is…
Allan D
  • 1
0
votes
1 answer

SSMS doesn't show all installed Instances

I've installed two named instances (SQLEXPRESS & MSSQLSERVER) but in SMSS, it only shows SQLEXPRESS when I try to connect. How can I connect to MSSQLSERVER from SMSS. Note. SQLEXPRESS was installed first.
Ye Myat Aung
  • 171
  • 1
  • 1
  • 6
0
votes
2 answers

Export SSMS database connections to a new version

I just installed SSMS 2012 and realized it didn't copy my database list (the one that appears on the 'Connect to Server' dialog). I have a ton of entries there, is there any way I can export them to the new version of SSMS?
JoeB
  • 113
  • 2
  • 8
0
votes
1 answer

How to restoring the Registered Server window in SQL Server Management Studio

Is there some way to restore the Registered Server window in SSMS ? I don't mean restoring the individual server details, rather I mean the actual window I've tried clicking the menu item "View \ Registered Servers" and the keyboard short-cut CTRL…
SteveC
  • 271
  • 3
  • 8
  • 21
0
votes
1 answer

SQL Server 2008 Management Studio Express: won't recognize local instance

I’m having a lot of trouble getting Management Studio Express 2008 to recognize my local instance of SQL Server 2008 (SQLEXPRESS). Background: I’ve installed SQL Server 2008 x64 a few times today; I have verified each time that I have installed the…
Rob
  • 135
  • 7
0
votes
1 answer

How do I connect to NAMED INSTANCE of SqlServer 2008 running on custom port from another network?

I have a named instance of MS SQL Server 2008 running on port 1456. TCP/IP and NamedPipes are ENABLED for the server. No Aliases created. local address: 192.168.1.123\RM - works from local computer and local subnet (no ports specified when…
roman m
  • 123
  • 1
  • 2
  • 8
0
votes
1 answer

SQL Server Prod Backup won't restore to dev machine

I looked at the files needed for the db to operate, and changed their paths to the dev's file system. But dev server will not restore the backup file? Do I need to get Master as well as MSDB, or is this a difference between versions of SSMS…
Stephen
  • 3
  • 2
0
votes
1 answer

SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark the "copy-only" flag in Management Studio they…
user102718
  • 1
0
votes
1 answer

SQL Server 2012 - where is Management Studio?

I recently downloaded and installed the RC0 of SQL Server 2012. I followed the installation process as usual, however - I can't seem to find SQL Server Management Studio (ssms.exe). Where can it be found?
shaylh
  • 101
  • 1
  • 1
  • 1
0
votes
1 answer

how to Allow remote SQL connections from specific IP

i use ms sql 2005 server . guide me: how to Allow remote SQL connections from specific IP. Thank all
user168185
  • 21
  • 2
  • 4
0
votes
2 answers

SQL Server: How to edit a view without scripting it?

How can i edit the definition of a view without having to "script" it in SSMS? The previous easy-to-use tools from Microsoft let me: Enter wait a moment Make change Carefully move mouse to large OK button Click OK Down Arrow goto 1 With SSMS i've…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
1 2 3
…
12 13