dan-cat
03-31-2006, 08:59 PM
Hello,
Has anyone had experience in connecting to an MSSQL db hosted by Site Ground via MS Enterprise Manager (installed on their local machine)
Couldn't find any relevant documentation in the knowledge base anywhere. Maybe a section on MSSQL dbs in the knowledge base would be a good idea? :)
Many thanks in advance
Dan
PS I'm a new starter with Site Ground and dead impressed with the customer service so far. :)
dan-cat
04-02-2006, 08:34 AM
Hello,
Thought I'd better follow up on this now that I've managed to connect up ok.
The only real issue was that my MSSQL db was located under a different IP address to my account IP. Perhaps this detail could be located somewhere within the Plesk app as I had to raise an advanced ticket to get this info? :)
Anyway, this is how I managed to do it:
1) On my local machine, click start, all programs, microsoft sql server server, client network utiliy.
2) Click the alias tab, click add, make sure the TCP/IP option is ticked under the network libraries section.
3) Still under the alias tab - type any value you like for the server alias
4) For the server name - you'll need to put in the IP address on which your db resides - (I had to ask SG for this info as it wasn't the same IP as my domain account.)
5) Make sure 'dynamically determine port' is ticked then click ok, apply and then ok.
6) Close client network utility and go into enterprise manager.
7) Right-click on sql servers and select 'New SQL server group'. Give a name for your group - make sure the 'top level group' option is selected and click ok.
8) Ricgh-click on your new sql server group and click on 'New SQL server registration'.
Click next,
add your server alias,
click next,
select 'The SQL server login information that was assigned to me by the system administrator (SQL Server authentication)' option,
click next,
Provide the login name and password of the db user that you have assigned to your MSSQL db,
click next,
add your new sql server to the sql server group that you previously added,
click next,
and then click finish.
You should now be able to expland your new server group to reveal all the dbs stored under the IP address you gave. You'll only be able to access your db and the usual test dbs ie pubs and Northwind.
Hope this helps :)