SQL Management Studio Exp connect to remote server & manage db tables

[crabback]

Hi,

I'm developing an asp.net site that uses a MSSQL Server 2005 Express database for its content. My hosting company has told me I must create the database directly on their server by using their online control panel, which I have done. To create the tables I must use the Management Studio to connect to this remote Server: mssql2005express.webhost.ie\helm
How do I do this in the Management Studio?

Thanks in advance


Crabback

 

[fuzzyocelot]

You can try to create an alias through the Configuration Manager.

 

[mrdenny]

You won't be able to connect to the server with your management studio client directly. The hosting companies firewall will prevent direct access to the database via the Internet.

Odds are your only option for creating tables, procedures, etc will be via the tool they provide you.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog