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 |
|
Goalie35
Yak Posting Veteran
81 Posts |
 Posted - 2008-09-27 : 18:03:14
|
| I'm having an issue connecting to my database on my web hosts sql server 2008 server. It's trying to connect me to some other database on the server and then throws an error saying I don't have permission to access that database. I'm using management studio 2008 to connect and my username and password are fine.I log in and everthing seems fine at first however, when I try to expand the "Databases" folder on the left hand side of management studio, an error pops up saying I'm "unable to connect 'orrData'" (orrData is some database that isn't even mine).When I called my host, they said it's an issue on my end. That I'm not specifying the correct database but I don't know where to specify a database...all I have is an IP address, username, & password.Any idea what I can do to fix this? Is it something on my end or my web hosts end?Thanks.-Goalie35 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-27 : 18:21:03
|
| Sorry,Sounds like you are trying to login to a db you dont have permissions to login to. Sounds like a shared db server.Scroll down the list of shared databases and Try to expand your database. |
 |
|
|
Goalie35
Yak Posting Veteran
81 Posts |
Posted - 2008-09-28 : 12:55:11
|
| Hi afrika, thanks for the reply.Yeah, it is setup as a shared db server. My problem is that I can't view any of the names of the databases. I click the "Databases" folder to expand the list, then I'm presented with the error (I've included a screenshot here: [url]http://www.mjephotography.com/images/sqlerror.jpg[/url] ). In the image, you can see it's trying to access some database called "oreBrokers", but that db isn't mine. Mine has a totally different name. The username I'm trying to login with is only set to access my database. This is why I'm wondering if perhaps it's a problem on their end.Oddly enough, my username & password works fine in my asp.net application. My website can read & write data to the database. The only problem is trying to get into the database via management studio.Thanks again.-Goalie35 |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-28 : 16:27:05
|
| This is obviously a permissions issue.We just installed MS SQL 2008, and migrated our databases......and noticed it has a lot more improved security than previous versions, Ask your db admin/web host provider to grant you access role/membership to your database. |
|
|
|
|
|
|
|
|
Issue connecting to my web hosts sql 2008...