Thanks for the solution! For some reason, the Mail profile in Mail Session of the my SQL Agent Alert was not set. I set the Mail profile in the SQL...

I restored msdb from other server for hardware migration. The SQLAgent Service account was not in Systemadmin server role and caused the SQL Server Agent service couldn't start due to...

I had the same issue. I forgot that I installed the Analysis Service (AS) after the DB engine was installed, so the AS ended to be another instance.

I was...

I had the same problem that SSIS couldn’t see the column even I can previewed the field in the SSIS.

Due to lack of permission, I couldn’t use stored procedure...

I have the same error - Using a linked server, UPDATE four-part remote view. Even the base table has clustered index and non-clustered unique index, it still won't work.

However,...

I really love a FREE tool - SQL Search from RED Gate - http://www.red-gate.com/products/sql-development/sql-search/.

It seaches pretty much any DB subject, table, view, store proc, columns, etc., very fast....

The select permission should be granted to remote user N not local user M. Please read the instruction carefully.

We have Websense also. you should be able to configure the number of Spin-off websense to keep and configure the sizes of the new databases in the WebSense. The vendor...

I would recommand you to review the installation log on the failed instance to find out the error. There are just so many things can go wrong.

1. Create a login, userN, on ServerN with the permission with select * from DataBaseD.schemaName.Table

2. Add a linked server, ServerN, on SQL 2008 R2 server.

3. On the linked server, map...

I had the same issue on a x64 SQL 2005 server. I used the connection provider "SQL Native Client 10.0" instead of "SQL Native Client" caused the error when...

Thanks Ted. It works for me, too.:-)

Consideration: You might want to consider to have the new server with Win 2008 R2 and SQL 2008. Since you have a new hardware, you have a back out plan...

By reading lots of links and finally got mine working.

My issue was connected to a 32bit Access database from 64bit SQL server running as a job and it throw...

1. Assume the name of the SQL cluster is V2 and the cluster nodes are N1 and N2.

2. Install IIS and RS on the default instance, mssqlserver, on both...