Saturday, November 30, 2013

Create Sql Server Database on GoDaddy and Connect from Sql Server Management Studio

Hi

Find the below steps to create a SQL server database on GoDaddy and connect it from Management studio

Its difficult to create Sql server database table's and manage their relationship on GoDaddy. Connect Your database from Sql server management studio.

1] Login to your GoDaddy  account  and click on Visit My Account
2] Launch your Web Hosting


Launch Web Hosting



3] from Control Panel -> Go to Databases -> Click SQL Server




4] Click on Add button to create a new database. Add SQL Server database details and click OK


Add Sql server Database


5] Shortly your database will be setup and ready to connect.


database is setup


6] Click on Database Name Link to open the database details.click on Code sample to get connection string for your database.



7] Copy the data source name from connection string  or HostName from database details.


connect from management studio


8] In last step , you will able to access your database (only your database - but you can see all database names created on godaddy sql server  :) strange from godaddy )

connected
Manage your GoDaddy database from sql server management studio
Hope it helps.