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 |
|
bmmoody
Starting Member
4 Posts |
 Posted - 2008-03-20 : 12:54:14
|
| Can I use SQL Management Studio Express to connect to a standard SQL Server 2005 database? I'm new to SQL Server, I'm trying to figure out how to connect to a remote SQL Server 2005 database. |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2008-03-20 : 13:56:26
|
| SQL studio management is the same for all versions of sql server 2005 (express, workgroup, standard or enterprise). And yes, you can connect to your database even though you have express edition.If you want to connect to remote sql database (either instance or via VPN) you have to link servers (sp_addlinkedserver)or you can use openrowset. |
 |
|
|
bmmoody
Starting Member
4 Posts |
Posted - 2008-03-20 : 15:33:43
|
| As I mentioned, I'm new to SQL Server, and I've been given ownership over a website using SQL Server that is hosted by a web hosting company. What do I need to know about linking servers or openrowset? They said I can connect using SQL studio management, but I haven't successfully connected yet. I get an error saying that the target server actively rejected the connection. |
|
|
|
bmmoody
Starting Member
4 Posts |
Posted - 2008-03-20 : 15:37:04
|
| Part of my struggle is to understand what format convention is used in the "Server Name" field. It seems that if I use a hostname (blahblah.com), then it actually makes contact, but the contact is rejected. If use an IP Address (x.x.x.x), it doesn't seem to even resolve correctly and make contact. Does the convention require a port? blahblah.com:port or x.x.x.x:port? |
|
|
|
scoots987
Starting Member
6 Posts |
Posted - 2008-03-21 : 09:48:38
|
| Can you remote into the server via remote desktop or other means? This way you should be able to manage the server directly.Just a thought. |
|
|
|
bmmoody
Starting Member
4 Posts |
Posted - 2008-03-21 : 11:08:13
|
| I'm guessing the answer is no since this is a shared Windows hosting environment. But I haven't actually asked... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 20:15:05
|
| To connect to that sql server, have to ensure hosting company opens sql port on their firewall. |
|
|
|
|
|
|
Use SQL Management Studio Express?