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 |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2008-04-10 : 19:20:19
|
| I am trying to connect to a sql database using the Connection Properties in SSRS 2005. When I try to connect I get the error message "The connection cannot be tested because the specified database does not exist or is not visible to the specified user.I have check all that I know to do. Are there any other thoughts out there? |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-10 : 19:51:24
|
| Some more info. My server name is IBM-SDGYYZATW04\SQLEXPRESS. I am trying to attach the database in sql server 2005 management studio express and I cannot. What am I failing to do here? I have tried using the user account and just the My Documents account to try to get the database recognized. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 22:18:43
|
| How did you install ssrs? Did you go through rs configuration to create dbs? |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-11 : 10:10:00
|
| Yes I went through rs report configuration. Where should I look to resolve this problem? |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-11 : 10:38:48
|
| I am running SQL Server Management Studio Express 2005 with BIDS. The computer name that appears is IBM-SDGYYZATW04\SQLEXPRESS. I am going through Microsoft Press Reporting Services Step by Step and the database is in the folder per the book.I guess what I really need to do is to copy the Adventure Works database into the SQL Server Mangement Studio Express folder so the Configure Report Server can read it. Am I correct on this? Any other toughts? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-11 : 22:58:23
|
| Is it the db your connection properties point to? If yes, you have to install or attach it. |
|
|
|
|
|
|
Cannot connect to SQLEXPRESS database