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
0 answers

How best to allow SQL Agent Jobs to be edited and run by a team of developers, without handing out Sysadmin rights?

I'm trying to find or devise a way to allow a team of developers to be able to amend SQL Agent Job steps and schedules, but that doesn't involve Sysadmin rights for the devs. As I can't assign ownership of Agent jobs to a Group I need some sort of…
Potatan
  • 13
  • 8
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
  • 915
  • 3
  • 13
  • 26
0
votes
1 answer

Accessing SQL Server Remotely - Connection fails when attempting to connect with new external domain

The Scenario is: Right now, we can remotely access SQL server using SSMS or a ODBC connection using the SQL driver. We are currently using sql1.mydomain.com We are switching to sql2.mydomain.com. When I attempt to connect with SSMS, I get the…
Influence
  • 11
0
votes
1 answer

SQL SERVER Express Connection String for User Instances same on SQL Server Standard

So SQL Server 2005 Express edition has the following connection string by default, which enables user instances instead of Concurrrent Multi-User Access: Data Source=.\SQLExpress; AttachDbFileName=|DataDirectory|\dash.mdf; Integrated…
Justin
  • 189
  • 1
  • 8
0
votes
1 answer

Which is my SQL server name for connecting to the online database by SSMS?

I created a database 'dbDemo' (MS SQL Server 2012) by Plesk on Google Cloud Platform and for connecting to this database from another local machine I changed the TCP Port 1433 on my online server using this link guidelines. and I am able to login…
user3786581
  • 113
  • 4
0
votes
1 answer

SQL instance IP address pointing to the SQL server hostname

Our SQL instances IP addresses are pointing to the same DNS entry (which is the SQL server name) although the TCP/IP is enabled. My question is, how do you set up the SQL instances IP address and instance name properly so we can access it faster in…
neb
  • 11
  • 1
0
votes
1 answer

sp_xp_cmdshell_proxy_account on a SQL Server Express

I am trying to find information about if there are limitations in SQL Server Express to not being able to run the sp_xp_cmdshell_proxy_account and adding a proxy account for the cmdshell command? Because I'm getting errors while trying to add the…
Arto Uusikangas
  • 101
  • 2
0
votes
2 answers

SQL Server 2005 -- Not Able To Export Using Management Studio Express

I heard this was not available with the free express version. I need to move a moderately sized database to another computer. How can I most easily accomplish this task? We are not in a position to buy any software at the moment. Thanks for any…
bobber205
  • 241
  • 1
  • 6
  • 17
-1
votes
1 answer

Use reporting service configuration to configure the database source name

So im upgrading to R2. When i get to the Reporting Services Authentication step i get the error: There are validation errors on this page. Click ok to close this dialog box. Review errors at the bottom of the setup page, then provide valid…
CathalMF
  • 131
  • 1
  • 1
  • 4
-1
votes
1 answer

Connect to SQL Server from different network (remote)

I am new to SQL server stuff and recently thought of creating a Database for my website. I would like to stop things like comments, blog post, stuff like that. But I am trying not to pay for SQL server space. I have although a copy of Microsoft SQL…
Some Random User
  • 1
  • 3
-1
votes
1 answer

SQL Server Maintenance Plan Wizard

Using SQL Management Studio 2012, when I right-click on an existing Maintenance Plan, and select the "Maintenance Plan Wizard" option from the context menu, what launches is a wizard to create a new maintenance plan. I need to open the wizard to…
Shawn de Wet
  • 135
  • 4
-1
votes
1 answer

Backup MSSQL database via disk (no SSMS no command line)

Our Windows server is having issues but before running disk repair, I want to take a backup. At the moment I'm using SystemRescure (the Linux utility) and I have successfully saved files. The only problem I have is that I need to take a backup of…
user1274113
  • 99
1 2 3
…
12
13