1
vote
0answers
61 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
0
votes
1answer
339 views

Unable to restore database using Microsoft SQL Server Management Studio Express

I am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express. It gives following error message: Too many backup devices specified for backup or ...
0
votes
2answers
50 views

How to remotely administer SQL Server 2005?

I have administrative RDP access to a server (call it ServerA) that has access to a SQL Server 2005 service (on ServerB). I do not have RDP access to ServerB, but would like to be able to use SQL ...
2
votes
3answers
230 views

How can you schedule a database backup on SQL Server 2005?

Not really familiar with MS SQL Server, but I did figure out how to manually backup a database locally: In SQL Server 2005 ( SP2 ) using MS SQL Server Management Studio : I navigate to ...
0
votes
1answer
734 views

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 ...
0
votes
2answers
1k views

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 ...
4
votes
2answers
210 views

Installing .NET 1.1 over later versions: Safe?

I have a server that is running all versions of .NET Framework, from 2.0 up to 4.0. An application I need to deploy won't run correctly on later versions, and was originally compiled for 1.1. Is it ...
0
votes
1answer
2k views

Can you make a SQL Server Maintenance Subplan run after a previous subplan completes

I have a maintenance plan to do backups and cleanup of old data. It has three subplans, each with their own schedule. Can I set the schedule of subtask 2 to be "after subtask 1 is complete"?
2
votes
2answers
4k views

Change Windows Authentication user for Sql Server Management Studio

We're using Sql Server 2005 with Windows Authentication setup. So normally, when you log in using e.g. Sql Server Management Studio, it forces you to log in at MACHINE_NAME\Username. Anyways, on this ...
1
vote
1answer
1k views

Some rows giving “String or binary data would be truncated” error when editing in Management Studio

When trying to add data to a newly created column using SQL Server Management Studio (edit rows), I am getting the following error: No row was updated. The data in row 1 was not committed. ...
1
vote
1answer
4k views

SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. ...
0
votes
1answer
412 views

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; ...
2
votes
2answers
116 views

Can I use MSSQL2005 Management Studio to login to MSSQL2008 Express?

Can I use MSSQL2005 Management Studio to login to MSSQL2008 Express? Is that a must for me to install MSSQL 2008 Express?
3
votes
4answers
6k views

Timeout saving table in SQL Server

I'm trying to add a column to a table with much data in SQL Server 2005, using SSMS. So I browse to the table, select Modify, and add the new column. Then, when I press Save, I get the following ...
3
votes
7answers
7k views

SQLServer - need to access an ACT! database for data migration

I'm looking for a way to access data in an ACT! database for a data migration to a custom application. The ACT! software uses SQLServer 2005. The data conversion script and new application will be ...
3
votes
2answers
734 views

SQL Server Management Studio not scripting all objects

i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the ...
1
vote
2answers
1k views

Why is SQL Server 2005 hanging up when I try to delete a database?

I've got a Windows 2003 server with SQL Server 2005 and when I log into the Management Studio, right-click on a Database and choose "Delete" I get the Delete Object dialogue. I then click OK at the ...
0
votes
4answers
7k views

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 ...
0
votes
3answers
182 views

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 ...
2
votes
3answers
6k views

SQL Server 2005: Copy SQL Server Agent Job?

I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an ...
5
votes
2answers
5k views

Using SQL Server 2008 Management studio to connect to SQL Server 2005 databases

I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio. I log on with SQL ...
1
vote
5answers
569 views

Error when trying to view properties in Management Studio

I am having trouble with sql manager after install SQL 2005 SP3, Can any shed any light on this one. Thanks TITLE: Microsoft SQL Server Management Studio Cannot show requested dialog. ...