Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
carmenlsh
Starting Member
2 Posts |
 Posted - 2006-09-21 : 04:14:52
|
| I have a report created using reporting services 2005 and I have both SQL Server 2005 Express and SQL Server 2000 installed in my pc.I have no problem to make my report work with SQL Express.When I tried to launch my SQL Server 2000 Enterprise Manager in order to create a new database to work with my report. I got the below error when I tried to connect to the server.===================================================================A connection could not be establish to TEST01\SQLEXPRESS.Reason:[SQL-DMO]You must use SQL Server 2005 managements tool to connect to this serverPlease verify SQL Server is running and check your SQL Server Registration properties(by right clicking on the TEST01\SQLEXPRESS node) and try again.===================================================================Any idea on how to rectify this error. Thanks in advance! ^_^ |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-21 : 08:00:50
|
| You can't use Enterprise Manager to manage 2005 servers, use the SQL Server Management Studio. |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-21 : 17:01:39
|
| Note that SQL Server Express now has SQL Server Management Studio Express, look for it herehttp://msdn.microsoft.com/vstudio/express/sql/download/ |
|
|
|
carmenlsh
Starting Member
2 Posts |
Posted - 2006-09-25 : 03:55:53
|
| Thank you. But how can I use SQL Server Management Studio to make my report connect to the database which I attach into SQL Server 2000? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-09-25 : 12:38:38
|
| You must manage reports in the Report Manager, not Management Studio. Report Manager is at the URLhttp://<servername>/reportsSee here for morehttp://msdn2.microsoft.com/en-us/library/ms155882.aspx |
|
|
|
|
|
|
Pointing RS 2005 datasource to SQL Server 2000